Update: ODBC Driver 17.7.2 for SQL Server Released
Version 17.7.2 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.7.2 brings a few fixes to the driver. Fixes Fix issue with 404 Not Found errors when using Managed Service Identity authentication Fix for intermitt …
Released: Microsoft.Data.SqlClient 1.1.4
We recently released an update to Microsoft.Data.SqlClient, version 1.1.4. The update addresses a couple issues that are important to our customers. Updates in Microsoft.Data.SqlClient 1.1.4 are: Fixed Fixed wrong results issues during hi …
Released: Microsoft.Data.SqlClient 2.1.2
We have released an update to Microsoft.Data.SqlClient, version 2.1.2. The update addresses several issues that are important to our customers. Updates in Microsoft.Data.SqlClient 2.1.2 include: FixedFixed issue connecting with instance name …
Hotfix: JDBC Driver 9.2.1 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 9.2.1. The update addresses an issue with the new Azure Service Principal authentication option. Fixed issuesFixed an issue with client secret being empty during Activ …
PolyBase error – 100001;Failed to generate query plan.
Problem We’ve seen several cases come in lately where customers have been trying to use PolyBase feature and encountering « Failed to generate query plan » error. Depending on which command you run, the error will display differently. CREATE EXTER …
Cumulative Update #23 for SQL Server 2017 RTM
The 23rd cumulative update release for SQL Server 2017 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 …
SQL Server Always on Availability Group Scalability Experiment and Result on Azure VM
Introduction The purpose of this scalability experiment is to evaluate the performance of AG cluster when it has large number of databases and some of the databases undergo large amount of traffic, and measure 1) OLTP transaction performance, 2) Failov …
Watch and learn about SQL Assessment API and SQL Assessment Extension
If you are curious about how to easily determine if your SQL is following best practices guidelines, you can watch the Data Exposed Live episode we did recently. We demo’ed SQL Assessment API and SQL Assessment Extension for Azure Data Studio (ADS …
The February 2021 release of Azure Data Studio is now available
The February release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the Microsoft fami …
What’s new with SQL Server Big Data Clusters
SQL Server Big Data Clusters (BDC) is a new 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 …
Cumulative Update #9 for SQL Server 2019 RTM
The 9th 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 mo …
Cumulative Update #16 for SQL Server 2016 SP2
The 16th cumulative update release for SQL Server 2016 SP2 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 …
Auto update statistics threshold of temp table in stored procedure
The threshold of temp table in stored procedure is little bit tricky, it doesn’t exactly follow the regular threshold. First of all, you can’t use the modification_counter to determine when auto update statistics happens. Because the data i …
Intro into security principles in the context of database systems
Introduction into security principles in the context of database systems By Andreas Wolter Preface While many of us are practicing ‘social distancing’, and spend lots of time at home, I am finally finding the time to share some of th …
New Home for SQL Server Troubleshooting KB articles ..and for other commercial products
Summary: SQL Server KB articles have migrated to DOCs at https://docs.microsoft.com/troubleshoot/sql. This excludes CU and hotfix which will remain currently on http://support.microsoft.com What do you get: Articles organize …