Friday Flyway Tips–Capture the Filegroup for Tables

A customer asked recently why Flyway doesn’t detect the filegroup for some changes. I showed them it does and decided to write a post on this. I’ve been working...

Friday Flyway Tips–Quick Command Line Access

One of the things I had to do recently in a demo was access the Git command line. The way I did it impressed a customer, so I put...

Using AI for Security

Steve thinks AI might have a place in security, something Microsoft is investigating now.

Writing to Clones

Moving Dynamic Data Masked Data to New Locations - Step 5 of the Stairway to Dynamic Data Masking

In this level of the Stairway to Dynamic Data Masking we examine how masking affects data movement.

Query Execution Modes

The Art of the Code Review

Code reviews are a good way to not only improve your quality, but also raise the skill level of your staff.

Knowing String Defaults in T-SQL–#SQLNewBlogger

For years I’ve assumed I knew the string defaults, but I realized that’s not right. This post looks at what I learned. Another post for me that is simple...

The Dangers of Not Upgrading

Steve thinks that waiting too long to upgrade can be problematic.

A New Word: Proluctance

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward to – opening a decisive letter, meeting up with a friend who’s finally back in...