Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack GDR
The Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes a new security fix for SQL Server Engine. …
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 Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2016 SP3, plus it includes …
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 Center and Microsoft Update Catalog sites. This package cumulatively includes all previous SQL Server 2016 SP2 fixes through CU17, plus it includes …
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 Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2016 SP2, plus it includes …
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 Center and Microsoft Update Catalog sites. This package cumulatively includes all previous SQL Server 2014 SP3 fixes through CU4, plus it includes a …
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 Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2014 SP3, plus it includes …
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 post will focus on TPC. There are several other enhancements included in Preview 5, such as: Support for AT TIME ZONE in SQL Server Updates …
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 of the begin transaction and the modification are the defining properties. When the transaction begin time is before the latest row modification, …
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 Testing and Certification, S.A.U., and Microsoft met at Microsoft for the official handover of the Microsoft SQL Se …
How It Works: Workers, Tasks, Failed Logins – What is my SQL Server Doing?
From Customer Interesting point here is, current_workers_count is ~10X compared to active_workers_count; means no tasks assigned to 10X threads. How did threads land with no tasks? Is there orphaned threads not getting cleaned up? My Notes The t …
Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022
Azure SQL Database, Azure SQL Managed Instance and SQL Server currently support JSON text processing in T-SQL batches. This functionality allows you to store and manipulate JSON documents in the database. The JSON functions – ISJSON, JSON_VALUE, JSON_Q …
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 of SQL Server 2022 on Linux/Containers for public preview. Here are the details for getting started with the SQL Server 2022 public p …
Azure VM FCI環境での記憶域スペース拡張方法
こんにちは、SQL Server サポートです。 Azure の SQL VM(SQL Server on Windows Server) で FCI 環境を構成している場合のディスク拡張方法についてご紹介します。 Azure の SQL VM(SQL Server on Windows Server)をご利用中、SQL Server のサーバープロパティの[データベースの既定の場所]で設定しているドライブのストレージを拡張したくなった場合、Azure Portal の …
New server roles for SQL Server 2022 and Azure SQL Database in Public Preview
The article is published here on the Azure SQL Blog: New server roles for Azure SQL Database and SQL Server 2022 in Public Preview: Database Management without admin-access server roles in combination
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 let’s start with this. The symptom is that, you may have alwayson environment and you have readable secondary, when the secondary failed synchronizat …