Inserting Sequences

T-SQL Tuesday #184–Mentoring

This month’s T-SQL Tuesday blog party is hosted by Deborah Melkin, and it’s a good one that asks us where we are making the world better. The topic is...

Partial Backups II

Understanding a Database

The ways in which you might try and reverse engineer a database design are on Steve's mind today.

What is Deferred Name Resolution?

One interesting concept in SQL Server is Deferred Name Resolution. This is something many developers struggle with understanding how this works and where it works. In the Microsoft docs,...

A New Word: Waldosia

waldosia– n.  a condition in which you keep scanning faces in a crowd looking for a specific person who would have no reason to be there, as if your...

Counting Bits IV

Tracking Table Sizes

Today Steve asks if you track the details of your table growth inside a database.

T-SQL Tuesday #183: Improving Permission Management

This is my (late) answer to my own invitation for T-SQL Tuesday #183. I was very busy a few weeks ago when the invite when out (glad it was...

A Quick Test Data Manager Eval with My Database Backup

I wrote about getting the Redgate Test Data Manager set up in 10 minutes before, and it was a great post. In that one, the sample database Northwind was...