The SQL Server Tiger Team Bookmarks
Last week while at the Microsoft MVP Summit, I had the honor to attend a session delivered by Pedro Lopes who shared a detailed a list of SQL Server Tiger team bookmarks.
sql server
The 7 Data Migration Mistakes You’re Probably Making
Look, data isn’t perfect. Sometimes data migrations fail because the data itself is the issue. But the reality is that many failures are human mistakes that can be avoided.
SQL Data Discovery and Classification
The new version of SQL Server Management Studio (v17.5) brings with it a new feature: SQL Data Discovery and Classification. You might recall that in SSMS 17.4 the Vulnerability Assessment feature was added. So, that’s two new features in the last two releases. This is the beauty of de-coupling SSMS from the SQL Server install … Read more
Data Migration Assistant Custom Configuration
The Data Migration Assistant is a great tool to help you evaluate and migrate your database to newer versions of SQL Server, including Azure SQL Database.
When to Use Row or Page Compression in SQL Server
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.
How to Check if Your Database Server Is Protected Against Meltdown and Spectre
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.
