Skip to content

SQL Server 2022 announced

  • by
A person holding their finger over their mouth to indicate a secret

SQL Server 2022 was announced yesterday at Microsoft Ignite, and it’s going to be a big one.

Building on a lot of work in the Azure SQL space, SQL Server 2022 looks to include some cool features including (but not limited to):

  • failover to Managed Instance (and back again)
  • enhancements to intelligent query processing (including tackling parameter sensitivity)
  • new Transact-SQL syntax that aligns closer to SQL standards
  • system-versioned ledger tables (which you can read about here)
  • support for S3 (the protocol that Amazon built, so you’ll be able to back up to S3 storage)
  • improvements to JSON support
  • near real-time data sync with Synapse
  • Query Store enabled by default (and supported in Availability Group read replicas)
  • time series support (brought over from Azure SQL Database¬†Edge)

There is no information about licenses and edition features yet. Microsoft traditionally leaves that to late in the preview release cycle. I hope to get my hands on a preview version sometime in the near future so I can start digging in.

I’m excited! Let me know what you’re excited about too.

Photo by Kristina Flour on Unsplash.