Azure Developer CLI (azd) – February 2023 Release
We’re pleased to announce that the February 2023 release (0.6.0-beta.1) of the Azure Developer CLI (azd) is […]
Sites Microsoft
SQL Server on Azure VMs – the best price-performance gets ...
I know it’s February, but it’s our first blog post of the year and we’re still feeling festive […]
JDBC Driver 12.2 for SQL Server Released
Version 12.2 of the Microsoft JDBC Driver for SQL Server has been released. Version 12.2.0 brings several added […]
Microsoft Drivers 5.11.0 Beta 1 for PHP for SQL Server ...
We recently released the next beta of the Microsoft Drivers for PHP for SQL Server, version 5.11.0-beta1. This […]
SQL Server Management Studio (SSMS) 19.0 Released!
The long-awaited release of SQL Server Management Studio (SSMS) 19.0 is finally here! This is […]
HPE SGLX – The new Azure VM extension for SQL ...
Overview Mission critical SQL Server instances have the need to utilize high availability and disaster recovery features […]
Azure Data Studio 1.41 release
We are less than one month into 2023 and already have a new release of Azure Data Studio […]
Azure Cosmos DB & Power BI Incremental Refresh
Abstract Data Collection has become a daunting task with the ever-growing amount of data. The growth of […]
CTEs, Views or Temp Tables?
I’ve just finished watching the video from the @GuyInACube about Common Table Expressions and I noticed that in several […]
Released: General Availability of Microsoft.Data.SqlClient 5.1
We have released for general availability Microsoft.Data.SqlClient 5.1. This .NET Data Provider for SQL Server provides general connectivity […]
Best practices assessment -Arc-enabled SQL Server
If you are a Database Administrator (DBA) and responsible for managing, securing, protecting, and governing hundreds of SQL […]
SQL Server containers on Kubernetes with S3-compatible object storage – ...
One of the new features introduced with SQL Server 2022 is the ability to connect to any S3-compatible […]
.NET 7更新之网络，是你期待的吗?
最新的.NET 7现已发布，我们想介绍一下其在网络领域所做的一些有趣的更改和添加。这篇博文讨论了 .NET 7 在HTTP 空间、新 QUIC API、网络安全和WebSockets方面的变化。 HTTP 改进了对连接尝试失败的处理 在 .NET 6 之前的版本中，如果连接池中没有立即可用的连接，（处理程序上的设置允许的情况下，例如HTTP /1.1中的MaxConnectionsPerServer，或 HTTP/2中的EnableMultipleHttp2Connections）新的 HTTP […]
Hotfix: JDBC Driver 10.2.3 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 10.2.3. The update addresses a few […]
Hotfix: JDBC Driver 11.2.3 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 11.2.3. The update addresses a few […]
Development with SQL in containers on macOS
There are a bunch of tools available for developing with SQL on macOS, including the mssql extension […]
Working with time series data in SQL Server 2022 and ...
Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the […]
Released: SCOM Management Packs for Azure SQL Database, SQL Server, ...
Updates to Azure SQL Database, SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.42.0). You […]
Microsoft R Application Network retirement
In June 2021, we announced that Microsoft Machine Learning Server & Microsoft R Open will be retired on […]
Microsoft R Application Network usage & retirement
If you are using the Microsoft R Application Network website or CRAN Time Machine snapshots, then please read […]
Build Your Own Podcast App with .NET 7, Blazor, and ...
The .NET Podcast app was first introduced at .NET Conf 2021 and recently updated to highlight new […]
What’s New in Visual Studio Extensions for SSAS and SSRS
We have just released the new Visual Studio extensions for SSAS 2022 and SSRS 2022. Microsoft Analysis Services […]
Hotfix: JDBC Driver 11.2.2 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 11.2.2. The update addresses a few […]
Released: Update to Microsoft OLE DB Driver 18 for SQL ...
Microsoft OLE DB Driver 18.6.5 for SQL Server was released this week to fix a potential driver crash. […]
Hotfix: JDBC Driver 10.2.2 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 10.2.2. The update addresses a few […]
How to use FILESTREAM, query the metadata , access filestream ...
1. Create database with a FILESTREAM filegroup USE [master] GO –create database with Filestream CREATE […]
How to use FILESTREAM, query the metadata, and access filestream ...
The main goal of this blog post is to showcase how you can discover the FILESTREAM assets in […]
Polyglot Notebooks – December 2022 Release
We are pleased to announce the December 2022 improvements to Polyglot Notebooks for Visual Studio Code. Make […]
Trace Flag 8904 – Disable Inline Database Log Flushes
A log cache block holds log records for the database. Many workers are allowed to add log records […]
Intermittent ANONYMOUS LOGON of SQL Server linked server double hop
If you already know how to configure the double-hop for SQL Server linked server, you may go « known […]
Released: SQL Server 3rd Party Backend for Django v1.2
We have released version 1.2 of the SQL Server 3rd Party Backend for Django. This release contains support […]
.NET 7 Networking Improvements
With the recent release of .NET 7, we’d like to introduce some interesting changes and additions done […]
SQL Server のフルテキスト検索機能を用いて Word や PDF ファイルから日本語を検索する Search Japanese from ...
For an English version of this content scroll below or click here こんにちは、 SQL Server サポート チームです。 […]
SQL Server のフルテキスト検索機能を用いて Word や PDF ファイルから日本語を検索する
こんにちは、 SQL Server サポート チームです。 本記事では SQL Server のフルテキスト検索機能を用いて Word や PDF ファイルから日本語を検索するための手順を紹介します。 SQL Server のフルテキスト検索の詳細については下記ページをご参照ください。 […]
Update: ODBC Driver 17.10.2 for SQL Server Released
Version 17.10.2 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.10.2 brings a few […]
Connecting the Dots of Azure SQL CICD Part 3: Testing ...
In part 3 of our Azure SQL database change management (CICD) series we cover testing your code […]
Cardinality Estimation Feedback in SQL Server 2022
Part of theSQL Server 2022 blog series. Cardinality estimation (CE) is a process used by the query optimizer […]
FCI failed to do failover because of ReAclDirectory : Failed ...
Customer was trying to apply SQL2014 SP3 in Failover cluster instance. They applied patch to passive node, then […]
New In SQL Server 2022 and Azure SQL: XEvent Performance ...
Running Extended Event (XEvent) sessions on SQL Server has a cost. Since XEvents was designed for high-performance, this […]
Azure KeyVault を用いて AG 環境の暗号化を実施する
こんにちは、 SQL Server サポートです。 今回は、 Always On 可用性グループを構成するデータベースを Azure Key Vault を利用し TDE 暗号化する手順についてご紹介します。 手順の大まかな流れとしては以下の公開情報の手順を、プライマリ、セカンダリ両方で実施し、同じ非対称キーを用いてTDE暗号化する流れとなります。 Azure […]
Troubleshooting external data and access policies in Azure SQL and ...
The article is published here on the Azure SQL Blog: Troubleshooting external data and access policies in Azure SQL […]
Manage, govern, and secure all your SQL Servers with new ...
Part of the SQL Server 2022 blog series. In the face of changing market conditions and pressure to accelerate […]
SQL Server がインストール済みのAzure VM をデプロイする際、サーバーの照合順序を変更すると、デプロイに失敗する場合があります
こんにちは。日本マイクロソフト SQL Server サポートチームです。 SQL Server がインストール済みのAzure VM をデプロイする際、サーバーの照合順序を変更することができます。しかし、サーバーの照合順序を変更してデプロイした場合、デプロイに失敗することがあります。 今回は、デプロイに失敗する原因と対処について説明します。また、デプロイする際にサーバーの照合順序を変更する必要がない場合があるため、デプロイする前にご確認いただきたいこととして、まとめました。なお、このブログの内容は2022 年 11 月時点の情報となります。本件については、既知の問題として認識しており対応を検討しておりますため、対応に進捗がある場合には、こちらも更新します。 ●対象の画面 SQL Server […]
Azure Data Studio November release
In this release of Azure Data Studio, we have exciting news to share across several of our core […]
New SQL Server on Azure Virtual Machines and Azure SQL ...
Customers who are running their SQL Server workloads using SQL Server on Azure Virtual Machines and Azure SQL […]
Manage, secure, and govern your SQL Server estate from Azure
Overview Our learnings from talking to several enterprise customers is that businesses are leveraging hybrid and multi-cloud approaches […]
SQL Server 2022 is now generally available
Part of theSQL Server 2022 blog series. Today, we announced the general availability of SQL Server 2022, the […]
Link feature for Azure SQL Managed Instance: Connecting SQL Server ...
Part of theSQL Server 2022 blog series. We are excited to announce general availability (GA) of the link […]
Azure SQL Database External REST Endpoints Integration Public Preview
The ability to call a REST endpoint natively from Azure SQL Database, which was made available via […]
Report Server Temporary database configuration with Always on Availability groups ...
Report Server uses Report Server Temporary database to store session and execution data, information related to cached reports. […]