Prepping the security for a data warehouse
So in an earlier blog post I talked about how I had to grant some users the ability to create indexes in a reporting server. A couple of people have asked me how I created the domain groups and ensured that the permissions were setup correctly. In this case I did this with two SQL […]
Giving users the ability to create indexes
So I ran across a pretty interesting requirement when setting up a new reporting database server. The end users who run queries against the databases on this server are pretty good at performance tuning their own queries so they wanted the ability to create indexes on the tables on the reporting server. I figured no […]
What do I do with Standard Edition SQL Servers using Mirroring
With the release of SQL Server 2012 many of the people who are using Standard Edition and Database Mirroring are quite nervous about what their HA options are going to be moving forward, and rightfully so as Microsoft has been pretty silent on this specific topic. Let me see if I can’t calm your fears […]
What do I do with Standard Edition SQL Servers using Mirroring
With the release of SQL Server 2012 many of the people who are using Standard Edition and Database Mirroring are quite nervous about what their HA options are going to be moving forward, and rightfully so as Microsoft has been pretty silent on this specific topic. Let me see if I can’t calm your fears […]