Bert Wagner

Joining on NULLs

It’s important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect. Today I want to look at what...

2019-03-26

9 reads

COUNT, DISTINCT, and NULLs

Watch this week’s episode on YouTube.
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT)...

2019-03-05 (first published: )

2,681 reads

Why make?

This post is a response to this month’s T-SQL Tuesday #111 prompt by Andy Leonard.  T-SQL Tuesday is a way...

2019-03-01 (first published: )

3,216 reads

Blogs

VSCode Tips–Remove the Highlighted Line

By

VSCode was making me crazy as I was writing a script. I like a...

Use T-SQL, not the GUI

By

There’s a very good reason to do most of your DBA work using T-SQL,...

Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".

By

To be honest you probably think that migrating to the cloud sounds great, and...

Read the latest Blogs

Forums

SQL Tamagotchi! Mini-Servers as Database Pets

By Phil Factor

Comments posted to this topic are about the item SQL Tamagotchi! Mini-Servers as Database...

SQL 2014 (or any other versions) Standard - ~Embedded Licensing~

By Warren Peace

Anyone have any insights on how this licensing works and what the "Use Rights"...

SSIS - Adding Columns to existing table and load data

By sunshine

I am working in SSIS (Sql server version 2012) , I have a requirement...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers