Sites Microsoft


How to configure the WFSC AG failover policy when the database level health detection enabled?

Publié le 12 août 2020 sur SQL Server Support Blog
 

The database level health detection failover option introduced on this article https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/sql-server-always-on-database-health-detection-failover-option?view=sql-server-ver15   …

User initiated manual failover on SQL Managed Instance

Publié le 11 août 2020 sur Azure SQL Database Blog
 

High availability is a fundamental part of SQL Managed Instance (MI) platform that works transparently for your database applications.  As such, failovers from primary to secondary nodes in case of node degradation or fault detection, or duri …

Tutorial: Create SQL Cluster(FCI) on RHEL

Publié le 11 août 2020 sur SQL Server Support Blog
 

In the Windows world, SQL Server integrates into Windows Server Failover Cluster (WSFC) natively, and we have a dedicated installation for SQL Server Cluster. However, on Linux, you need to install standalone SQL Server instance in the nodes first, and …

Cumulative Update #14 for SQL Server 2016 SP2

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

The 14th cumulative update release for SQL Server 2016 SP2 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 …

Learning How to Transition Your SQL Server Skills to Azure SQL | Data Exposed

Publié le 6 août 2020 sur Azure SQL Database Blog
 

The Azure Data team at Microsoft recently launched FOUR new ways for you to learn Azure SQL. They’ll show you how to translate your existing SQL Server expertise to Azure SQL including Azure SQL Database and Azure SQL Managed Instance through all-new c …

New Azure SQL Learning Tools Launched

Publié le 5 août 2020 sur Azure SQL Database Blog
 

With the significant trend of moving to the cloud, you need to understand how to set up your organization for success. That’s why Anna Hoffman, Data & Applied Scientist, and Bob Ward, Principal Architect, on the Azure Data team, created all-new con …

Configuring backup storage redundancy in Azure SQL Managed Instance

Publié le 5 août 2020 sur Azure SQL Database Blog
 

Database backups are an essential part of any business continuity and disaster recovery strategy, because they protect your data from corruption or deletion. In Azure SQL Managed Instance there are two types of automated backups that customers can use …

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 …


Pages :