Parameter Sensitive Plan Optimization, Why?
One question that we hear quite often is why we chose to capitalize the first three letters when […]
Sites Microsoft
Private preview announcement of native JSON type & JSON aggregates ...
Please head over to https://aka.ms/json-preview to learn more about the private preview of native JSON type and JSON […]
Announcing Azure Data Studio 1.44
It seems like just last week we were just releasing Azure Data Studio 1.43 (oh wait, that was […]
Released: Latest Azure VM Marketplace images for SQL Server 2022, ...
Azure Marketplace is an online store that contains thousands of software applications and services built by industry-leading technology companies. […]
SLES 15 SP4 is now supported for SQL Server 2022 ...
We are pleased to announce the support for SQL Server 2022 on SUSE Enterprise Linux v15 SP4. This […]
SQL Server Agent fails to start on Windows Server 2022 ...
Problem A customer recently reported that they tried to build a SQL Server running on Windows Server […]
Cumulative Update #4 for SQL Server 2022 RTM
The 4th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
go-sqlcmd v1.0 – Create, Connect to, and Query SQL Server
If you’re reading this, you’ve probably used sqlcmd to connect to a SQL Server or Azure SQL Database […]
A Technical Journey into API Design-First: Best Practices and Lessons ...
A Technical Journey into API Design-First: Best Practices and Lessons Learned Introduction As software engineers, we all […]
Released: Multiple Microsoft.Data.SqlClient Updates
We have released multiple updates to supported versions of Microsoft.Data.SqlClient in the last couple of months. Just because […]
Early technical preview of JDBC Driver 12.3.0 for SQL Server ...
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several […]
Upgrade SQL Server container with Always On availability groups configured ...
This is a follow-up to my previous blog post I published a while ago titled « Updating SQL Server […]
Capitalize on your investments with the new centrally managed Azure ...
Introducing the new centrally managed Azure Hybrid Benefit for SQL Server. Today, Microsoft is pleased to announce the […]
Using Ledger in Azure SQL Database
Transactions have to be protected and you need to know when something is altered or prevent altering […]
What is causing the Always On AG issue? Is it ...
Do any of these questions sound familiar? – My AG fails to failover – Why did my […]
イメージのランダム化を強制する(必須ASLR) に「既定でオンにする」を設定した場合、Express Edition の日本語版のインストーラの起動に失敗します
こんにちは。日本マイクロソフト SQL Server サポートチームです。 事象： イメージのランダム化を強制する(必須ASLR) に「既定でオンにする」を設定した場合、SQL Server 2016 ならびにSQL Server 2019 のExpress Edition の日本語版のインストーラ(SQLEXPR_x64_JPN.exe) の起動に失敗します。 なお、イメージのランダム化を強制する(必須ASLR) […]
SQL Server でオフライン バックアップおよびオフライン リストアを行うと問題が出ることがある
こんにちは。日本マイクロソフト SQL Server サポートチームです。 公開ドキュメントとして公開されていた内容を、ブログとして掲載します。 現象Microsoft SQL Server で SQL Server のサービスを停止した状態の場合、データベース ファイルをバックアップしたり (オフライン バックアップ)、ファイルを復元する (オフライン […]
Make data more human with Azure OpenAI and Azure SQL
[alert type= »important » heading= »Guest Post »]Valentina is a Microsoft Specialist, focusing on Azure OpenAI. She has been working with […]
Cumulative Update #20 for SQL Server 2019 RTM
The 20th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
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 […]
5 reasons to join us at Securely Migrate and Optimize ...
The post 5 reasons to join us at Securely Migrate and Optimize with Azure appeared first on Microsoft […]
Announcing Azure Data Studio 1.43
Our regular users may have noticed we typically release Azure Data Studio every other month. As such, this […]
Announcing .NET 8 Preview 3
.NET 8 Preview 3 is now available. It includes changes to build paths, workloads, Microsoft.Extensions, and containers. […]
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 […]
可用性グループリスナーへの接続方法
こんにちは。日本マイクロソフト SQL Server サポートチームです。 今回は可用性グループリスナーへの接続方法についてご案内します。可用性グループリスナーに接続する際、アプリケーションや接続文字列でのサーバー名について、サポートされる指定方法とサポートされない指定方法は次の通りです。 サポートされるサーバー名の指定可用性グループリスナーが既定の 1433 ポートの場合:listenernamelistenername,port 可用性グループリスナーが既定以外のポートの場合: listenername,portlistenernameinstancename,port ※ listenernameinstancename,port と指定した場合は、instancename の部分は無視され、listenername,port […]
Happy April Tools Day!
While many folks observe April 1 as April Fool’s Day, we in the SQL Tools team celebrate April […]
Generic ODBC external data sources may not work after installing ...
Symptoms After you install SQL Server 2019 CU19 or SQL Server 2022 CU2, external data sources using […]
Update XML files using PowerShell
There are many blogs on internet already speaking about updating XML files in PowerShell, but I felt […]
Let's make it easy! How to read System Health and ...
Hi Everyone, The system_health session is an extended event session that is included by default with SQL […]
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 […]
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 […]
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 […]
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 […]
SQL 仮想マシンのディスク拡張
こんにちは。日本マイクロソフト SQL Server サポートチームです。 今回は、Azure の SQL VM(SQL Server on Windows Server) のディスク拡張について、よくお問い合わせいただく以下の内容についてご案内します。 【本ブログで紹介させていただく内容】 A. SQL […]
Cumulative Update #2 for SQL Server 2022 RTM
The 2nd cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
Announcing Polyglot Notebooks! Multi-language notebooks in Visual Studio Code
We are excited to announce that Polyglot Notebooks, Visual Studio Code’s multi-language notebook extension, is now generally […]
Announcing Data API builder for Azure Cosmos DB
We are super excited to announce the public preview of Data API builder. A new feature that […]
Data API builder for Azure SQL Databases – Public Preview
I am extremely happy and excited to announce the public preview of Data API builder for Azure […]
EF Core 8 Preview 2: Lite and familiar
The second preview of Entity Framework Core (EF Core) 8 is available on NuGet today! Basic information […]
[Cross post] Top 25 most common SQL Server Engine Errors ...
Please take a look at the following blog post by @Joseph Pilov (and team) to get detailed explanations, causes, and […]
SQL Server 2022: Intel® QuickAssist Technology overview
Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced […]
Microsoft Drivers 5.11 for PHP for SQL Server Released
We have released Microsoft Drivers for PHP for SQL Server, version 5.11.0. This production release of the SQLSRV […]
Getting Started with Azure SQL Bindings: Part 1
Expanding on the excellent post by Drew Skwiers-Koballa; Developing with Azure SQL bindings and Azure SQL trigger for […]
Top 25 SQL Server Engine Errors Based on support case ...
About 6 months ago we decided to look at what SQL Server engine error messages are most commonly […]
[Data Virtualization] May need to update Java (JRE7 only uses ...
At end of October 2022 we saw an issue where a customer using PolyBase external query to Azure […]
EF Core 8 Preview 1: Raw, lazy, and on-time
The first preview of Entity Framework Core (EF Core) 8 is available on NuGet today! Basic information […]
Cumulative Update #1 for SQL Server 2022 RTM
The 1st cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
Cumulative Update #19 for SQL Server 2019 RTM
The 19th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
Security Update for SQL Server 2022 RTM GDR
The Security Update for SQL Server 2022 RTM GDR is now available for download at the Microsoft Download […]
Security Update for SQL Server 2019 RTM CU18
The Security Update for SQL Server 2019 RTM CU18 is now available for download at the Microsoft Download […]