Tag: SQL Server 2022 Blogging Series
-
-
SQL Server 2022: Intel® QuickAssist Technology overview
SQL Server backup compression provides the compressed backup option for all streaming SQL Server backup types—full, differential, and transaction log. -
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. -
Cardinality Estimation Feedback in SQL Server 2022
In SQL Server 2022, we have introduced a method of CE Feedback based on actual performance of the query over time. -
Manage, govern, and secure all your SQL Servers with new hybrid capabilities enabled by Azure ArcÂ
The newest edition of SQL Server 2022 delivers continued innovation with hybrid and multicloud capabilities, made possible through Azure Arc. -
SQL Server 2022 is now generally available
Announcing the general availability of SQL Server 2022, with continued innovation across performance, security, and availability. -
Link feature for Azure SQL Managed Instance: Connecting SQL Server 2022 to the cloud, reimagined
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. -
PASS Data Community Summit 2022 keynote: Transform your data estate with Microsoft’s Intelligent Data Platform
I look forward to seeing you at PASS Data Community Summit, a conference curated for the Microsoft data platform professional. Hosted by Redgate, this hybrid event will include the latest innovation across SQL Server and the entire Microsoft Intelligent Data Platform. -
Memory Grant Feedback: Persistence and Percentile Grant
Memory grant feedback (MGF) is an existing feature in SQL Server, with two critical improvements available in SQL Server 2022: feedback persistence, and percentile grant feedback. -
Intelligent Query Processing: degree of parallelism feedback
Part of the SQL Server 2022 blog series. DOP inefficiencies are a constant challenge; Current DOP methods are inefficient The degree of parallelism (DOP) with which a query is executed can greatly impact its performance. Any time a query is using parallelism, there is always the question of if it’s using the right amount of parallelism. -
Data Virtualization with PolyBase for SQL Server 2022
Microsoft SQL Server 2022 introduces the newest version of PolyBase, and with it the capability to query data where it lives, virtualize data, and use REST APIs. -
Backup and restore to URL for S3-compatible object storage
Part of the SQL Server 2022 blog series. Backup and restore to simple storage service (S3)–compatible object storage is a new feature introduced in SQL Server 2022 that grants the user the capability to back up or restore their databases using S3-compatible object storage, whether that be on-premises, or in the cloud. What is object storage? -
Azure Synapse Link for SQL
Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes. -
Intelligent Query Processing: feature family additions
SQL Server 2022 expands and improves query performance feedback mechanisms and adds two new features—parameter sensitive plans and optimized plan forcing. -
Query Store hints in SQL Server 2022
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.