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...

Picking a Starting Table in Test Data Manager

I wrote about getting the Redgate Test Data Manager set up in 10 minutes before, and a follow up post on using your own backup. One of the things...

Test Data Manager in Under 10 Minutes

Test Data Manager (TDM) is a suite of products from Redgate that make it easy to build dev and test databases in seconds. It’s a nice rewrite of a...