Released: General Availability of Microsoft.Data.SqlClient 5.0
We have released for general availability Microsoft.Data.SqlClient 5.0. This .NET Data Provider for SQL Server provides general connectivity […]
Sites Microsoft
Establish digital trust in your data with ledger in SQL ...
Part of the SQL Server 2022 blog series. We are pleased to introduce you to ledger, a new […]
Azure Active Directory authentication for SQL Server 2022
Part of the SQL Server 2022 blog series. Azure Active Directory (Azure AD) authentication is now supported for […]
SQL Server 2022 community technology preview 2.1 is now available
Continuing with our release cadence, we’re excited to announce the release of SQL Server 2022 Community Technology Preview 2.1. […]
Azure Data Studio July Release with VS Code Updates
Hello, community! As you may already know, Azure Data Studio (ADS) is and has always been focused on […]
Improve scalability with system page latch concurrency enhancements in SQL ...
Part of the SQL Server 2022 blog series. Over the past several SQL Server releases, Microsoft has improved […]
Cumulative Update #30 for SQL Server 2017 RTM
The 30th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft […]
Upcoming updates to SQL Server container images on Microsoft Artifact ...
As you may be aware, SQL Server container images are published and available on the Microsoft Artifact Registry […]
ODBC Driver 17.10 for SQL Server Released
Version 17.10 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.10 brings a few […]
Announcing Entity Framework Core 7 Preview 6: Performance Edition
Entity Framework 7 (EF7) Preview 6 has shipped and is available on nuget.org. Keep reading for links […]
Analysis Services and Reporting Services extensions for Visual Studio 2022 ...
We’re happy to announce the popular and long-awaited Analysis Services, RDLC Report Designer, and Reporting Services extensions […]
SQL Server 2012 reaches end of support and Microsoft is ...
Today, July 12, 2022, marks the end of support for SQL Server 2012. This version has had an […]
Difference in handling config file changes between SSRS 2017 and ...
This article discusses the differences in handling Config file changes between SSRS 2017 and SSRS 2019. While […]
拡張セキュリティ更新プログラム (ESU) について
こんにちは、 SQL Server サポートです。 今回は、SQL Server サポート期間とサポート終了後の拡張セキュリティ更新プログラム (ESU)について紹介します。 [SQL Server サポート期間について] SQL Server に関するサポートをご利用いただく際に注意する点として、SQL Server […]
Improve scalability with Buffer Pool Parallel Scan in SQL Server ...
This blog post is part of the SQL Server 2022 blog series. Buffer Pool Parallel Scan is a […]
How to enable and run SQL best practices assessments on ...
You can evaluate your SQL Server on Azure VM for configuration best practices using SQL best practices assessment […]
Released: SCOM Management Packs for SQL Server, RS, AS (7.0.38.0)
Updates to SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.38.0). You can download the […]
Introducing the SQL Server 2022 blog series
Introducing a new blog post series to highlight new features and enhancements available with SQL Server 2022. SQL […]
How to use Azure-SSIS integration runtime to run SSIS packages ...
Integration runtime for Azure-SQL Server Integration Services (SSIS) makes it possible to simply run SSIS packages in […]
Early technical preview of JDBC Driver 11.1.2 for SQL Server ...
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several […]
Released: Microsoft.Data.SqlClient 5.0 Preview 3
Microsoft.Data.SqlClient 5.0 Preview 3 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
Hotfix: Microsoft Drivers 5.10.1 for PHP for SQL Server Released
We recently released an update to Microsoft Drivers for PHP for SQL Server, version 5.10.1. The update addresses a […]
What’s new with SQL Tools
Hello community, the June release of Azure Data Studio 1.37 is here! We are also excited to announce […]
Recapping recent updates to client tools in SQL Server
Hello from the SQL Experiences team! As a follow-up to Microsoft Build at the end of May, we […]
Security Update for SQL Server 2019 RTM CU16
The Security Update for SQL Server 2019 RTM CU16 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2017 RTM CU29
The Security Update for SQL Server 2017 RTM CU29 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2016 SP3 Azure Connect Feature ...
The Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack GDR is now available for download […]
Security Update for SQL Server 2016 SP3 GDR
The Security Update for SQL Server 2016 SP3 GDR is now available for download at the Microsoft Download […]
Security Update for SQL Server 2016 SP2 CU17
The Security Update for SQL Server 2016 SP2 CU17 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2016 SP2 GDR
The Security Update for SQL Server 2016 SP2 GDR is now available for download at the Microsoft Download […]
Security Update for SQL Server 2014 SP3 CU4
The Security Update for SQL Server 2014 SP3 CU4 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2014 SP3 GDR
The Security Update for SQL Server 2014 SP3 GDR is now available for download at the Microsoft Download […]
Announcing Entity Framework 7 Preview 5
Entity Framework 7 (EF7) Preview 5 has shipped with support for Table-per-Concrete type (TPC) mapping. This blog […]
Temporal: Encountering Error 13535 Data modification failed on system-versioned table…
When 2 or more workers are modifying the same row, it is possible to encounter 13535. The time […]
Common Criteria EAL4 Certification for SQL19
In May 2022, representatives of the Spanish certification body CCN (Centro Cryptológico National), the Spanish evaluation facility DEKRA […]
How It Works: Workers, Tasks, Failed Logins – What is ...
From Customer Interesting point here is, current_workers_count is ~10X compared to active_workers_count; means no tasks assigned to 10X […]
Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed ...
Azure SQL Database, Azure SQL Managed Instance and SQL Server currently support JSON text processing in T-SQL […]
SQL Server 2022 public preview is now available on Linux.
In continuation of last week’s announcement of SQL Server 2022 public preview, we are pleased to announce availability […]
Azure VM FCI環境での記憶域スペース拡張方法
こんにちは、SQL Server サポートです。 Azure の SQL VM(SQL Server on Windows Server) で FCI 環境を構成している場合のディスク拡張方法についてご紹介します。 Azure の […]
New server roles for SQL Server 2022 and Azure SQL ...
The article is published here on the Azure SQL Blog: New server roles for Azure SQL Database and SQL […]
Query performance drops due to version_ghost_record_count in AlwaysOn
The title is actually a little bit misleading, because the issue will not only happen on AlwaysOn, but […]
Announcing SQL Server 2022 public preview: Azure-enabled with continued performance ...
Today, we are excited to announce the public preview of SQL Server 2022. Anyone can now download SQL […]
Change Tracking Automatic/Manual Cleanup Index
Howdy! It isn’t uncommon for us to receive autocleanup or manual cleanup issues regarding Change Tracking in […]
AlwaysOn synchronize performance can affect memory?
In an AlwaysOn environment, if you found your memory is slowly increasing or out of memory, you can […]
Hotfix: JDBC Driver 10.2.1 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 10.2.1. The update addresses a few […]
SQL Server インストール時にインストールされるコンポーネントのサポート期限
こんにちは、 SQL Server サポートです。 SQL Server インストール時、様々なコンポーネントが同時にインストールされますが、バージョンによっては下位互換性を維持するため、すでに製品としてのサポートが終了しているコンポーネントが含まれており、そのコンポーネントのアンインストール可否やサポートについてのお問い合わせをいただくことがあります。 図. [コントロールパネル]の[プログラムのアンインストールまたは変更]で確認できるプログラム一覧 ■ SQL Server インストール時にインストールされるコンポーネントのサポート期限同時にインストールされるコンポーネントについては基本的に、SQL Server の動作に必要なものになりますので、アンインストールは不可となりますが、SQL […]
Spatial: WKT vs Static Geography Function Parameter Positioning Is Reversed
Be careful, this one caused me problems the other day. The WKT (Well-Known Text) format does not match […]
Early technical preview of JDBC Driver 11.1.1 for SQL Server ...
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several […]
Amplify your database development experience with Azure Data Studio
It is that time again! We are excited to bring new and exciting updates to Azure Data Studio. […]
How It Works: Temporary Objects – User Transaction Scope
Temporary tables (create table #tmp, select into #tmp, declare @t table, internal worktables from sorts, internal spills from […]