Keeping in mind that the documentation is not final, this is a great change for a lot of shops, and it makes sense that such an important security feature should not be a differentiator for the most expensive edition.

Transparent Data Encryption (TDE) is now in Standard Edition.

Having this available in all editions is fantastic, but you need to make sure you test your workload against a baseline. You can even put the local version store in its own filegroup, which wasn't an option when I wrote about the feature in March. It is an availability feature, because it can drastically reduce failover and recovery time, and it can be considered a performance feature as well, because you can now use the same local version store for things like RCSI instead of sharing version store in tempdb.

This was easily the biggest surprise to me, as I thought it would be an Enterprise Edition feature. Accelerated Database Recovery is in Standard Edition.I wrote about this in a post entitled, ' A Big Deal : SQL Server 2016 Service Pack 1.' This was a very exciting time, and I just wanted to share some thoughts about the hits and misses in the newest version. As you may recall, back in SQL Server 2016 SP1, they opened up all of the programming surface features to all editions, and many (but certainly not all) of the performance and availability features.

The product is not released yet, at least at the time of writing, but they have started to shape which features (and there are a lot of them) will be available in which editions. I even attended the very exclusive SQL Server 2019 Airlift event in Redmond in the first week of October вЂ“ and while it was too late to provide feedback that would impact RTM, I did make several constructive suggestions that we'll hopefully see in a CU (or as late as vNext). I helped Bob Ward ( with technical editing for his most recent book, ' SQL Server 2019 Revealed,' and have been actively engaged with the product teams and my MVP peers throughout the CTP and RC cycles. As I embark on my first PASS Summit in a few years, it is hard to contain my excitement about the newest version of SQL Server.

Sql 2019 express limitations