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.
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.
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.
For years I have found myself often needing these three pieces of information with regards to SQL Server: When was the last time the server was restarted? When was the last time the SQL instance was restarted? When was the last time the SQL Server wait stats were cleared? If the server itself is restarted, then the answer … Read more
Next week I am taking part in a webinar along with Karen Lopez where we will discuss database design tips for SQL Server and Windows Azure SQL Database. This is not the debate format we have done previously, this is meant to be more of a discussion format. I’ve spent a good chunk of time … Read more
