Is SQL Server 2017 Stable?
There I was, talking about upgrading to SQL Server 2017 at SQL Konferenz last month. Despite the title of the talk, I was not expecting such a question. But there it was: “Is SQL Server 2017 stable enough to use?”
There I was, talking about upgrading to SQL Server 2017 at SQL Konferenz last month. Despite the title of the talk, I was not expecting such a question. But there it was: “Is SQL Server 2017 stable enough to use?”
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.
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.
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
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.