Invitation for T-SQL Tuesday #39 – Can you shell what the PoSH is Cooking?

T-SQL Tuesday Party History
In case you’ve been hiding out in the desert, oblivious to all that goes on, there is...

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

What is DBCC SHOW_STATISTICS Telling Me About My Data?

Per Books Online, DBCC SHOW_STATISTICS displays current query optimization statistics for a table or indexed view.  Basically it shows you...

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

Overconfidence – How it Almost Cost Me and What You Can Do to Avoid It

It was early one morning and I was working on a production deployment to add a new Subscriber to an...

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

The Value of Certifications

A former co-worker recently sent me an email asking about Microsoft certifications, and if I pursued them, and what I...

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

SSIS Webinar in 3 days... 6 seats left

Our first SSIS 1h Free webinar will take place in 3 days (Thursday) and has only 6 seats left (out...