SQL Server Diaries

With the upcoming SQL Server 2012 version, Microsoft reduced the number of Editions to three and changed the licensing model. The main Editions that will be available are the Enterprise, Standard and the new Business Intelligence. Features of the Datacenter Edition have been included in the Enterprise Edition making this... [Read More]

In a Microsoft Cluster environment offering High Availability, a failover to the Secondary (or alternate) Node is usually set to automatic (to maintain the HA). The DBA then has to resolve the issues that caused the failover then fail the services back to the Primary Node. Of course the DBA... [Read More]

In an earlier post I explained how we identified which indexes were being used, and the number of times used over a period of time. We had a good indication of a similar solution in a MSSQLTips article. [Read More]

A couple of scripts I use occasionally help me report the space used by FILEGROUP and the Log Space used are shown below in this article. [Read More]

In an organisation where Development, Test and Production environments are segregated and managed by a central team of DBAs sometimes developers or testers require a higher degree of privileges to specific users or groups of users in order to implement schema changes, creation of roles, etc. [Read More]