Top 10 New Features of SQL Server 2019
Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from the past. We originally published today’s post on October 29, 2019. It's no secret to anyone that software release cycles are more aggressive than ever. Now that the cloud has become ubiquitous as a strategic component of IT services, we are spoiled by a constant release of new features and services available to us. It follows then that on-premises or "retail-delivered" software is also getting more frequent releases as customer expectations grow. This is how, over the last four years, we've had three major releases of
SQL Server: 2016, 2017 (with the big milestone of SQL on Linux) and now SQL 2019. SQL 2019 is shaping up to be a very powerful evolutionary step to the features that were introduced in SQL 2017. The product also brings its own set of brand-new capabilities that continue to position it as a "one-stop" software platform for all your data needs. With this in mind, and considering how much the product contains nowadays, I have compiled this list of my top favorite features of SQL 2019! Now, of course, this is my post, and my opinion, and the list is not exhaustive. For the full list, refer to the
Microsoft documentation. As you will see, my favorites are mostly technical features that will help developers and DBAs in their daily functions. Also, a quick disclaimer — all the images are from Microsoft's own SQL Server documentation. I'm sure your top 10 is likely to be very different than my top 10 so make sure you check it all out in detail! Here is my list: