Sites Microsoft

What is causing the Always On AG issue? Is it cluster, AD, DNS, or SQL?

Publié le 23 avril 2023 sur SQL Server Support Blog

Do any of these questions sound familiar? – My AG fails to failover – Why did my AG failover? – Why did my AG fail? – My AG is missing! – Why am I seeing stale data on secondary? – What is with the sudden log growth alerts? Yo …

Lire : https://techcommunity.microsoft.com/t5/sql-server-support-blog/what-is-causing-the-always-on-ag-issue-is-it-cluster-ad-dns-or/ba-p/3781656

イメージのランダム化を強制する(必須ASLR) に「既定でオンにする」を設定した場合、Express Edition の日本語版のインストーラの起動に失敗します

Publié le 20 avril 2023 sur SQL Server Support Blog

こんにちは。日本マイクロソフト SQL Server サポートチームです。事象：イメージのランダム化を強制する(必須ASLR) に「既定でオンにする」を設定した場合、SQL Server 2016 ならびにSQL Server 2019 のExpress Edition の日本語版のインストーラ(SQLEXPR_x64_JPN.exe) の起動に失敗します。なお、イメージのランダム化を強制する(必須ASLR) の規定値は「既定でオフにする」であり、既定値では発生しません。また、 …

Lire : https://techcommunity.microsoft.com/t5/sql-server-support-blog/%E3%82%A4%E3%83%A1%E3%83%BC%E3%82%B8%E3%81%AE%E3%83%A9%E3%83%B3%E3%83%80%E3%83%A0%E5%8C%96%E3%82%92%E5%BC%B7%E5%88%B6%E3%81%99%E3%82%8B-%E5%BF%85%E9%A0%88aslr-%E3%81%AB-%E6%97%A2%E5%AE%9A%E3%81%A7%E3%82%AA%E3%83%B3%E3%81%AB%E3%81%99%E3%82%8B-%E3%82%92%E8%A8%AD%E5%AE%9A%E3%81%97%E3%81%9F%E5%A0%B4%E5%90%88-express-edition/ba-p/3800757

SQL Server でオフラインバックアップおよびオフラインリストアを行うと問題が出ることがある

Publié le 18 avril 2023 sur SQL Server Support Blog

こんにちは。日本マイクロソフト SQL Server サポートチームです。公開ドキュメントとして公開されていた内容を、ブログとして掲載します。現象Microsoft SQL Server で SQL Server のサービスを停止した状態の場合、データベースファイルをバックアップしたり (オフラインバックアップ)、ファイルを復元する (オフラインリストア) 操作を実行すると問題が出ることがあります。回避策オフラインバックアップおよびオフライン …

Lire : https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-server-%E3%81%A7%E3%82%AA%E3%83%95%E3%83%A9%E3%82%A4%E3%83%B3-%E3%83%90%E3%83%83%E3%82%AF%E3%82%A2%E3%83%83%E3%83%97%E3%81%8A%E3%82%88%E3%81%B3%E3%82%AA%E3%83%95%E3%83%A9%E3%82%A4%E3%83%B3-%E3%83%AA%E3%82%B9%E3%83%88%E3%82%A2%E3%82%92%E8%A1%8C%E3%81%86%E3%81%A8%E5%95%8F%E9%A1%8C%E3%81%8C%E5%87%BA%E3%82%8B%E3%81%93%E3%81%A8%E3%81%8C%E3%81%82%E3%82%8B/ba-p/3798131

Make data more human with Azure OpenAI and Azure SQL

Publié le 14 avril 2023 sur devblogs.microsoft.com

[alert type= »important » heading= »Guest Post »]Valentina is a Microsoft Specialist, focusing on Azure OpenAI. She has been working with Azure OpenAI and Azure SQL lately and in this post she’s sharing how to start using Azure OpenAI and Azure SQL or SQL …

Lire : https://devblogs.microsoft.com/azure-sql/make-data-more-human-with-azure-openai-and-azure-sql

Cumulative Update #20 for SQL Server 2019 RTM

Publié le 14 avril 2023 sur MS Tech Community

The 20th cumulative update release for SQL Server 2019 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 this release or servicing …

Lire : https://techcommunity.microsoft.com/t5/sql-server-blog/cumulative-update-20-for-sql-server-2019-rtm/ba-p/3795816

Cumulative Update #3 for SQL Server 2022 RTM

Publié le 13 avril 2023 sur MS Tech Community

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 …

Lire : https://techcommunity.microsoft.com/t5/sql-server-blog/cumulative-update-3-for-sql-server-2022-rtm/ba-p/3795805

5 reasons to join us at Securely Migrate and Optimize with Azure

Publié le 13 avril 2023 sur SQL Server Blog

The post 5 reasons to join us at Securely Migrate and Optimize with Azure appeared first on Microsoft SQL Server Blog.

Lire : https://azure.microsoft.com/blog/5-reasons-to-join-us-at-securely-migrate-and-optimize-with-azure

Announcing Azure Data Studio 1.43

Publié le 12 avril 2023 sur MS Tech Community

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 …

Lire : https://techcommunity.microsoft.com/t5/sql-server-blog/announcing-azure-data-studio-1-43/ba-p/3794138

Announcing .NET 8 Preview 3

Publié le 11 avril 2023 sur devblogs.microsoft.com

.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 …

Lire : https://devblogs.microsoft.com/dotnet/announcing-dotnet-8-preview-3

Announcement: New Features and changes to SQL IaaS Agent Extension

Publié le 10 avril 2023 sur MS Tech Community

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 …

Lire : https://techcommunity.microsoft.com/t5/sql-server-blog/announcement-new-features-and-changes-to-sql-iaas-agent/ba-p/3791548

可用性グループリスナーへの接続方法

Publié le 7 avril 2023 sur SQL Server Support Blog

こんにちは。日本マイクロソフト SQL Server サポートチームです。今回は可用性グループリスナーへの接続方法についてご案内します。可用性グループリスナーに接続する際、アプリケーションや接続文字列でのサーバー名について、サポートされる指定方法とサポートされない指定方法は次の通りです。サポートされるサーバー名の指定可用性グループリスナーが既定の 1433 ポートの場合:listenernamelistenername,port 可用性グループリスナーが …

Lire : https://techcommunity.microsoft.com/t5/sql-server-support-blog/%E5%8F%AF%E7%94%A8%E6%80%A7%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%E3%83%AA%E3%82%B9%E3%83%8A%E3%83%BC%E3%81%B8%E3%81%AE%E6%8E%A5%E7%B6%9A%E6%96%B9%E6%B3%95/ba-p/3790003

Happy April Tools Day!

Publié le 2 avril 2023 sur MS Tech Community

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. …

Lire : https://techcommunity.microsoft.com/t5/sql-server-blog/happy-april-tools-day/ba-p/3785353

Generic ODBC external data sources may not work after installing Cumulative Update

Publié le 30 mars 2023 sur SQL Server Support Blog

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 …

Lire : https://techcommunity.microsoft.com/t5/sql-server-support-blog/generic-odbc-external-data-sources-may-not-work-after-installing/ba-p/3783873

Update XML files using PowerShell

Publié le 30 mars 2023 sur devblogs.microsoft.com

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 …

Lire : https://devblogs.microsoft.com/powershell-community/update-xml-files-using-powershell

Let's make it easy! How to read System Health and sp_server_diagnostics?

Publié le 29 mars 2023 sur SQL Server Support Blog

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 …

Lire : https://techcommunity.microsoft.com/t5/sql-server-support-blog/let-s-make-it-easy-how-to-read-system-health-and-sp-server/ba-p/3782297