Backing up the Service Master Key

Making a backup of your Service Master Key (SMK) should be one of the first things that you do if...

Modifying SQL Server Synonyms – this time with Powershell

So, how do you recover from the Holidays? Hot Cocoa by the fire? Relaxing evening with your spouse watching an...

Revamping Surat User Group

Dear Friends, we had a user group meeting last week – I and Vinay Pugalia was  here. We have discussed many...

SQL MCM Study Group

Over the last few days, you may have noticed that there’s been a bit of talk about a SQL Server...

SQL Server 2008 R2 RTM Cumulative Update 11

On December 19, 2011, Microsoft released SQL Server 2008 R2 RTM Cumulative Update 11 (CU11), which is Build 10.50.1807.0. I...

SQL Server 2008 R2 SP1 Cumulative Update 4

On December 19, 2011, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 4 (CU4), which is Build 10.50.2796. I...

Twas The Week After Christmas....

Holiday Greetings to all you DBA's and SQL Server professionals! This blog goes out to all of you who are on-call...

Webcast: Putting a Better SQL Server in Production

Webcast: Putting a Better SQL Server in Production
Production Line

Webcast:Putting a Better SQL Server in Production
Date: Wednesday, January 18, 2012 3:00...

SQL Server – How to identify service pack installed

Identifying current service pack installed for SQL Server can be difficult if you don’t know which command to use! Most...

SQL Server 2012 RC0 and beyond

Since the stable and mainly feature-complete versions of SQL Server 2012 have been available, I have been heads-down on multiple...