Sites Microsoft


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 …

sp_helprotect is very useful in permission issue

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

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

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

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!

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

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

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

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

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

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

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

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 …

Released: Public Preview for SQL Server Management Packs (7.0.33.0)

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

Updates to Management Packs for SQL Server, Reporting Services, Analysis Services, and Azure SQL Managed Instance (7.0.33.0) are available for public preview. Please install this public preview version and provide us feedback. We appreciate t …

Microsoft Drivers 5.10.0 Beta 2 for PHP for SQL Server Released

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

We recently released the next beta of the Microsoft Drivers for PHP for SQL Server, version 5.10.0-beta2. This beta release has been built with PHP 7.3+ and tested on all supported platforms.   Notable items about this release over beta 1 include: …


Pages :