Azure SQL Edge Update – September 2023
Today, I am providing an update on the supported configurations of Azure SQL Edge, the version of SQL Server geared for IoT and IoT Edge deployments built on the latest versions of the SQL Server Database Engine. The following changes are e …
Cumulative Update #8 for SQL Server 2022 RTM
The 8th 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 …
Hotfix: JDBC Driver 12.4.1 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 12.4.1. The update addresses a few issues on top of the 12.4.0 release. Fixed issues Fixed metadata query getUserName() under impersonated security conte …
MarketPlaceからSQL仮想マシンを作成する場合とAzureVMに手動でSQLをインストールする場合の違いについて
こんにちは、 SQL Server サポートです。 Azure で SQL Server を利用する場合、 Market Place から SQL server インストール済みのイメージファイルを利用してデプロイする方法と、 SQL Server を含まない Azure VM をデプロイし、あとから SQL Server をセルフインストールする方法があります。その方法による違いについて解説いたします。 【前提】SQL Server インストール済みのイメージファイルか …
Announcing General Availability of Azure Portal Experience to Deploy Multi-Subnet Availability Group
This past November we announced the public preview of the Azure portal experience to deploy a multi-subnet Availability Group (AG) for SQL Server on Azure Virtual Machines. Today, we are excited to announce general availability (GA) of the end-to-end d …
Released : Public Preview of Azure Update Manager Integration with SQL Server on Linux Azure VM's
We are excited to announce the integration of Azure Update Manager with SQL Server on Linux Azure Virtual Machines. With Azure Update Manager, you will be able to patch your SQL Linux Azure VM’s at scale, automatically install SQL Server Cumulative Upd …
Announcing public preview of enhanced patching for SQL Server on Azure VM with Azure Update Manager
Today, we are pleased to announce the ability to patch your SQL Server on Azure VMs registered with the SQL Server IaaS Agent extension, at scale through Azure Update Manager. With Azure Update Manager, unlike with the existin …
Delegating permission management using Roles vs WITH GRANT OPTION
The article is published here on the Azure SQL Blog: Delegating permission management using Roles vs WITH GRANT OPTION – Microsoft Community Hub
Migration from Sybase ASE using SSMA CLI
Recently I learned a lesson through multiple testing around SSMA for Sybase. Let’s suppose you need to migrate your data from Sybase ASE to SQL Server. You could use the SSMA GUI tool to connect to both destinations and select schemas or objects to con …
Cumulative Update #22 for SQL Server 2019 RTM
The 22nd 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 the release or servicing m …
SQL Server 2022 now available for both RHEL 9 and Ubuntu 22.04 in Preview mode
We are glad to announce that SQL Server 2022 is now available in preview mode for both Red Hat Enterprise Linux (RHEL) 9 and Ubuntu 22.04. For this preview, only Evaluation edition is available, which is limited to 180 days starting Thursday, July 27th …
Cumulative Update #7 for SQL Server 2022 RTM
The 7th 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 …
I/O optimizations for tempdb in SQL Server and Azure SQL
I have found almost every day of my career at Microsoft, I learn something new about Microsoft SQL. It is one of the reasons I enjoy my job. In April of 2023, I was speaking at the MVP Summit in Redmond, Washington. One day I was spending time in a sid …
Azure Data Studio 1.45 Release and Hotfix
We released Azure Data Studio 1.45 over a week ago, and today we’re announcing a hotfix for it, release 1.45.1. If you read the release notes for 1.45, or perused the 200+ issues closed for the release, you already know that we introduced numerou …
JDBC Driver 12.4 for SQL Server Released
Version 12.4 of the Microsoft JDBC Driver for SQL Server has been released. Version 12.4.0 brings several added features, changes, and fixed issues over the previous production release. Added Added additional logging info to help debug 2118 …