Sites Microsoft


SQL Mysteries: Why am I​​ Still Seeing 17830​​ Errors?

Publié le 6 février 2022 sur MS Tech Community
 

  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

Publié le 5 février 2022 sur MS Tech Community
 

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

Publié le 5 février 2022 sur MS Tech Community
 

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

Publié le 5 février 2022 sur MS Tech Community
 

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

Publié le 1 février 2022 sur MS Tech Community
 

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

Publié le 31 janvier 2022 sur MS Tech Community
 

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

Publié le 28 janvier 2022 sur MS Tech Community
 

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

Publié le 28 janvier 2022 sur MS Tech Community
 

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)

Publié le 22 janvier 2022 sur MS Tech Community
 

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

Publié le 20 janvier 2022 sur MS Tech Community
 

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

Publié le 13 janvier 2022 sur MS Tech Community
 

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.

Publié le 10 janvier 2022 sur SQL Server Support Blog
 

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

Publié le 21 décembre 2021 sur MS Tech Community
 

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)

Publié le 21 décembre 2021 sur MS Tech Community
 

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 ?

Publié le 19 décembre 2021 sur SQL Server Support Blog
 

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 …


Pages :