In 2012, It’s Me and Vanilla Ice

Like many others, I’m planning a few changes for my life for next year.  I’m a believer in finding one’s...

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

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

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

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

Dynamic Sorting in SSRS

Introduction
Many times while developing any report we come across a situation where we need to SORT the TABLE columns or...

SQL Server A to Z – YEAR

SELECT 'Happy '+ DATENAME(dw, GETDATE())Welcome to the penultimate installment of SQL Server A to Z (it’s not often I get to...

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