SQL Server

News and technical articles about Microsoft’s SQL Server

Cardinality Estimation Feedback in SQL Server 2022

Part of theSQL Server 2022 blog series. Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates rely on two underlying things: statistics about the data and a set of assumptionsknown as the model. The model determines […]

Cardinality Estimation Feedback in SQL Server 2022 Continue Reading

New SQL Server on Azure Virtual Machines and Azure SQL Managed Instance DR benefits

Customers who are running their SQL Server workloads using SQL Server on Azure Virtual Machines and Azure SQL Managed Instance are now eligible for new high availability (HA) and disaster recovery (DR) benefits. These are in addition to existing HA/DR benefits that are explained in detail in the SQL Server licensing materials and this previously

New SQL Server on Azure Virtual Machines and Azure SQL Managed Instance DR benefits Continue Reading

Link feature for Azure SQL Managed Instance: Connecting SQL Server 2022 to the cloud, reimagined

Part of theSQL Server 2022 blog series. We are excited to announce general availability (GA) of the link feature for Managed Instance for SQL Server 2022the most Azure-enabled release of SQL Server yet. We are also excited to announce a limited preview of the managed disaster recovery (DR) to Azure SQL Managed Instance. Link feature

Link feature for Azure SQL Managed Instance: Connecting SQL Server 2022 to the cloud, reimagined Continue Reading

Data Virtualization with PolyBase for SQL Server 2022

Part of the SQL Server 2022 blog series. 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. REST APIs enable SQL Server to be both more flexible and lightweight while expanding its range of supported connectors and file

Data Virtualization with PolyBase for SQL Server 2022 Continue Reading

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?

Backup and restore to URL for S3-compatible object storage Continue Reading

Query Store hints in SQL Server 2022

Part of the SQL Server 2022 blog series. 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, and we have continued to make investments in this technology since its release in SQL Server 2016. Query Store is often described as

Query Store hints in SQL Server 2022 Continue Reading

Get more out of SQL Server Reporting Services 2022 with an improved user experience

Part of the SQL Server 2022 blog series. SQL Server 2022 introduces the new SQL Server 2022 Reporting Services (SSRS). Overview At Microsoft, we understand the power of technology, and that is why we continue to innovate, create, and design in a way that gives everyone the ability to achieve more. Designing for inclusivity opens our experiences and

Get more out of SQL Server Reporting Services 2022 with an improved user experience Continue Reading

Right Size/Recommend Azure SQL Managed Instance

Introduction When doing SQL Migrations we have some wonderful tools at Microsoft that will assist you with the migration from On-Premise to Azure. But What happens down the line when you need to decide if you made the correct choice from the start? Or has your use case changed? Maybe a service costs more than

Right Size/Recommend Azure SQL Managed Instance Continue Reading

Query Store is enabled by default in SQL Server 2022

Part of the SQL Server 2022 blog series. 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. The Query Store feature first became available in SQL Server 2016 and provides the ability for database administrators (DBAs) to gain insights on

Query Store is enabled by default in SQL Server 2022 Continue Reading

Microsoft Purview access policies for SQL Server 2022

Part of the SQL Server 2022 blog series. Overview Microsoft Purview is a family of data governance, risk, and compliance solutions that help organizations: Gain visibility into data assets across your organization. Data assets can be across data centers, multicloud, and software as a service (SaaS) data. Enable secure access to your data. Safeguard and

Microsoft Purview access policies for SQL Server 2022 Continue Reading