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. Read more
SQL Server 2022 Blogging Series
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. Read more
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. Read more
Get more out of SQL Server Reporting Services 2022 with an improved user experience
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
Query Store is enabled by default in SQL Server 2022
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
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 manage sensitive Read more
Establish digital trust in your data with ledger in SQL Server 2022
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
Azure Active Directory authentication for SQL Server 2022
Part of the SQL Server 2022 blog series. Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems. Azure AD Authentication methods The new functionality extends existing authentication modes, such as SQL authentication and Windows authentication, allowing users to connect to SQL Server 2022 using Read more
Improve scalability with system page latch concurrency enhancements in SQL Server 2022
Over the past several SQL Server releases, Microsoft has improved the concurrency and performance of the tempdb database. In SQL Server 2022 we are addressing one of the last areas of contention by introducing concurrent global allocation map (GAM) and shared global allocation map (SGAM) updates which will give SQL Server 2022 a big improvement Read more
Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022
Buffer Pool Parallel Scan is a new feature in SQL Server 2022 that improves the scalability of several common scenarios in SQL Server and as a result, could significantly improve the performance of your database workloads. Read more
Introducing the SQL Server 2022 blog series
Introducing a new blog post series to highlight new features and enhancements available with SQL Server 2022. SQL Server 2022, now in public preview, is our most Azure-enabled release yet, with continued innovation across performance, security, and availability. With connections to Azure Synapse, Microsoft Purview, and Azure SQL Managed Instance, it is a key offering Read more
Announcing SQL Server 2022 public preview: Azure-enabled with continued performance and security innovation
Part of the SQL Server 2022 blog series. Today, we are excited to announce the public preview of SQL Server 2022. Anyone can now download SQL Server 2022 preview to try the new features in this release. SQL Server 2022 is the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and Read more