SQL Server 2012 Diagnostic Information Queries (December 2011)

Since the final RTM release of SQL Server is getting ever closer, I thought it was a good time to...

SSAS – Display Folders

Display folders are an often used tool in Analysis Services to help end users navigate through a cube or dimension...

Why doesn’t my gauge show correct values?

Here is an issue I encountered recently while using gauge in reporting services.

There are three gauges in the report one...

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...