Cumulative Update #17 for SQL Server 2016 SP2
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
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
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 が見つからないエラーについて
こんにちは SQL Server サポートチームです。 今回は SQL Server 2019 CU2 以降を適用した際に E …
SQL Server Performance Counter are Missing
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
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 構成への影響
こんにちは。SQL Server サポート チームです。 今回は１つの OS 上に SQL Server x64 版 と x8 …
Cannot Replicate Stored Procedure Execution when CDC is enabled
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
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
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
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
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
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.
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
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 …