The Choice of SQL Server Version

Every quarter Brent Ozar publishes some data from his SQL ConstantCare® service. This is a service where companies contract with Brent to install a service on their instance, collect data, and give them simple, short daily emails on things they should check. It's a good service for companies who don't employ skilled DBAs and may relay on a developer or sysadmin to manage a SQL Server instance. While this is a self-selecting group of organizations, across his 3,100+ monitored servers, there are likely trends that could apply to the world of SQL Servers in general. After all, for every gung-ho, let's-upgrade DBA, there's probably a sysadmin with a similar mindset.

In any case, the summer 2023 report form Brent shows that SQL Server 2022 adoption has slowed. His report is down, though I doubt anyone downgraded. Perhaps someone was testing and added a 2022 server in the spring they removed. Or maybe they tried 2022 and then went to the cloud. He does show 2019 growing and 2016 shrinking, which dovetails with what I see from my memory of various questions at SQL Server Central. I see people asking about moving from older versions to 2019 much more than 2022.

I wonder what that is? Brent thinks this is because people standardized on 2019 installs and haven't moved to 2022. So anyone adding new instances likely uses an image/setup/process for 2019. That matches with a few of my customers, who haven't had some of their install or security processes updated and are still adding 2019 instances. I think that's short-sighted as 2019 is 4 years old, but I also understand that people get busy and updating anything for a new version isn't a priority.

There have also been some problems with updates, and Brent thinks companies are skipping 2022. I don't know, but I do wonder what you think about your estate and how things are changing. I assume if you are still running 2014- at this point, you'll just live with the server as long as you can. I hope you're at least on a VM so you can restore quickly if there are issues (assuming you back up VMs).

If you run 2016/2017, are you looking to upgrade? Considering 2022 or stick with 2019? Or kick the can and hope that SQL Server 2024 or 2025 will be better? Actually, take a guess as well on the next release date. I'll take a page from Brent and run a contest for you to guess the next release date.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

Are you looking to modernize and migrate your data but have questions about the complex organizational challenges? We recently hosted the webinar: Overcoming Organizational Challenges in Data Modernization and Cloud Migration: A Guide for Senior IT Leaders. This blog post summarizes the conversation into 7 key points.

THE VIDEO THE SYNOPSIS In this video, we will provide an introduction to Azure Machine Learning’s Automated ML feature. We will, with a few (dozen) mouse clicks, generate over...

Blog 1 Congratulations on starting your journey as a database developer in a new organization! As you embark on this exciting chapter of your career, you'll encounter various challenges and...

Tracking the Inaccurate Cardinality Estimates When...

Introduction:   Worker utilization is a critical aspect of Azure SQL Database performance. When the percentage of workers reaches 100%, it can lead to database unresponsiveness, impacting application performance and user...

Monitoring Database Autogrowth Settings is important and is what I often end up discussing in Comprehensive Database Performance Health Check; First appeared on SQL SERVER – Monitoring Database Autogrowth Settings

Busy Bee I’ve been spending a lot of time lately working on my free scripts. And, I know, I’ve been recording videos about them, but some folks out there...

Stack Overflow was down, so y’all posted questions at https://pollgab.com/room/brento and I gave ’em my best shot. Here’s what we covered: 00:00 Start 04:33 Amir: Does Az-900 worth the...

This article shows how you can convert OUTER APPLY...

In SQL Server, we’re used to finding the end of the month via a few different methods. We can always use the DateAdd and DateDiff functions to get our...

Have you ever received advice that was technically...

We are excited to announce that Azure SQL Managed ...

  One of our customers came up with a requirement where they wanted to Migrate On-prem Database to Azure SQL Managed instance. The databases had traditional column level encryption enabled.   He...

Seriously, how do y’all keep coming up with so many great questions? I went through your top-voted questions from https://pollgab.com/room/brento/ on a live stream on my Twitch channel, like...

Flexible companies are adding headcount at double the rate of fully in-office peers, but landing a flexible job can still be a challenge.

Azure Boost is one of Microsoft Azure’s latest a...

A while back, a client, who host user-facing datab...

Ready to secure your spot at PASS Data Community Summit? Register by July 26 at the Early Bird rate.

Want to hear someone else’s experience of learning PostgreSQL from scratch? Then look no further. Grant Fritchey, Microsoft Data Platform MVP, started working with SQL Server in 1995 but more recently has needed to support and understand PostgreSQL. In this webinar, he will go on a deeper dive into the PostgreSQL database and will share top tips from his own learning journey. Join us on July 25th

This guide walks developers through the process of using breakpoints and stepping to debug PowerShell scripts. We will focus on practical examples to illustrate each technique in action.

Maybe this has happened to you: you’ve been pres...

In the previous article, you learned the general principles of data modeling. Now, it’s time to narrow down our learning journey and master data modeling concepts and techniques that are specifically relevant for business intelligence scenarios. And, whenever we’re talking about data modelling for business intelligence, dimensional modeling is definitely the number one concept.

If you have been in the DevOps space, you should know about version control and must have worked with 0ne. But, have you heard of BitBucket? No? Well, this tutorial is for you.

In modern software systems, data is often generate...

Copy Activity Issue in ADF / Synapse Analytics Rec...

I use Chat-GPT occasionally, instead of Google, to get answers to technical questions. However, I regard Chat-GPT as an indiscriminate conveyor of existing information, not artificial intelligence.

Advancements in flash technology have come as a bo...

When a slicer contains many items, developers can ...

Choose between many-to-many relationships and DAX code to filter the most relevant items using another slicer. Indeed, calculation groups cannot use relationships!

Since Microsoft Fabric became available, I blogged about it and have an introduction video on Fabric that you can view here. I wanted to follow up with a short 30-minute video... The...

Reading Time: 8 minutes In this post I want to cover one way you can migrate dedicated SQL Pool objects to a Microsoft Fabric Data Warehouse using Azure...

Welcome back to the world of MySQL Replication! If you’ve been following this series, thank you for your support! And if you’re new here, welcome! Before we dive in,...

Welcome to part twenty-two of the plansplaining se...

Have you ever come across an elusive SQL Server is...

Learn which events in Log Analytics can be used to...

A little background for those new to using Power B...

Video by: Reid HavensLearn how create and access perspectives for Power BI Datasets. Perspectives allow you to configure the visibility of all dataset fields per perspective to fit multiple...

I have enabled the new On-Object Interaction for the formatting pane in Power BI and while it is constantly improving there are times when I would like to have...

Together with the introduction of Microsoft Fabric a long-awaited feature for Power BI also became available. Git integration now allows us to connect your workspace to a git repository...

This book aims to update your DBA skills to cover SQL Server 2022, how does it fare?

Most applications have large and complex databases...

Erik Darling has been busy. FIrst, sp_QuickieStore...

Busy Bee I’ve been spending a lot of time lately...

Microsoft.Data.SqlClient 5.2 Preview 3 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a...

On July 13, 2023, Microsoft released SQL Server 20...

sp_HumanEventsBlockViewer: Now With 100% More Query Plans And Prioritized Results! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training....

If you’re an aspiring data scientist or R programmer, you must be familiar with the powerful data structure called “lists.” Lists in R are collections of elements that can contain various data types such as vectors, matrices, data frames, or even other lists. They offer great flexibility and are widely used in many real-world scenarios.

Whether you’re a beginner or an experienced programmer, knowing how to find duplicate values is a fundamental skill. In this blog post, we will explore two different approaches to accomplish this task using base R functions and the dplyr package in R.

How to solve the certificate chain was issued by a...

A while back I talked about the fact that you can ...

One of the wonderful things about blogging is the ability to make notes for future me. Which is basically what ... Continue reading The post How do I tell if...

Critical-infrastructure employees are comparativel...

The cosmetics conglomerate was apparently breached...

This tip builds upon the QR Code generator web-based app that uses SQL Server by adding a process to scan employee QR codes.

Recognizing an opportunity for optimization, we replaced the original series generation logic in the stored procedure with the GENERATE_SERIES function. First appeared on SQL SERVER 2022 – GENERATE_SERIES Function

We were able to improve the performance of the query by using STRING_AGG Function to Concatenate Strings. Let us learn. First appeared on SQL SERVER – STRING_AGG Function to Concatenate...

Recently, I encountered an intriguing scenario whe...

The client needed a robust method for generating complex passwords directly within their SQL Server database. Let us see today. First appeared on SQL SERVER – Generating Complex Passwords with...

Fun With KQL Windowing Functions - Serialize and Row_Number

When working with SQL Server databases, the SQL CO...

Just four years ago, the movement to ban police de...

The Salesforce survey finds IT teams are embracing...

Gandalf is an interactive LLM game where the goal is to get the chatbot to reveal its password. There are eight levels of difficulty, as the chatbot gets increasingly...

This tip is a step-by-step tutorial on installing ...