The Side Job

Today Steve asks about those jobs you've had that aren't related to data or databases.

A Note and a Message: T-SQL Tuesday #193

This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he hosted (back at #4), but he answered my call for hosts and I appreciate that....

The Book of Redgate: Spread across the world

This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia I miss Brad. I enjoyed traveling around and working with him. I’d forgotten about Bob...

The Tally Table

The tally table is a valuable tool for a SQL Server developer, but how many of you understand how to create and use one?

UNISTR Escape

The DBA's Twelve Days of Christmas

On the first day of Christmas my new DBA sent to me A table with a primary key On the second day of Christmas my new DBA sent to me Two Foreign Keys, and A table with a primary key On the third day of Christmas my new DBA sent to me Three stored procs […]

The Max PK Length

What's Your Area of Expertise?

We might be smart in one area, but not others. That's worth remembering.

The Microsoft SQL Year in Review

Microsoft gives a year in review from the SQL Server and Azure SQL teams. Steve sees a lot of accomplishments from this past year.

A New Word: Etherness

etherness – n. the wistful feeling of looking around a gathering of loved ones, all too aware that even though the room is filled with warmth and laughter now,...