Sites Microsoft


How It Works: Workers, Tasks, Failed Logins – What is my SQL Server Doing?

Publié le 7 juin 2022 sur MS Tech Community
 

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

Publié le 4 juin 2022 sur devblogs.microsoft.com
 

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.

Publié le 2 juin 2022 sur MS Tech Community
 

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環境での記憶域スペース拡張方法

Publié le 30 mai 2022 sur SQL Server Support Blog
 

こんにちは、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

Publié le 25 mai 2022 sur MS Tech Community
 

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

Publié le 25 mai 2022 sur SQL Server Support Blog
 

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

Publié le 24 mai 2022 sur SQL Server Blog
 

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

Publié le 16 mai 2022 sur SQL Server Support Blog
 

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?

Publié le 16 mai 2022 sur SQL Server Support Blog
 

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

Publié le 13 mai 2022 sur MS Tech Community
 

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 インストール時にインストールされるコンポーネントのサポート期限

Publié le 27 avril 2022 sur SQL Server Support Blog
 

こんにちは、 SQL Server サポートです。   SQL Server インストール時、様々なコンポーネントが同時にインストールされますが、バージョンによっては下位互換性を維持するため、すでに製品としてのサポートが終了しているコンポーネントが含まれており、そのコンポーネントのアンインストール可否やサポートについてのお問い合わせをいただくことがあります。   図. [コントロールパネル]の[プログラムのアンインストールまたは変更]で確認できるプログラム一覧   ■ …

Spatial: WKT vs Static Geography Function Parameter Positioning Is Reversed

Publié le 25 avril 2022 sur MS Tech Community
 

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

Publié le 22 avril 2022 sur MS Tech Community
 

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

Publié le 21 avril 2022 sur SQL Server Blog
 

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 …

How It Works: Temporary Objects – User Transaction Scope

Publié le 20 avril 2022 sur MS Tech Community
 

Temporary tables (create table #tmp, select into #tmp, declare @t table, internal worktables from sorts, internal spills from hashes, table valued parameters, cursors, etc.) are commonplace for SQL Server applications. There are many discussions pertai …


Pages :