Bert Wagner

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,708 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,220 reads

Blogs

Daily Coping 9 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

The Manager’s Guide to Git Training for DBAs (Video / Podcast)

By

Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss...

Snowflake – Understanding constraints

By

One of the concepts in Snowflake that I find many struggle with is how...

Read the latest Blogs

Forums

Azure Analysis Service: Process Tabular Model with SSIS

By Lidou123

Hello, I hope you are well. I know this is not the right place...

how to convert the below procedure into ssis for each loop and send mail task

By mcfarlandparkway

I am tryting to convert the below procedure into SSIS, even if i get...

Script works on one server, errors on others

By Footage

I am running a script that yields exactly what I'm looking for in test,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers