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.
MSSQL
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
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.
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.
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.
