Released: Microsoft.Data.SqlClient 5.1 Preview 1
Microsoft.Data.SqlClient 5.1 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 or three preview releases in …
Support reminder for older versions of Visual Studio
We want to keep you secure when using Visual Studio. If you’re using an older version of Visual Studio, we have several reminders about upcoming events in the Visual Studio support lifecycle. First, if you’re using the Community Edition of Visual Studi …
Intelligent Query Processing: degree of parallelism feedback
SQL Server 2022, UpdatesPart of the SQL Server 2022 blog series.DOP inefficiencies are a constant challenge; Current DOP methods are inefficientThe degree of parallelism (DOP) with which a query is executed can greatly impact its performance. Any …
Released: Microsoft.Data.SqlClient 5.0.1
We have released an update to Microsoft.Data.SqlClient, version 5.0.1. The update addresses several issues that are important to our customers. Updates in Microsoft.Data.SqlClient 5.0.1 include: Fixed Fixed missing HostNameInCertific …
Modernize your data estate on SQL from cloud to edge
Experience SQL innovation with consistency and rich Azure integration At this year’s Microsoft Ignite 2022 event, we talked about doing more with less and unlocking the value of your data. Leveraging the cloud to reduce costs, drive productivity …
Announcing Entity Framework Core 7 RC2: JSON Columns
Entity Framework Core 7 (EF7) RC2 has shipped! The RC2 release contains all features planned for the EF7 GA release. This includes: Mapping to SQL Server JSON Columns ExecuteUpdate and ExecuteDelete (Bulk updates) Improved performance for SaveChanges T …
SQL Server 2017 で導入された日本語照合順序を利用する環境での注意点
＊この記事は、SQL Server で日本語の照合順序を利用している方に向けた情報となりますので、日本語でのみ公開しております。 ＊This article is for the user using japanese collation of SQL Server.Hence we publish the article in japanese only. こんにちは、SQL Server サポートチームです。 今回は SQL Server 2017 で導入された以下の …
Data Virtualization with PolyBase for SQL Server 2022
Part of the SQL Server 2022 blog series.Microsoft SQL Server 2022 introduces the newest version of PolyBase, and with it the capability to query data where it lives, virtualize data, and use REST APIs. REST APIs enable SQL Server to be both more f …
Azure Synapse Link support for Azure Cosmos DB Gremlin API now in preview
Azure Cosmos DB’s Gremlin API combines the power of graph database algorithms with highly scalable, managed infrastructure to provide a unique, flexible solution to most common data problems associated with lack of flexibility and relational approaches …
SQL Server 2022 Release Candidate 1 is now available on Linux
Continuing with our release cadence, we are pleased to announce the release of SQL Server 2022 Release Candidate 1 (RC 1) for Linux. To download the latest RC 1 container images, please use the ‘2022-latest’ tags for both RHEL and Ubu …
HADR_SYNC_COMMIT Wait Updates (In Progress)
A HADR_SYNC_COMMIT wait occurs when the session is waiting for a transaction to commit or rollback when the database is part of a Database Availability Group (High Availability.) A transaction is considered committed when hardened (written) to t …
SQL Server 2022 Release Candidate 1 is now available
Continuing with our release cadence, we’re excited to announce the release of SQL Server 2022 Release Candidate 1. Since the first public preview in May 2022, anyone can download SQL Server 2022 RC1 to try the new features in this releas …
Backup and restore to URL for S3-compatible object storage
Part of the SQL Server 2022 blog series.Backup and restore to simple storage service (S3)compatible object storage is a new feature introduced in SQL Server 2022 that grants the user the capability to back up or restore their databases using S3-co …
Cumulative Update #18 for SQL Server 2019 RTM
The 18th 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 …
dbcc dumptrigger: Capture a dump for specific error and state
I had an inquiry about dbcc dumptrigger today and realized that state filtering was added to dbcc dumptrigger but not well known. You can collect a process dump (SQL Dumper) when a specific error occurs using XEvent (error_reported/ex_raise2 eve …