Select Page
Image 02.PNG

User initiated manual failover of SQL Managed Instance

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 a fault or node degradation, or during our regular monthly ... continue reading
configure-backup-retention-sqlmi.png

Fine tuning backup storage costs on SQL Managed Instance

In the previous article, we have explained how automated backups on Azure SQL Managed Instance work, how backups piles up, and some of the ways you contribute to such pile up. We have also explained how associated costs for excess ... continue reading

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

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 ... continue reading

Configuring backup storage redundancy in Azure SQL Managed Instance

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 for ... continue reading

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 ... continue reading

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 ... continue reading
Capture.AAD.Admin.PNG

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 principal with Azure SQL. What support for ... continue reading

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:Overview of Business ContinuityAutomated BackupsBackup Cost ManagementPiTR and ... continue reading

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 matters The “max degree ... continue reading

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 fast CPU speed.  M-series and Fsv2-series are supported for both single database and elastic pool deployments.  Gen5 hardware in SQL Database continues to provide a balanced compute and memory option that ... continue reading