Adding the Clustered Key To Your Nonclustered Index? Part 2

Of course, a rather obvious answer presents itself the next day.  After reviewing the actual environment that my colleague was...

Feb'2013 Chennai SQL Server UG Meet Is Scheduled

 Chennai SQL Server user group meet is scheduled for Feb'2013.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30...

Handling Null Values in SQL Server

What is NULL?

In SQL, A Null is an unknown or undefined value. Some interesting
operations on NULL.
--query                 --resultselect 3*NULL      --NULLselect 3+NULL     ...

I’m Speaking at ….

Last week I noted that I was speaking at the new SQL Intersection event. Hopefully I’ll see some of you...

Installing Team Foundation Server (TFS) 2012

My experience installing Team Foundation Server (TFS) 2012 to house my business intelligence projects built in Visual Studio 2010:
I am installing...

Join Me at Modern Apps Live! Las Vegas

If you are familiar at all with Visual Studio Live! then you should check out this new conference.  At the...

Microsoft SQL Server License Helpline

Microsoft SQL Server license has lots of flavors in terms of user based \ CAL or processor based license, license based...

Partitioning Relational Data – (Part – 2)

This is the second part of the three part article series on partitioning relational data. 
In the first part of this...

SQL Backup and Recovery – new distribution

I recieved an email today from my publisher Joes 2 Pros that my book was now available on Barnes and...

SQL Server 2008 R2 Diagnostic Information Queries (Feb 2013)

Here is the February 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and...