ODBC Driver 17.6 for SQL Server Released
Version 17.6 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.6.1 brings numerous new features and fixes to the driver. FeaturesSupport Managed Identity authentication against Azure Key Vault when using Always Encr …
Azure SQL – Automated Backups (Part 2) | Data Exposed
In the last part of this two-part series, Shreya Verma takes a deeper dive into backup options by showing us point-in-time, long-term retention, and geo restore demos. To learn about the different backups options Azure SQL provides and how to effective …
SQL2019 certificate import error « selected certificate name does not match FQDN of this hostname »
Recently, I tried to use the SQL Server 2019 import certificate feature in configuration manager, however, when I import by the pfx file, it prompted me errors at the last step as below: Errors or Warnings for certificate:C:UsersAdministrator.CONTOSODe …
More ways to save when you migrate SQL Server data to Azure SQL
A new normal is emerging globally as businesses restart or rebuild in the face of rapidly changing conditions. To keep up with the pace of change and address new opportunities that arise, businesses are looking to the cloud for ways to optimize their I …
Enhanced support for Azure AD Guest Users for Azure SQL
We are announcing public preview of a new capability that enables creation of Azure AD guest users directly as database users and setting Azure AD guest users as Active Directory admin for SQL for Azure SQL Database, Managed Instance and Synapse Analyt …
Support for Azure AD user creation on behalf of Azure AD Applications for Azure SQL
We are announcing a public preview for Azure AD user creation support for Azure SQL Database and Azure Synapse Analytics on behalf of Azure AD Applications (service principals). See Azure Active Directory service …
Configure multiple-subnet AlwaysOn Availability Group by modifying CIB
In the Windows world, a Windows Server Failover Cluster (WSFC) natively supports multiple subnets and handles multiple IP addresses via an OR dependency on the IP address. On Linux, there is no OR dependency, but there is a way to achieve a proper mult …
Configure multiple-subnet AlwaysOn Availability Groups by modifying CIB
In the Windows world, a Windows Server Failover Cluster (WSFC) natively supports multiple subnets and handles multiple IP addresses via an OR dependency on the IP address. On Linux, there is no OR dependency, but there is a way to achieve a proper mult …
Azure SQL – Automated Backups (Part 1) | Data Exposed
In part one of this two-part series, Shreya Verma discusses the different backups options (point-in-time restore, long-term retention) Azure SQL provides and how to effectively manage them. Watch on Data Exposed Additional Resources:Overv …
Changing default MAXDOP in Azure SQL Database
Executive Summary To improve customer workload performance and reduce unnecessary resource utilization, the default MAXDOP setting for new databases in Azure SQL Database is changing from the previous default of 0 (unlimited) to 8. Why MAXDOP ma …
GA of new memory and compute optimized hardware options in Azure SQL Database
Now released for general availability (GA), M-series and Fsv2-series are new hardware generations in Azure SQL Database specialized for workloads requiring very high compute or memory scale or very …
SQL Server Management Studio 18.6 is now generally available
The release of SQL Server Management Studio (SSMS) 18.6 is now 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.6 and read on for some highlights from …
Benchmarking SQL Server and Azure SQL with WorkloadTools | Data Exposed: MVP Edition
Lifting and shifting your application to the cloud is extremely easy, on paper. The hard truth is that the only way to know for sure how it is going to perform is to test it. Benchmarking on-premises is hard enough, but benchmarking in the cloud can ge …
Exploring Azure SQL Managed Instance Management Pack
We released System Center Operations Manager Management Pack for Azure SQL Managed Instance recently. It provides comprehensive monitoring capabilities for SQL Managed Instance. If you have a hybrid data environment, you can use a single monitoring sol …
How to find SQL Server Replication related jobs and T-SQL statements
Verbose log is heavily used in replication troubleshooting. You need to find the right job to enable to verbose log. However, it’s not easy to find the jobs when you have hundreds replication jobs in one server. Here is how: 1 …