Hidden Heroes

DBAs might be the hidden heroes in many organizations.

Identities and Sequences I

The DIY Cost of Masking Test Data For Smaller Organizations

One of the things I’ve tried hard to do in database development situations if ensure I could easily refresh dev and test environments on demand. In a small startup,...

Changing Data Types

Steve had to deal with a customer that changed data types in columns often. Is that something you experience?

Finding and Updating Duplicate IDs: #SQLNewBlogger

Finding duplicates was an interview question for me years ago, and I’ve never forgotten it. Recently I got asked how to easily do this and delete them, so I...

Fun with JSON II

Whiling away an afternoon, thinking

I come to Heathrow often. Today is likely somewhere close to 60 trips to this airport in my lifetime. After over 19 years of working with Redgate (plus a...

Webinar: Compliance Without Compromise: Test Data Management That Finally Fits

You know you shouldn't have production data in test environments. But every time you look at fixing it, the options feel impossible: enterprise tools that cost six figures and take months to implement, or DIY scripts that sort of work until they don't. Join this webinar on Mar 18 to learn more.

Breaking Down Your Work

Self-assessment and self-examination can be important in many fields, especially technology in the age of AI.

Flyway Tips: Multiple Projects

One of the nice things about Flyway Desktop is that it helps you manage your database code as a project and see what changes are being built. However, many...