What is Azure Arc Enabled PostgreSQL Hyperscale? | Data Exposed
In this episode with Jean-Yes Devant, we’ll introduce Azure Arc enabled PostgreSQL Hyperscale and provide an overview of its capabilities. We’ll also share how you can get started with Azure Arc enabled PostgreSQL Hyperscale. Watch on Data Expos …
Creating index becomes extremely slow when all rows are in one partition
A customer reported that they found creating indexes sometimes become very slow in SQL2017. We analyzed this issue and found below symptom This issue happens when creating index on partition table. But all rows are in one partition. This issue happens …
Understanding Azure Arc Enabled SQL Server | Data Exposed
In this episode of Data Exposed with Sasha Nosov, learn how Azure Arc allows you to leverage Azure Services for your existing database applications hosted on-premises or in other public clouds, without changing or even stopping them. Watch on Da …
Common Criteria Certification for SQL Server 2019
We are very pleased to announce that SQL Server 2019 has obtained Common Criteria certification for the Windows and the Linux version. SQL19 on Windows certificate Overall, SQL Server 2019 is the 7th major release that has successfully co …
Released: Microsoft.Data.SqlClient 2.1 Preview 2
A new preview of Microsoft.Data.SqlClient was recently released. The SqlClient team is moving forward with continuous updates and improvements to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year …
SQL Server Management Studio 18.7 now generally available
The release of SQL Server Management Studio (SSMS) 18.7 is now generally available for download. Today we’re sharing some of the updates from the release and the ongoing work in SQL Server Management Studio. Download SSMS 18.7 and read on for some high …
Microsoft Azure at PASS Virtual Summit 2020
It is almost time for PASS Virtual Summit 2020, the premier learning event for the data professional. Similar to the in-person event, this virtual conference will include the latest SQL Server and Azure Data innovations, practical training, and network …
Released: Azure SQL DB Management Pack (7.0.26.0)
We released a new version of SCOM Management Pack for Azure SQL DB. The biggest change is that it now supports vCore-based pricing tier for Azure SQL DB. This model was introduced after the last Azure SQL DB MP release so the previous MP (7.0 …
Released: Support for Dynamic Network Names (DNN) Listeners for Always On Availability Groups
As of SQL Server 2019 CU8, we now support the use of Availability Group Listeners based on Dynamic Network Names (DNN Listeners). DNN listeners are especially useful in Azure VM environments, as they eliminate the need to configure Azure Load Ba …
How to Deploy Azure Arc Data Services Anywhere | Data Exposed
In this episode of Data Exposed with Tolga Tekin, learn about the ability to deploy Azure Arc Data services via Kubernetes to any hardware platform. Watch on Data Exposed Resources: Azure Arc enabled SQL Server (preview) View …
Early technical preview of JDBC Driver 9.1.0 for SQL Server released
We have released a new early technical preview of the JDBC Driver for SQL Server which contains numerous additions and changes. Precompiled binaries are available on GitHub and also on Maven Central.Below is a summary of the new add …
Azure SQL VM Automatic Registration and Reporting Services Images
We have a number of customers that leverage the benefits offered by the SQL IaaS extension which I had blogged about a few days ago. One of the common feedback was the effort required to enable the extension for multiple VMs especially if you were runn …
The October 2020 release of Azure Data Studio is now available
The October release of Azure Data Studio is now generally available. Download Azure Data Studio and review the release notes to get started.Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the Micro …
Microsoft Drivers 5.9.0 Preview 1 for PHP for SQL Server Released
We recently released the next preview of the Microsoft Drivers for PHP for SQL Server, version 5.9.0-preview1. This preview release has been built with PHP 7.2+ and tested on all supported platforms. Notable items about this release include: …
Cumulative Update #8 for SQL Server 2019 RTM
The 8th 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 mo …