In the second part of this two-part series, Hamish Watson shows us how to use infrastructure as code to deploy an Azure Kubernetes systems cluster.

To learn about the many ways to deploy an Azure SQL database, watch part one: https://youtu.be/T05C-ro1_W0?WT.mc_id=dataexposed-c9-niner

Video Content:

  • 0:00 Introduction
  • 0:55 Demo: Deploying Azure Kubernetes systems cluster
  • 7:50 Get started on Azure

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 first part of this two-part series with Hamish Watson, we will look at the various methods available to deploy an Azure SQL database including PowerShell, Azure CLI and Terraform. Creating resources has never been easier or more standard than what we have now.

Related Links:

  • 0:00 Introduction
  • 1:55 A Match Made in the Cloud Overview
  • 4:42 Demo
  • 7:10 Other ways to deploy into Azure
  • 8:22 Continuation of demo
  • 8:56 CI CD Pipeline

In this video,  Rohit Nayak and Ann Hoffman will cover the Deny Public Network Access setting for SQL Database.

Customers can use this setting to block all public access via firewall rules and exclusively rely on private endpoint connections.

Chapters:
  • [01:03] How to shut down public connectivity to my databases
  • [01:44] Deny public network access demo
  • [04:06] Private endpoint connections demo
Resources:

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