Sites Microsoft


Changes to KB articles used for Cumulative Updates

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

Back in March 2020, the main Knowledge Base (KB) articles for Cumulative Updates (CUs) started including inline description for fixes. We call those descriptions “blurbs” and they replace many of the individual KB articles that existed for …

Improve Query Performance by Managing Statistics in Azure SQL | Data Exposed: MVP Edition

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

Within Azure SQL maintenance tasks such as backups and integrity checks are handled for you, and while you may be able to get away with automatic updates keeping your statistics up-to-date, sometimes it’s not enough. Proactively managing statistics in …

Changes to Knowledge Base articles used for Cumulative Updates

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

Summary: In March 2020 we introduced inline, short description of fixes in the master Cumulative Update KB articles. We call those descriptions “blurbs” and they replace many of the individual KB articles that existed for each product fix a …

Log reader agent may raise a Non-yielding Scheduler dump in SQL Server running on Linux OS

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

If you are running SQL Server 2017 or SQL Server 2019 on Redhat 7.x or UBUNTU 16.x Linux operating systems and configured Transactional Replication or Change Data Capture feature, then sporadically log reader agent may fail to read the transactional lo …

Azure SQL Capacity Planning: Overview | Data Exposed

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

Whether migrating an existing application or designing a brand new one, capacity planning process plays a critical role. Learn how to navigate across Azure SQL Database options like hardware generation, service and compute tiers, and instance sizing pr …

The August 2020 release of Azure Data Studio is now available

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

The August release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions.Azure Data S …

How to configure the WSFC 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   …

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

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 there are two types of automated backups that customers can use for restoring the …

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 …


Pages :