Backup Encryption Performance
Unlike TDE, there is some extra CPU overhead when you take an encrypted backup as the data has to be encrypted before being written to disk – whereas with...
2023-06-05 (first published: 2023-05-22)
265 reads
Matthew McGiffen DBA
Why you still need DBA resource in the cloud
Why a DBA, rather then being redundant, is even more valuable when your databases run in the cloud.
2023-05-31 (first published: 2023-05-19)
433 reads
Backup Encryption in SQL Server
In this post we look at how you work with the Backup Encryption Feature in SQL Server.
2023-05-18
77 reads
2023-05-17
53 reads
Top Tools for SQL Server Performance Troubleshooting
When you've got the symptoms of a database issue you can run a series of diagnostic queries to try and drill down on the problem and then start figuring...
2023-05-26 (first published: 2023-05-16)
642 reads
TDE: Database Backups and High Availability
Database backups continue to work without change when you have TDE enabled. The only difference is that the backups contain encrypted data that cannot be read without the certificate...
2023-05-15
29 reads
The Importance of SQL Server Performance Tuning in the Cloud
Make sure your cloud SQL Server databases are optimized and achieve significant cost savings.
2023-05-12
98 reads
Implementing Temporal Tables Where You Have Existing Data
An in-depth look at how you convert an existing table with data to a system versioned table that will maintain a history of changes.
2023-05-11
121 reads
Impact of TDE on Performance
Microsoft states that enabling TDE usually has a performance overhead of 2–4%. That doesn’t sound like very much, and personally I wouldn’t let it bother me if I want...
2023-05-24 (first published: 2023-05-10)
942 reads
Errata for my book: Pro Encryption in SQL Server 2022
My biggest fear when my book went into production was that any factual errors had slipped through my checks and the various reviews. I had a lot of reviewer...
2023-03-21
27 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers