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
Blog posts
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
Azure Data Studio August Release
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
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
Azure Data Studio July Release with VS Code Updates
Hello, community! As you may already know, Azure Data Studio (ADS) is and has always been focused on building out its own ecosystem of extensions and customized tabs for handling databases, using the UI framework of Visual Studio (VS) Code. As a result, all improvements and/or fixes that are performed on the VS Code codebase 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
Recapping recent updates to client tools in SQL Server
Hello from the SQL Experiences team! As a follow-up to Microsoft Build at the end of May, we thought it was a good time to highlight recent updates for client tools, as we’ve had quite a few. SQL Server Management Studio First, in alignment with the announcement of preview for SQL Server 2022, we released Read more
Move end-of-support SQL Server 2012 to Azure Virtual Machines and save
The end of support for SQL Server 2012 is rapidly approaching on July 12, 2022. After end of support, no more security patches will be issued unless you take action to protect your SQL Server 2012 with Extended Security Updates (ESU). If you’re still weighing the options, this blog can help choose the best course of Read more
Introducing new and improved updates to SQL tools on Azure
In this post, we’ll recap the updates to SQL tools over the past few months, including the recent releases of Azure Data Studio and SQL Server Management Studio (SSMS). Additionally, we’ll highlight the Data-Tier Application Framework (DacFx) 160 general availability and changes to the MSSQL extension for VS Code. Lastly, we will introduce a major Read more
The path forward for SQL Server analytics
Today, we are announcing changes to SQL Server analytics which includes: Customer feedback Retirement of SQL Server 2019 Big Data Clusters Retirement of PolyBase scale-out groups Path forward Customer feedback We continue to see increased migration to the cloud, with analytical workloads leading that charge. Customers have indicated that analytics in the cloud best aligns Read more
What’s new with SQL Server Big Data Clusters—CU13 Release
SQL Server Big Data Clusters (BDC) is a capability brought to market as part of the SQL Server 2019 release. Big Data Clusters extends SQL Server’s analytical capabilities beyond in-database processing of transactional and analytical workloads by uniting the SQL engine with Apache Spark and Apache Hadoop to create a single, secure, and unified data Read more
Enhance your Log Analytics data exploration in Azure Data Studio
The Azure Monitor Logs extension in Azure Data Studio is now available in preview. The extension is supported in Azure Data Studio August 2021 release, v1.32.0. Administrators can enable platform logging and metrics to one of their Azure services such as Azure SQL and set the destination to Log Analytics workspace. By installing native Azure Monitor Read more