Deja Vu: The Encore - Ending Support for SQL Server 2016

As the renowned philosopher Yogi Berra famously quipped, "Itʼs like experiencing déjà vu all over again!" It seems like only yesterday when we shared the bittersweet news that we would be saying goodbye to an older version of SQL Server. Now, here we are again with an encore. Itʼs time to bid adieu to SQL Server 2016, and while it may seem like we're revisiting a familiar song, there are new motivations and exciting opportunities on the horizon.

Microsoft initially set the mainstream end date for SQL Server 2016 for July 2021, and although they have granted an extension, we aim to pay tribute to this by propelling Rock into the future.

Our support for SQL Server 2016 will cease with the release of Rock version 19 or 20. Although we cannot provide a precise release date for these versions at this time, we are committed to ensuring you have ample time to make the necessary adjustments. Therefore, we advise transitioning away from SQL 2016 before the conclusion of 2024.

We recommend migrating to SQL Server 2022. This choice will spare you from having to repeat this process again for several years, given its mainstream end date of January 2028.

Curious about how this news impacts you? You can quickly determine the SQL version you're currently using by visiting the Diagnostics tab within the System Information window.

In newer versions of Rock, you'll find a crucial indicator under "Database Compatibility Version." Itʼs essential to examine this setting. Even if you spot "2019" under "Database Version," itʼs conceivable that your databaseʼs compatibility level may be configured at "2016" or lower. In such cases, please reach out to your IT support specialist or a trusted Rock partner for assistance.