SQL Server 2019 CTP 3.2 Available

Microsoft announced CTP 3.2 for SQL Server 2019 just a few days ago, but many people working with SQL Server don’t care about this. I run into people at user group meetings and SQL Saturdays who are stuck supporting versions as old as SQL Server 2000, and SQL Server 2008 R2 is still prevalent. I’m happy that most people report that they are running SQL Server 2012 and later when I ask during my presentations.

In my job as editor of Simple-Talk, I must keep up with the news in the data platform space, but most people are already focused on their current systems, and they don’t have time to pay attention to a version that they won’t be using in the near future. I get that. I remember those days as a DBA when keeping my servers stable, patched, secure, and performing well was enough to fill my time.

I do think it’s important to stay aware of the latest and greatest developments, though, for a couple of reasons, even if it’s just reading articles or attending sessions. First, you may think that you know what versions of SQL Server you’ll be supporting next year or even next month, but things change. You could unexpectedly be looking for a new position in a year, or maybe you’ll be supporting some new software that requires a newer version at your current job. Another reason is to make sure that you are aware of features that could help your current environment. You might be missing out on innovations such as Query Store, Columnstore Indexes, Machine Learning Services, and new DMVs and functions that could help you today. Most of the publicity about the new features happens when they’re released, not necessarily when you need to know about them. Luckily, the content is always available if you know what to search for.

While keeping up with the latest version of on-premises SQL Server can be daunting, it’s even more difficult if you try to learn about so many other options such as running SQL Server in containers or on Linux, Azure SQL Database, and Managed Instances. If you haven’t noticed, SQL Server isn’t the only database game in town for Microsoft, anymore. For specific workloads, maybe Cosmos DB or PostgreSQL would be a better fit.

I suspect that SQL Server 2019 will be available soon (no inside info here) just because the release notes for 3.2 don’t mention any database engine changes. In the meantime, I’ll be checking out some of the cool new performance features like Table Variable Deferred Compilation and Batch Mode on Rowstore. I encourage you to find something about SQL Server 2019 that also sparks your interest so you'll be ready "just in case!"

Kathi Kellenberger

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

Click to learn more about author Andy Gray. There ...

In our last post in this series, I talked about wh...

Step AWAY from the Production servers! Read on......

When SQL Server detects corruption in a database, ...

Data in SQL Server is stored in 8KB pages, both in...

Arun Sirpal wants to shuffle deck chairs in Azure:...

I have been selected to present a second session f...

Bob Pusateri wants you to test your restores, prob...

Click to learn more about authors Oksana Sokolovsk...

Below are the top 15 questions I am seeing from cu...

Every once in a while, I come across a data wareho...

Data is hard. it has been always hard and it’s n...

A few weeks ago I began hearing a rumor that SSIS ...

Protecting core infrastructure components like SQL...

This is the second article in the Machine Learning...

OpenAI, a company working on AI for the public goo...

In 2017, LinkedIn had no plans to move off its own...

Question: Can an Index Reduce Performance of SELEC...

I have a lot of co-workers who use sp_who and sp_w...

Microsoft continues to enhance the performance of ...

Josh Darnell ran into a problem with a SQL Agent j...

In the latest Comprehensive Database Performance H...

Question received via email: The question was abou...

David Fowler explains what an intent lock is and w...

To tidy up your Power BI solution, there are some ...

Thanks for watching this week's Power BI news roun...

This article describes different techniques to dis...

Matt Allington shows how you can now use icons as ...

Level: Intermediate FILTER() is one of the most im...

Matthew Roche answers a reader question and waxes ...

What if you can find all details about DAX measure...

Rob Sewell takes a break from book-writing and tal...

This is a simple powershell script to query and di...

This blog post is around the changing landscape of...

In my previous career many years ago, I worked at ...

Nate Johnson has a few things which might make SQL...

In this article, we’ll talk about professional S...

Asad Khan announces the release of SQL Server 2019...

Niko Neugebauer shows us how to use the SHORTEST_P...

The statistical median is the value which separat...

I’ve always said if you’re running a script fo...