The Hash Join I

Comparing Images

Simple Talks Episode 9–Data masking and subsetting

The episode on data masking and subetting is out. You can see it here: Youtube Spotify Watch and check this out. This is especially close to my heart as...

Monday Monitor Tips: Projecting Disk Space

One of the things that many DBAs struggle with is managing space across an estate. There might be one or two servers that you watch closely, or that are...

Time to Change Your Team

Many of you can't choose your team, or even change teams if you want, but from an organizational perspective, it might be the right thing to do. Whether you like it or not.

A New Word: Skidding

skidding – v. intr. the practice of making offhand comments that sound sarcastic but are actually sincere and deeply felt. I used to make lots of sarcastic comments. Some...

Backing up the Database Encryption Key

Technology Fears

Steve is asking today what technology scares you.

Using SQL Compare in Read-Only Databases

Recently a customer asked if SQL Compare and SQL Data Compare can be used with a read-only database as a source. It’s a good questions as I’ve seen some...

Using Copilot to help me update SQL Saturday

An interesting AI experiment here with Copilot from GitHub in handling some code I don’t work with that often. Read on and watch. This is part of a series...