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.
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers