Quickly Setting Up a Sandbox with Azure SQL DB/MI and AAD Synchronization
Introduction During the migration journey from SQL Server to Azure SQL Database or Managed Instance, the customers I meet often wondering how to deal with the Integrated Authentication, their applications, especially the legacy ones. The following tutorial will ... continue reading
Improve Query Performance by Managing Statistics in Azure SQL | Data Exposed: MVP Edition
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 Azure ... continue reading
Advancing the outage experience—automation, communication, and transparency
“Service incidents like outages are an unfortunate inevitability of the technology industry. Of course, we are constantly improving the reliability of the Microsoft Azure cloud platform. We meet and exceed our Service Level Agreements (SLAs) for the vast majority of ... continue reading
User initiated manual failover on 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 node degradation or fault detection, or during our regular monthly software ... continue reading
ConfigMgr Performance Baseline the Easy Way
Hi, Jonas here! Or as we say in the north of Germany: "Moin Moin!"I am a Customer Engineer based in Germany and I recently played a bit with Azure Log Analytics (now called Azure Monitor) and the on-premises monitoring capabilities ... continue reading
How to optimize your Azure workload costs
The economic challenges posed by the global health pandemic continue to affect every organization around the world. During this difficult time, cost optimization has become an especially critical topic. Recently, we provided an overview of how to approach cost optimization ... continue reading
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
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
Announcement- System Center Data Protection Manager 2019 UR2 is here!
System Center Data Protection Manager offers enterprise grade backup and recovery of critical workloads. We are excited to announce the release of Update Rollup 2 for System Center 2019 Data Protection Manager. This update rollup includes new features, critical bugs ... 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