Managing SQL Server production databases can become a nerve-wracking situation for administrators, especially when your organisation or business can have hundreds of databases that are vital to its existence and commerce.
A common problem with data platform modernisation is gaining application vendor support for newer SQL Server versions, but that has been made easier since Microsoft’s change in position on the long-term use of database compatibility mode announced in 2018.
Updated: February 2020
SQL Server 2008 and SQL Server 2008 R2 have now left Extended Support and no longer receive security updates. This blog and infographic explain what this means and how unsupported products can affect your business:
While performing an in-place SQL Server upgrade for a customer, I came across the KB2919355 issue. This article will show you how to resolve this this problem and point out why this can be misleading.
A whole series of “speculative execution side-channel attacks” were disclosed in the first week of 2018, as detailed in this Microsoft article: https://portal.msrc.microsoft.com/en-US/security-guidance/advisory/ADV180002
Major security events like this highlight the severe risk companies are..
The SQL Server 2016 Upgrade Advisor is a great graphical user interface for analysing your existing SQL Server database to discover any features or syntax you are using that are not compatible with a 2016 upgrade.