Sites Microsoft


Cumulative Update #6 for SQL Server 2019 RTM

Publié le 4 août 2020 sur MS Tech Community
 

The 6th 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 …

JDBC Driver 8.4 for SQL Server Released

Publié le 3 août 2020 sur MS Tech Community
 

Version 8.4 of the Microsoft JDBC Driver for SQL Server has been released. Version 8.4.0 brings many added features, changes, and fixed issues over the previous production release. AddedAdded support for sensitivity ranking when using SQL Data Dis …

ODBC Driver 17.6 for SQL Server Released

Publié le 31 juillet 2020 sur MS Tech Community
 

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

Publié le 30 juillet 2020 sur Azure SQL Database Blog
 

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 »

Publié le 29 juillet 2020 sur SQL Server Support Blog
 

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

Publié le 28 juillet 2020 sur SQL Server Blog
 

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

Publié le 27 juillet 2020 sur Azure SQL Database Blog
 

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

Publié le 27 juillet 2020 sur Azure SQL Database Blog
 

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 Groups by modifying CIB

Publié le 24 juillet 2020 sur SQL Server Support Blog
 

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 Group by modifying CIB

Publié le 24 juillet 2020 sur SQL Server Support Blog
 

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

Publié le 23 juillet 2020 sur Azure SQL Database Blog
 

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

Publié le 23 juillet 2020 sur Azure SQL Database Blog
 

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

Publié le 23 juillet 2020 sur Azure SQL Database Blog
 

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 

Publié le 22 juillet 2020 sur SQL Server Blog
 

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

Publié le 21 juillet 2020 sur Azure SQL Database Blog
 

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 …


Pages :