Upgrading to SQL Server 2016: Post-upgrade tasks

After upgrading to SQL Server 2016 is complete you will need to perform a series of tasks to verify that database is ready to be handed over to the end users for further testing. This post will provide you a checklist of items to review after the upgrade is complete.

read more

Schema Compare for SQL Server

Today I’m going to show how to do a schema compare using only SSMS, dacpac files, and the FC (File Compare) command available in Windows. If you need to do a schema compare but are limited in your ability to purchase or install tools, the FC command is a brilliant option.

read more

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.

read more

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.

read more

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.

read more