A colleague asked me a very simple question: “How do I know to use row or page compression in SQL Server?” That’s what this post is for, to help provide some clarity on row versus page compression. You’re welcome.
I want to help in the struggle against the adversaries. I’ve identified seven data security measures you can use. These ‘Seven Samurai’ will protect against all three possible attack vectors: data at rest, data in use, and data in motion.
Last week I wrote about the Meltdown and Spectre vulnerabilities. Today I want to show you how to check if your database server is protected against Meltdown and Spectre.
Today Microsoft released a KB article to provide guidance for SQL Server installations in response to the Meltdown and Spectre side-channel attacks. You should take the time to review that KB article. Here’s what Microsoft has to say about performance.
The SQL Vulnerability Assessment (VA) feature in now available in SSMS (SQL Server Management Studio)!
I think we should all take time to ask ourselves the simple question, “What’s in your database?”
