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 ...
2013-02-05
540 reads
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...
2013-02-04
664 reads
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...
2013-02-04
496 reads
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...
2013-02-04
641 reads
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...
2013-02-04
1,412 reads
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...
2013-02-04
1,002 reads
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...
2013-02-04
700 reads
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....
2013-02-04
1,409 reads
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...
2013-02-04
1,017 reads
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...
2013-02-11 (first published: 2013-02-04)
3,282 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers