A Full Shutdown

Steve used to shut down systems to upgrade them, but lately he makes changes while they're running.

OPENQUERY Flexibility

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

T-SQL Tuesday #196: Taking Risks

This month we have a new host, James Serra. I’ve been trying to find new hosts over the last few years to keep this party going and to expand...

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

Monday Monitor Tips: AI Query Analysis

AI is everywhere. It’s in the news, it’s being added to every product, management wants everyone to be more productive with AI. Redgate Monitor isn’t immune from this wave....

Not Just an Upgrade

Choosing to upgrade isn't as simple as many of us would like. Steve has a few thoughts today on the decision to move to a new version of a database server.

Restoring On Top I

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.

Advice I Like: In 100 Years

In 100 years a lot of what we take to be true now will be proved to be wrong, maybe even embarrassingly wrong. A good question to ask yourself...