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

Last Weeks Top 10 “Reading” Links #18

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out...

SQL Saturday 220 Atlanta GA

That latest installment of SQL Saturday Atlanta was just announced. On May 18th 2013 SQL Server experts from all over...

Exploring Excel 2013 as Microsoft’s Business Intelligence Client

A little over six months ago, I wrote an article on Magenic.com about Excel 2013’s Impact for BI Users.  This...

A Month of PowerShell – Day 4 (Scripting)

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

Adding the Clustered Key To Your Nonclustered Index?

A colleague of mine was understandably confused when using the almost-perfect missing index engine in SQL 2008. The engine recommended he include...

New DMO in Azure SQL Database: sys.dm_db_wait_stats

I just did a series of Boogle searches and when that didn’t find anything I tried Ging. Neither listed sys.dm_db_wait_stats....