Content type: Updates
-
-
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. -
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: The focus of this article is on using Microsoft Purview to enable access to user data as well as specific system metadata in SQL Server 2022 running on Azure Arc–enabled servers. -
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 -
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 for scalability as tempdb is arguably the most important database in your environment. -
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. -
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 -
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 -
Amplify your database development experience with Azure Data Studio
It is that time again! We are excited to bring new and exciting updates to Azure Data Studio. These updates include the general availability of the Azure SQL Migration Extension, the introduction of advanced features to the Table Designer feature that was initially released in February, some updates to notebooks, Query Plan Viewer, SQL Projects, -
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 -
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 -
The path forward for SQL Server analytics
Today, we are announcing changes to SQL Server analytics which includes: 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 to employee skillsets, deployment simplicity and manageability, and cloud flexibility and scalability. When we first introduced cloud -
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 -
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 -
Open sourcing the .NET 5 C# Language Extension for SQL Server
For over two decades, the C# programming language has allowed developers to build secure and robust applications within the .NET ecosystem. SQL Server 2019 supports the R, Python, and Java Language Extensions. These language extensions provide many benefits to developers. They provide data security, rapid speed for deployment, and ease of integration. Previously, we announced