-
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 out solutions. There are a number of free tools out there though that can speed up that process immensely. In this post we’re going to look… Read more
-
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 and private key. There are a couple of points that are worth discussing though. Backup Performance Following on from general questions of TDE performance, it’s sensible Read more
-
The Importance of SQL Server Performance Tuning in the Cloud
Make sure your cloud SQL Server databases are optimized and achieve significant cost savings. Read more
-
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. Read more
-
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 to make sure my data is encrypted at rest. However, you may have heard other sources saying that it’s actually a lot more than that –… Read more
-
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 support from Apress, but at the end of the day any issues are my responsibility. So far I’m not aware of any factual errors but one Read more
