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 …
SQL Server Always on Availability Group Scalability Experiment and Result on Azure VM
Introduction The purpose of this scalability experiment is to evaluate the performance of AG cluster when it has large number of databases and some of the databases undergo large amount of traffic, and measure 1) OLTP transaction performance, 2) Failov …
Watch and learn about SQL Assessment API and SQL Assessment Extension
If you are curious about how to easily determine if your SQL is following best practices guidelines, you can watch the Data Exposed Live episode we did recently. We demo’ed SQL Assessment API and SQL Assessment Extension for Azure Data Studio (ADS …
The February 2021 release of Azure Data Studio is now available
The February release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the Microsoft fami …
What’s new with SQL Server Big Data Clusters
SQL Server Big Data Clusters (BDC) is a new capability brought to market as part of the SQL Server 2019 release. BDC extends SQL Server’s analytical capabilities beyond in-database processing of transactional and analytical workloads by uniting the SQL …
Cumulative Update #9 for SQL Server 2019 RTM
The 9th 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 mo …