Following up on her post about automatic plan correction, Erin Stellato talks about a new feature in Azure SQL Database: Automatic Index Management.
Category: Azure (3)
Erin Stellato gives an overview of Automatic Plan Correction in SQL Server 2017 and Azure SQL Database, and assures us that Microsoft is not trying to code us out of jobs.
Steven Wright explains how to diagnose performance issues in Microsoft APS and Azure Data Warehouse with SentryOne Alerts and lists some custom Advisory Conditions (AC) that many people find useful...
Tim Radney gives an overview of Managed Instances, and explains how they bridge the gap between on-premises SQL Server and Azure SQL Database.
Microsoft MVP John Martin describes some of the sessions in the upcoming SQLBits 2018 confernece - including his pre-conference training session in SQL and Azure.
Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database - what they get you, and how much they cost.
Jason Hall gives a technical walk-through of one of his favorite use cases for Plan Explorer: troubleshooting application and Entity Framework code.
John Martin, Microsoft MVP, will present a full day pre-con on Getting Started with SQL and Azure at SQLBits 2018 on 21st and 24th of February, 2018.
Glenn Berry explains the importance of hardware choices for SQL Server running on your own hardware vs. Azure Virtual Machines.
Azure Resource Manager (ARM) allows us to deploy, manage, and secure resources in Azure. This post covers using ARM templates for automation of deployments.
Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.
Andy Mallon explains DTUs (Database Transaction Units) and the differences you might see between the documentation and practical usage.
Kevin Kline and Ben Lezin hold a short Q & A with Gavin Payne and Mike Wood about Azure architecture and improvements.
The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative insight into the performance differences across two versions of a database workload on SQL Server.
Kevin Kline invites you to three webinars coming up in January: A two-part series on the Azure platform, with Gavin Payne; and a session from Paul Stanton on running SQL Server inside Docker containers.
