Use sqlcmd to create and query a SQL Server container for development
In the past, you may have downloaded and installed SQL Server Developer Edition on your computer to test features, write queries, and have a sandbox. Do you want a more lightweight development environment that’s quicker to install and use? Enter D …
SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part 3
This is the final post in a series covering changes in SSMS 19. Please review Part 1 and Part 2 for details about Microsoft.Data.Sqlclient, MSAL, removal of the SQL Vulnerability Assessment, and more. This post discusses new features in SSM …
SQL Server slow performance troubleshooting documentation expanded
In the past 1.5 years we in the SQL Server CSS and content teams have been working on creating new documentation to assist with troubleshooting SQL Server slow performance issues. Here is a list of articles that were produced over this period. H …
Cumulative Update #5 for SQL Server 2022 RTM
The 5th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.To learn more about the release or servicing mod …
Cumulative Update #21 for SQL Server 2019 RTM
The 21st cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing m …
Update: Hotfixes released for ODBC and OLE DB drivers for SQL Server
We’ve released hotfix packages for the following drivers to address important security issues: Microsoft ODBC Driver 17.10.4 for SQL Server (release notes) Microsoft ODBC Driver 18.2.2 for SQL Server (release notes) Microsoft OLE DB Driver 18.6. …
Secure your AI using SQL Server Machine Learning with Microsoft Azure OpenAI Services
Microsoft SQL Server Machine Learning Services is a feature that allows you to run Python, R, Java, and other Machine Learning languages in-database, using open-source packages and frameworks for predictive analytics and machine learning. Microsoft Azu …
SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part 2
This is the second post in a series discussing changes between SSMS 18.12.1 and SSMS 19, and new functionality in SSMS 19.1. You can view the first post covering Microsoft.Data.Sqlclient and MSAL here. It turns out some of you do read the S …
Released: Microsoft.Data.SqlClient 5.2 Preview 2
Microsoft.Data.SqlClient 5.2 Preview 2 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year with two or three preview releases in …
SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part 1
Toward the end of May the SQL Tools team released SQL Server Management Studio (SSMS) 19.1, which had many bug fixes as well as new functionality and a couple noteworthy changes. In addition, as users have been upgrading to SSMS 19.x, we’ve heard …
Early technical preview of JDBC Driver 12.3.1 for SQL Server released
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and changes. Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of th …
Released: SQL Server 3rd Party Backend for Django v1.3
We have released version 1.3 of the SQL Server 3rd Party Backend for Django. This release contains support for the release of Django 4.12 as well as a number of issue fixes. Our plan is to support major releases of Django and SQL Server, to ensu …
Parameter Sensitive Plan Optimization, Why?
One question that we hear quite often is why we chose to capitalize the first three letters when abbreviating this feature sometimes, and at other times, we chose not to. For example, why only abbreviate it like PSP optimization, and not just PSPO? …
Private preview announcement of native JSON type & JSON aggregates in Azure SQL Database
Please head over to https://aka.ms/json-preview to learn more about the private preview of native JSON type and JSON aggregates – JSON_OBJECTAGG & JSON_ARRAYAGG in Azure SQL Database.
Announcing Azure Data Studio 1.44
It seems like just last week we were just releasing Azure Data Studio 1.43 (oh wait, that was last month) and here we are announcing Azure Data Studio 1.44! This release comes in the midst of Microsoft Build, where numerous Copilot-adjacent anno …