Puzzles–T-SQL Tuesday #114

This month we have a very interesting topic from Matthew McGiffen. He gets back to the roots of the party with code by asking a question on puzzles. It’s...

Where Do You End Up as a DBA?

Steve Jones talks about careers, and where you might take your career over time.

A Clean Values Clause with SQL Prompt

I’ve had this code in a snippet for a long time: I appreciate the markup to prevent SQL Prompt from doing this, which used to always happen. I can’t...

Communicate Smarter Not More

After installing Microsoft Teams, Steve has a bit of communication overload.

Preventing a SELECT

The Mobile Lab

Hardware is the interesting topic of the week for Steve.

Initialize-HgsServiceName Fails in VMWare

A short one, but one that took some digging and debugging and help from others. Saving here, so I remember, as do others. I had a VMWare Workstation v12.x...

Service Broker Contracts

The Impediments to Change

SQL Server is releasing a new version of the engine every 12-24 months at this point. That puts pressure on all of us to learn constantly about the changes. Even if we don't look to upgrade all of our existing instances, we can't buy older versions when the new one is released. Often many of […]

Strange Sorting