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 …
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 Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing mo …
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 available in the VS Code Marketplace! Please note: While the Polyglot Notebooks extension in Visual Studio Code is now generall …
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 allows customers to instantly and securely build a GraphQL API for Azure Cosmos DB for NoSQL and Azure Cosmos DB for PostgreSQL. A quick look at Data API Buil …
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 SQL Databases. Data API builder is a new product that we are adding to the developer’s toolset to help every developer to be more efficient and effective, by …
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 EF Core 8, or just EF8, is the successor to EF Core 7, and is scheduled for release in November 2023, at the same time as .NET 8. EF8 previews curren …
[Cross post] Top 25 most common SQL Server Engine Errors (MSSQLSERVER_XXXX)
Please take a look at the following blog post by @Joseph Pilov (and team) to get detailed explanations, causes, and user actions for the top 25 most common SQL Server Engine errors! https://techcommunity.microsoft.com/t5/sql-serv …
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 addingWITH COMPRESSION as an option in the T-SQL backup command. SQL Server backup compression provides the compressed backup option …
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 and PDO_SQLSRV drivers has been built with PHP 8.0, 8.1, and 8.2 and tested on all supported platforms. Notable items about this rel …