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

I hate Windows 8 and Microsoft Top 3 Mistakes

What do you think about Microsoft new Operating System? I hate Windows 8! This is the answer that many people...

Duplicate rows in a table

I recently got the following email:
“I just keyed in two rows into a table with all identical column values. How...