Cumulative Update #3 for SQL Server 2022 RTM
The 3rd cumulative update release for SQL Server 2022 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 mo …
5 reasons to join us at Securely Migrate and Optimize with Azure
The post 5 reasons to join us at Securely Migrate and Optimize with Azure appeared first on Microsoft SQL Server Blog.
Announcing Azure Data Studio 1.43
Our regular users may have noticed we typically release Azure Data Studio every other month. As such, this April release is a bonus with just a few updates to highlight (and yes, we are planning to have a release in May). SQL Database Proj …
Announcing .NET 8 Preview 3
.NET 8 Preview 3 is now available. It includes changes to build paths, workloads, Microsoft.Extensions, and containers. It also includes performance improvements in the JIT, for Arm64, and dynamic PGO. If you missed the March preview, you may want to r …
Announcement: New Features and changes to SQL IaaS Agent Extension
SQL Server on Azure Virtual Machines is powered by the SQL IaaS Agent extension which provides many features that make managing your SQL Server easy. This blog will discuss new features and changes we’ve recently released in this extension. Retir …
可用性グループリスナーへの接続方法
こんにちは。日本マイクロソフト SQL Server サポートチームです。 今回は可用性グループリスナーへの接続方法についてご案内します。可用性グループリスナーに接続する際、アプリケーションや接続文字列でのサーバー名について、サポートされる指定方法とサポートされない指定方法は次の通りです。 サポートされるサーバー名の指定可用性グループリスナーが既定の 1433 ポートの場合:listenernamelistenername,port 可用性グループリスナーが …
Happy April Tools Day!
While many folks observe April 1 as April Fool’s Day, we in the SQL Tools team celebrate April 1 as April Tools Day, a day when we debunk myths surrounding the tools for SQL Server. We recommend having some good chocolate to honor the occasion. …
Generic ODBC external data sources may not work after installing Cumulative Update
Symptoms After you install SQL Server 2019 CU19 or SQL Server 2022 CU2, external data sources using generic ODBC connector may no longer work. When you try to query external tables that were created before installing the cumulative update, you r …
Update XML files using PowerShell
There are many blogs on internet already speaking about updating XML files in PowerShell, but I felt need of one consolidated blog where complex XML files can also be updated with long complex hierarchy of XML nodes and attributes. Below is an XML exam …
Let's make it easy! How to read System Health and sp_server_diagnostics?
Hi Everyone, The system_health session is an extended event session that is included by default with SQL Server. This blog post goes over how to easily read and interpret System Health extended event and sp_server_diagnostics with an example. Fo …
Data API Builder Quickstart Demo from VS Live Vegas
I was fortunate enough to be able to present Data API builder the week of March 20th at VS Live in Las Vegas and what an incredible group of attendees at that conference. During my session, I stepped through a live demo of Data API builder showing off …
Accelerated Database Recovery enhancements in SQL Server 2022
Part of the SQL Server 2022 blog series. We are excited to share that there are several Accelerated Database Recovery (ADR) enhancements in SQL Server 2022 that further improve the overall availability and scalability of the database, primari …
Announcing the New Azure Cosmos DB Desktop Data Migration Tool
Today we’re excited to introduce a brand new Azure Cosmos DB Desktop Data Migration Tool. You can find the new tool at https://github.com/AzureCosmosDB/data-migration-desktop-tool. Read more about it below and how to use it. Some History The old …
Updating SQL Server containers deployed on Kubernetes!
I’m sure you’ve thought about how to update SQL Server containers running on a Kubernetes cluster at some point. So, this blog attempts to answer the question. According to the Kubernetes documentation, there are two Update strategies for statefulset w …
SQL 仮想マシンのディスク拡張
こんにちは。日本マイクロソフト SQL Server サポートチームです。 今回は、Azure の SQL VM(SQL Server on Windows Server) のディスク拡張について、よくお問い合わせいただく以下の内容についてご案内します。 【本ブログで紹介させていただく内容】 A. SQL 仮想マシンのディスクを拡張する方法 B. SQL 仮想マシンからディスク拡張ができない C. ディスク拡張を拡張したが拡張できない A. SQL …