Cumulative Update #15 for SQL Server 2019 Big Data Clusters
Today, we announce the release of the latest cumulative update, CU15, for SQL Server Big Data Clusters. Improvements in this update are highlighted below, along with resources for you to learn more and get started. Log4j vulnerability assessment and El …
Cumulative Update #15 for SQL Server 2019 RTM
The 15th 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 …
Negative Blocking Session Ids (-5 = Latch ANY TASK RELEASOR)
SQL Server may report a blocking session id as a negative integer value. SQL Server uses negative sessions ids to indicate special conditions. Value Description -1 Orphaned lock, commonly a …
Released: Microsoft.Data.SqlClient 4.0.1
We have released an update to Microsoft.Data.SqlClient, version 4.0.1. The update addresses several issues that are important to our customers. Updates in Microsoft.Data.SqlClient 4.0.1 include: Fixed Fixed Kerberos authentication failure …
Cumulative Update #28 for SQL Server 2017 RTM
The 28th 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 …
Get a Hadoop Sandbox for testing/troubleshooting POLYBASE and Hadoop in 20 minutes.
This guide will take you step by step into deploying a hadoop sandbox into Azure. You then will connect to the sandbox through SSH and tunnel all the required ports to your machine so you can access all the endpoints to execute hadoop queries from Poly …
Early technical preview of JDBC Driver 10.1.0 for SQL Server released
We have released a new early technical preview of the JDBC Driver for SQL Server which contains a few additions and changes. Precompiled binaries are available on GitHub and also on Maven Central. Encrypt = true, by default …
Released: SCOM Management Packs for SQL Server, RS, AS, Azure SQL Managed Instance (7.0.34.0)
Updates to SQL Server, Reporting Services, Analysis Services, and Azure SQL Managed Instance Management Packs are available (7.0.34.0). You can download the MPs from the links below. Majority of the changes are based on your direct feedback. Thank you. …
AG force failover to DR, then reconnect to Prod nodes. Will AG keep Prod data or DR data ?
I made a test in my testing environment. Below are my test results I have 3 nodes in this Alwayson. CPS2019VM3 is DR node. I set firewall rules in VM1 and VM2 to block all network traffics from/to VM3. You can see VM3 became ‘Resolving …
sp_helprotect is very useful in permission issue
1. Customer wants to use a non-sysadmin user — Test to execute ‘xp_cmdshell’. Below scripts works fine in my testing environment. USE master; GO IF NOT EXISTS (SELECT 1 FROM sys.credenti …
Guidance on Apache Log4j Remote Code Execution Vulnerability
Microsoft published guidance regarding Log4j 2 vulnerability for customers using Azure Data services. Please find the latest information here: Microsoft’s Response to CVE-2021-44228 Apache Log4j 2 – Microsoft Security Response Center The pu …
Announcing new features for the SQL IaaS Agent Extension!
As mentioned by Pam in the blog (SQL Server on Azure VM – Now with 30% better price-performance on the new Ebdsv5 VM series! – Microsoft Tech Community) no one knows Microsoft SQL Server as Microsoft does, be it providing the right hardware capabi …
How to create Linked server from SQL Server to Azure SQL Database
Here in this blog, we are going to demo how to configure Linked server from on-prem SQL Server instance to Azure SQL database. I will have a reference to this blog in my subsequent blogs that will …
Hotfix: JDBC Driver 9.4.1 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 9.4.1. The update addresses a couple important issues in the driver. Fixed issues Fixed TDSParser hang on unsupported TDS_COLMETADATA (#1662) Fixed conversion of Loc …
Released: SQL Server 3rd Party Backend for Django v1.1
We have released version 1.1 of the SQL Server 3rd Party Backend for Django. This release contains support for the upcoming release of Django 4.0, as well as a number of issue fixes. Our plan is to time releases to coincide with major releases o …