Working with time series data in SQL Server 2022 and Azure SQL
Time series capabilities in SQL Server were introduced in Azure SQL Edge, Microsoft’s version of SQL Server for the Internet of Things.
We’ve been on the road the last couple of weeks across MVP Summit, SQLBits and Fabric Con, connecting with customers talking about the value of migration and modernization. We want to dig into specifically, how Azure can deliver real business value through cost optimization and streamlined productivity for their Windows Server and SQL Server deployments
Time series capabilities in SQL Server were introduced in Azure SQL Edge, Microsoft’s version of SQL Server for the Internet of Things.
In SQL Server 2022, we have introduced a method of CE Feedback based on actual performance of the query over time.
The newest edition of SQL Server 2022 delivers continued innovation with hybrid and multicloud capabilities, made possible through Azure Arc.
Table Designer and Query Plan Viewer are now generally available along with previews of Oracle database migration to Azure for PostgreSQL and Azure SQL.
Customers using SQL Server on Azure Virtual Machines and SQL Managed Instance are now eligible for high availability and disaster recovery benefits.
Announcing the general availability of SQL Server 2022, with continued innovation across performance, security, and availability.
We are excited to announce general availability of the link feature for Managed Instance for SQL Server 2022–the most Azure-enabled release of SQL Server yet.
I look forward to seeing you at PASS Data Community Summit, a conference curated for the Microsoft data platform professional.
Memory grant feedback (MGF) is an existing feature in SQL Server, with two critical improvements available in SQL Server 2022.
In SQL Server 2022, we introduced a new feature called DOP feedback.
Microsoft SQL Server 2022 introduces the newest version of PolyBase.
Backup and restore to simple storage service (S3)–compatible object storage is a new feature introduced in SQL Server 2022.
Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes.
SQL Server 2022 expands and improves query performance feedback mechanisms and adds two new features—parameter sensitive plans and optimized plan forcing.
Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database workloads.