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

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