With Azure Data Studio turning 3, it is maturing quite well.

Azure Data Studio is a game-changer for all Data Professionals.

Join Warwick Rudd as he shows you what Azure Data Studio has for Data Professionals and why it makes it easier for you to do your job.

Database backups are an essential part of any business continuity and disaster recovery strategy because they protect your data from corruption or deletion.

In this episode of Data Exposed with Uros Milanovic, he’ll share the two types of backups for restoring databases for Azure SQL customers, why database backups are important, how backups are kept, what options customers have, and much more.

Related Resources:

Learn the differences between the Basic, Standard, and Premium tiers of Azure SQL Single Database.

Provisioning is one component of maximizing the value of your deployment – licensing is another.

In this video with Matt Gordon, take a walk through the differences between licensing by DTU and by vCore and talk about what may be right for you and your needs.

Capacity planning plays a critical role in migrating an existing application or designing a new one. In the final part of this three-part series with Silvano Coriani, we’ll review various Azure SQL capacity planning scenarios, as well as review best practices and recommendations on what to use when. 

Time index:

  • 0:00 Introduction
  • 1:26 Greenfield development scenario
  • 5:42 Existing applications on-prem or other clouds scenario
  • 7:42 On-prem demo
  • 12:01 Changes in existing Azure SQL DB apps scenario

Microsoft Developer

In this episode of Data Exposed with Vladimir Ivanovic, he announces a set of major performance improvements for Azure SQL Managed Instances, which enable customers to migrate their more performance-hungry database workloads to Azure SQL Managed Instance.

These improvements are automatically enabled for all existing and future Azure SQL Managed Instances at no extra charge, making Azure SQL Managed Instance the best fully-managed database platform for mission-critical workloads.

Time stamps:

  • 0:00 Introduction
  • 0:58 Azure SQL Managed Instance Performance Improvements
  • 1:45 Improved log rate for SQL MI General Purpose
  • 2:40 Improved log rate for SQL MI Business Critical
  • 3:55 Pricing
  • 4:30 Opportunities
  • 5:22 Improvements are available now!

Resources:

  • Azure SQL Managed Instance Resource Limits: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?WT.mc_id=dataexposed-c9-niner
  • Service Tier Characteristics: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits#service-tier-characteristics

In the conclusion to this two-part series with Allan Hirt, learn how Azure can be used to create disaster recovery solutions for your on premises Microsoft SQL Server instances and databases through the use of built-in availability features of SQL Server. 

Index:

  • 0:00 Introduction
  • 1:22 Built in hybrid disaster recovery options overview
  • 2:22 Hybrid Log Shipping
  • 4:27 Hybrid “Normal” Availability Group
  • 7:34 Hybrid Distributed Availability Group
  • 11:55 Hybrid Failover Cluster Instance

In part one of this three-part series, Vasiya Krishnan introduces Azure SQL Edge and its features that make it the optimized database engine for IoT Scenarios. In part two, Vasiya will review customer examples and use cases, and in part three, she’ll conclude with a demo that demonstrates how to use Azure SQL Edge to build smarter renewable resources.