The EXCEPT Query

When Work Isn't Done

Today Steve looks at the case when one software developer finishes their work, but another doesn't. The challenge of reordering work is something that happens more and more as teams struggle to coordinate their efforts.

Finding Object Dependencies in SQL Doc

I had a customer recently ask if they could find out which objects are dependent on others using SQL Doc. This post shows how to do that. Using SQL...

Multiple Encryptions

Not Useless Features

There are some useless features in SQL Server, but Steve Jones wants to know which ones aren't and need investment.

SQL Server Central Is Upgrading Our Servers

The SQL Server Central database servers are being upgraded on Thursday, Nov 2.

Degree Apprenticeships

Training more people on the job, while still allowing them to continue their education is something Steve thinks would help more people get started in technology.

Parsing Strings

A New Word: Funkenzwangsborstellung

funkenzwangsborstellung – n.  the primal trance of watching a campfire in the dark. I am not a big camper, but 3-4 times a year we usually go out with...

Adding a FK in a CREATE TABLE