Auditing Linked Servers
SQL Server does not track this information by default. You need to be proactively auditing linked servers for modifications. Getting started is easy, here’s how.
SQL Server 2017
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.
The Seven Samurai of SQL Server Data Protection
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.
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.
Data Migration Assistant Error During Assessment of SQL Server 2017
The Data Migration Assistant (DMA) offers you the ability to perform a feature assessment against your SQL Server database. The DMA will not work if you try to perform an assessment of a source database against an older target version.
