SMKs, DMKs, Certificates for TDE and Encrypted Backups
This article details SMKs, DMKs and certificates in SQL Server as they relate to Transparent Data Encryption and Encrypted Backups.
Custom Built Statistics
Dan Holmes shows how you can create statistics exactly the way you want within the bounds of the 200 steps available.
Automated Rapid Recovery during Database Code Releases using Snapshots
Leveraging snapshots across multiple databases simultaneously to allow for quick rollback in case of a problem deploying code
Building Better Communication Skills
Today Steve Jones reminds us that our communication skills are important. They are something that we use constantly at work and are worth developing.
De-normalize database schema using JSON
Jovan Popovic talks about transforming complex relational structures into simpler tables using JSON format.
IT Data Governance and the Insider Job
Good IT data governance is about crime-prevention as well as crime-detection. Legal action runs war a close second as being one of the more futile and debilitating of human activities, so prevention is always better.
The Office
Would you be more productive outside of an office? Would you take a pay cut to work outside of an office? Steve Jones notes that a number of IT professionals said they would.
The SQL of the Feast Days of Western Christendom
Phil Factor's newest SQL expression calculates when all the feasts and saints days are, giving you plenty of potential causes for celebration.
Copy a database between servers with one command
This tool is a helper for your daily work to copy easily databases between Servers/instances and do all the necessary stuff for you.
Gratitude
Today we have a guest editorial from Erin Stellato that reminds us that we have had support from many, and it's important to thank them from time to time.
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers