SQL Mysteries: Why am I Still Seeing 17830 Errors?
Moved from: bobsql.com I was recently contacted by Christophe Laporte posing a very interesting question. « This is about the blog post you published a while ago, but I’ have questions regarding the error which is firing an XEvent al …
HOW IT WORKS: SQL Server Scheduler Affinity
Moved from: bobsql.com SQL Server uses 3 types of affinity to control where the SQL Server worker threads execute. Before explaining the different scheduler affinity types let me clarify some terminology. Node Types SQL Server makes …
How It Works: SQL Server Stack Trace – COMDAT Elimination
Moved from: bobsql.com Starting with SQL Server 2019, SQL Server is built with the COMDAT, ICF linker option enabled, reducing size/space usage. …
How It Works: XEvent String Comparison Performance Tip
Moved from: bobsql.com I ran across a check in the XEvent string comparison logic which can b …
JDBC Driver 10.2 for SQL Server Released
Version 10.2 of the Microsoft JDBC Driver for SQL Server has been released. Version 10.2.0 brings several added features, changes, and fixed issues over the previous production release. Added Java 17 support 1676 Idle Connection Resiliency …
Microsoft Drivers 5.10 for PHP for SQL Server Released
We have released Microsoft Drivers for PHP for SQL Server, version 5.10.0. This production release of the SQLSRV and PDO_SQLSRV drivers has been built with PHP 7.4, 8.0, and 8.1 and tested on all supported platforms. Notable items about this rel …
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 …