Sites Microsoft


Update: ODBC Driver 17.7.2 for SQL Server Released

Publié le 10 mars 2021 sur MS Tech Community
 

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

Publié le 10 mars 2021 sur MS Tech Community
 

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

Publié le 3 mars 2021 sur MS Tech Community
 

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

Publié le 2 mars 2021 sur MS Tech Community
 

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.

Publié le 1 mars 2021 sur SQL Server Support Blog
 

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

Publié le 25 février 2021 sur MS Tech Community
 

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

Publié le 23 février 2021 sur MS Tech Community
 

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

Publié le 23 février 2021 sur MS Tech Community
 

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

Publié le 22 février 2021 sur SQL Server Blog
 

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

Publié le 16 février 2021 sur SQL Server Blog
 

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

Publié le 11 février 2021 sur MS Tech Community
 

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

Publié le 11 février 2021 sur MS Tech Community
 

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

Publié le 7 février 2021 sur SQL Server Support Blog
 

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

Publié le 4 février 2021 sur MS Tech Community
 

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

Publié le 3 février 2021 sur SQL Server Support Blog
 

    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 …


Pages :