Using SkyDrive at Work for Collaboration - A Quick Start Guide

It seems that many of my projects in the past year or so have required sharing files with external business...

A Month of PowerShell – Day 5 (Scripting – Putting it together)

Welcome to Day 5 of my “A Month of PowerShell” series. This series will use the series landing page on...

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