Azure Data Studio July Release with VS Code Updates  

3 min read

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 

13 min read

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 

3 min read

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 

5 min read

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 

3 min read

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 

3 min read

Today, we are announcing changes to SQL Server analytics which includes: Customer feedbackRetirement of SQL Server 2019 Big Data ClustersRetirement of PolyBase scale-out groupsPath 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 to employee skillsets,…Read more

What’s new with SQL Server Big Data Clusters—CU13 Release 

4 min read

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 

2 min read

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

Open sourcing the .NET 5 C# Language Extension for SQL Server 

2 min read

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…Read more

Recent updates for Data-Tier Application Framework and SqlPackage 

3 min read

In this article, we will cover some recent changes to the Data-Tier Application Framework (DacFx) and SqlPackage. DacFx is a library that provides APIs for database deployment and development scenarios and SqlPackage is a command line interface to DacFx for common uses. Earlier this year SqlPackage released updates including additional support for Azure Synapse Analytics…Read more

What’s new with SQL Server Big Data Clusters—CU11 Release 

2 min read

SQL Server Big Data Clusters (BDC) is a capability brought to market as part of the SQL Server 2019 release. BDC 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 platform. BDC…Read more

Looking to the future for R in Azure SQL and SQL Server 

4 min read

Update March 17, 2022: This post has been updated to remove mentions of SQL Server 2019 Big Data Clusters which has been retired. For more information, see big data options on the Microsoft SQL Server platform. Data science, machine learning, and analytics have re-defined how we look at the world. The R community plays a vital…Read more