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.

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 principles, trying to find the sweet spot between performance, functionalities, and costs, in the first episode of this three-part series with Silvano Coriani.

Content:

  • 0:00 Introduction
  • 0:58 What is capacity planning
  • 2:04 Azure SQL Database dimensions to consider
  • 3:30 Deployment options
  • 4:50 Purchasing models
  • 6:25 Service tiers
  • 7:55 Compute sizes and resource limits

In this second part episode, Fernando Mejia walks through everything you need to plan for in a Hybrid Cloud architecture for Azure Kubernetes Service.

This includes IP address concerns from on-premises to Azure, hub and spoke topology, as well as the different options you have in Azure Kubernetes Service. 

Watch Part 1

Learn more: https://azure.microsoft.com/en-us/overview/kubernetes-on-azure

Learn all about the new data classification capabilities built into Azure SQL Database. Data Classification enables discovering, classifying, labeling & protecting the sensitive data in your databases.

Examples of sensitive data include business, financial, healthcare, personally identifiable data (PII). Discovering and classifying your most sensitive data can play a pivotal role in your organizational information protection stature.

Data discovery & classification is part of the Advanced Data Security (ADS) offering, which is a unified package for advanced SQL security capabilities.

Find out more about Advanced Data Security at: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-advanced-data-security?WT.mc_id=dataexposed-c9-niner-fw .