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 …
Announcing SQL Server 2022 public preview: Azure-enabled with continued performance and security innovation
Today, we are excited to announce the public preview of SQL Server 2022. Anyone can now download SQL Server 2022 preview to try the new features in this release.SQL Server 2022 is the most Azure-enabled release of SQL Server yet, with continued innovat …
Change Tracking Automatic/Manual Cleanup Index
Howdy! It isn’t uncommon for us to receive autocleanup or manual cleanup issues regarding Change Tracking in CSS. If you have very busy tables that results in a lot of data being written to the side tables, it isn’t uncommon to see error 22122 i …
AlwaysOn synchronize performance can affect memory?
In an AlwaysOn environment, if you found your memory is slowly increasing or out of memory, you can use below way to check if it’s caused by slow synchronization. Firstly, check the errorlog or use DBCC MEMORYSTATUS to dump the memory usage, and …
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 issues in the 10.2.0 release. Fixed issues Changed Idle Connection Resiliency timeout to use existing the SharedTimer 17 …
SQL Server インストール時にインストールされるコンポーネントのサポート期限
こんにちは、 SQL Server サポートです。 SQL Server インストール時、様々なコンポーネントが同時にインストールされますが、バージョンによっては下位互換性を維持するため、すでに製品としてのサポートが終了しているコンポーネントが含まれており、そのコンポーネントのアンインストール可否やサポートについてのお問い合わせをいただくことがあります。 図. [コントロールパネル]の[プログラムのアンインストールまたは変更]で確認できるプログラム一覧 ■ …
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 with the geography static function parameter positioning. Reference: Point (geography Data Type) – SQL Server | Microsoft Docs select ge …
Early technical preview of JDBC Driver 11.1.1 for SQL Server released
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and changes. Precompiled binaries are available on GitHub and also on Maven Central. Encrypt = strict There i …
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. These updates include the general availability of the Azure SQL Migration Extension, the introduction of advanced features to the Table Designer feature that …