Sites Microsoft


Cumulative Update #17 for SQL Server 2016 SP2

Publié le 29 mars 2021 sur MS Tech Community
 

The 17th 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 …

How to get the biggest bang for your buck with SQL Server on Azure VMs

Publié le 29 mars 2021 sur MS Tech Community
 

Running SQL Server on an Azure virtual machine is one of the quickest and easiest ways to lift-and-shift your SQL workloads into the cloud. The great thing about SQL Server on Azure Virtual Machines is that it’s the same SQL Server database engin …

How To Connect to SQL Server On-Premise/Virtual Machine from Linux using Kerberos Authentication

Publié le 26 mars 2021 sur SQL Server Support Blog
 

  Hi!  It is known that SQL Server can be accessed with many different authentication methods. We often recommend the use of Integrated Security using Kerberos mainly because it allows delegated authentication, besides being an efficient meth …

SQL Server 2019 の累積的な更新プログラム適用後に発生するイベント名 feature_restriction_usage が見つからないエラーについて

Publié le 24 mars 2021 sur SQL Server Support Blog
 

こんにちは SQL Server サポートチームです。 今回は SQL Server 2019 CU2 以降を適用した際に E …

SQL Server Performance Counter are Missing

Publié le 23 mars 2021 sur SQL Server Support Blog
 

If you find the SQL Server related performance counter objects are missing, you can try below steps to get it back   For example, my instance name is STD2016, and now open the command window with Administrator   1. unload the counter.  c …

Configure SQL Server AG (Read-Scale) for SQL Containers deployed on Kubernetes using Helm

Publié le 22 mars 2021 sur MS Tech Community
 

If you are trying to setup Always On availability group between SQL instances deployed as SQL containers on Kubernetes platform, then I hope that this blog provides you the required reference to successfully setup the environment.    Target: …

SQL Server x86 版の更新プログラム適用による、x64 版 FCI 構成への影響

Publié le 18 mars 2021 sur SQL Server Support Blog
 

こんにちは。SQL Server サポート チームです。   今回は1つの OS 上に SQL Server x64 版 と x8 …

Cannot Replicate Stored Procedure Execution when CDC is enabled

Publié le 17 mars 2021 sur SQL Server Support Blog
 

With Transactional Replication you can replicate execution of the Stored Procedure like this:     This has several advantages as discussed in this article: https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/pu …

Released: Microsoft.Data.SqlClient 3.0 Preview 1

Publié le 16 mars 2021 sur MS Tech Community
 

Microsoft.Data.SqlClient 3.0 Preview 1 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year with two preview releases in between. …

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 …


Pages :