SQL Insider Series: Azure SQL DB – Automating scale up and down | Data Exposed

From the creator

In this episode of Data Exposed: SQL Insider Series, Stephen Giles and Anna Hoffman will take a look at how to use Transact SQL and various methods to automate the Scaling of Azure SQL Databases. Jump to: 0:00 Introduction 2:29 Flexible computer & storage options 2:48 Scaling Up and Down Process - Azure SQL Database 4:50 Demo 12:50 Getting started ✔️ Resources: Job automation with SQL Agent jobs - Azure SQL Managed Instance: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql Scale resources - Azure SQL Database: https://docs.microsoft.com/en-us/azure/azure-sql/database/scale-resources?view=azuresql Single database vCore resource limits - Azure SQL Database: https://docs.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases?view=azuresql Job automation with SQL Agent jobs - Azure SQL Managed Instance: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql 📝 SQL Insider Series Playlist: https://aka.ms/sqlinsiderseries 📌 Let's connect: Twitter: Stephen Giles, https://twitter.com/StephenGiles Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: AzureSQL, https://aka.ms/azuresqltw​​​​ 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #AzureSQLDB #SQLSe

Published 2022-07-07 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.