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


9 reads


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


VSCode Tips–Remove the Highlighted Line


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

Use T-SQL, not the GUI


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


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers