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.