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. Read more
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. Read more
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? Read more
Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes. Read more
SQL Server 2022 expands and improves query performance feedback mechanisms and adds two new features—parameter sensitive plans and optimized plan forcing. Read more
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. Read more
At Microsoft, we understand that designing for inclusivity opens our experiences and reflects how people adapt to the world around them. In this new release of SSRS, we have done significant accessibility work to empower people to achieve more. Read more
SQL Server 2022, the most Azure-enabled release of SQL Server yet was announced in May and is publicly available in preview. SQL Server 2022 (preview) is now also available as an option in the Azure Data Studio Deployment Wizard. Read more
Data Platform Virtual Summit 2022 (DPS 2022), a free global learning event for data professionals, is just a few weeks away running from September 19–23. Read more
In SQL Server 2022, Query Store is now enabled by default for all newly created SQL Server databases to help customers better track performance history, troubleshoot query plan–related issues, and enable new query processor capabilities. Read more
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 manage sensitive Read more
We are pleased to introduce you to ledger, a new technology that uses the power of blockchain to offer a tamper-proof record of data modifications. Currently in Azure SQL, this feature is also part of the SQL Server 2022 release. Read more
