SQL Server 2016 – But still, it’s farewell…
July 20, 2026
This post is part of our series “SQL Server 2016 – The Final Countdown.” Welp, it’s all done. The final countdown came and went… SQL Server 2016 is as dead as the parrot purported to be pining the for the fjords. I mean actually, it’s a bit more like that parrot than you’d imagine. But
SQL Server 2016 – the Final Countdown: Assessing Your SQL Server 2016 Estate
July 8, 2026
This post is part of a series we are calling “SQL Server 2016 – The Final Countdown.” If you are reading this and you still have SQL Server 2016 instances kicking around, let this be yet another post reminding you that extended support for that version ends on July 14, 2026. If this is news to
SQL Server 2016 – the Final Countdown: SQL Server 2016 Is Becoming a Serious Security Risk
June 24, 2026
This post is part of a series we are calling “SQL Server 2016 – The Final Countdown.” For many companies SQL Server 2016 is a reliable database management system. It has worked well for several years and let’s be honest; it isn’t broken, so why fix it? We all have several high-priority tasks; everything from
SQL Server 2016 – the Final Countdown: Key Features from SQL Server versions 2017–2025
June 17, 2026
This post is part of a series we are calling “SQL Server 2016 – The Final Countdown.” SQL Server 2016 was the version where Microsoft really started giving us the good stuff for free. Query Store, Columnstore for everyone, Always Encrypted, Availability Groups that worked, and more. Plus, the Service Pack 1 feature additions made
SQL Server 2016 – the Final Countdown: Features Deprecated and Discontinued Since SQL Server 2016
June 10, 2026
This post is part of a series we are calling “SQL Server 2016 – The Final Countdown.” If you’re planning on upgrading from SQL Server 2016 to the current version of SQL Server 2025, it would be helpful to note some of the features from versions since 2016 that are no longer supported. By that
SQL Server 2016 – the Final Countdown: What End of Support Means and Why You Should Care
June 3, 2026
Many of us have been working with SQL Server long enough to remember when SQL Server 2016 was shiny and new. It’s unquestionably a milestone of a version with Query Store being introduced, availability groups finally working, lots of features eventually added to Standard Edition, and more. But now it is old enough that Microsoft
SSRS Data-Driven Subscriptions Missing After Migration to SQL Server 2022 -Troubleshooting Guide
March 18, 2026
If you’ve migrated SSRS to a new server and your data-driven subscriptions have disappeared, or new subscriptions are failing with a generic timeout error, this post walks through three separate issues we hit on a single migration and how we resolved each one. Data-Driven Subscriptions Disappeared After SSRS Migration to SQL 2022 Standard After migrating
You Don’t Understand Negligence, Your SQL Server Version Told Me…
August 15, 2025
When I was in the world of EMS, you rarely started a course for the next level of license without a chapter or two on the legal side. They hammered negligence into us — what it takes to lose in court on a negligence lawsuit. It’s the same thing in IT.And here’s what you don’t
6 Common Pitfalls of SQL Server Migrations and Upgrades
November 30, 2022
If you’ve ever tried migrating a SQL Server database from one server to another, you know it can be a white-knuckle ride from start to finish. You need to wait forever while you backup and restore, change all your connection strings to point to the new server, and forget to change the data sources for
Data Migration Assistant
November 28, 2022
It’s upgrade season. Here at Straight Path, we have more than a couple of clients in the process of upgrading their SQL Environments to a more modern version. With the support door slamming shut soon for SQL 2008 (waaaay overdue), and others on 2012 (really not in a much better position – support wise) clients