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

preview_player
Показать описание
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:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #AzureSQLDB #SQLServer #SQLInsiderSeries
  1. Microsoft Developer
  2. Azure
  3. Microsoft
  4. Tech
  5. Technology
  6. Dev
Рекомендации по теме
SQL Insider Series: 0:11:12

SQL Insider Series: Restoring a backup from LTR in Azure SQL DB | Data Exposed

SQL Insider Series: 0:20:59

SQL Insider Series: Protect your sensitive data using Azure SQL DB | Data Exposed

SQL Insider Series: 0:19:28

SQL Insider Series: SQL Migration tools, which one and when? | Data Exposed

SQL Insider Series: 0:12:41

SQL Insider Series: How and Why to Virtualize your Data in Azure SQL Managed Instance | Data Exposed

SQL Insider Series: 0:14:06

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

SQL Insider Series: 0:09:25

SQL Insider Series: Azure Advisor Signals – What are they | Data Exposed

Network Security for 0:08:16

Network Security for Azure SQL | Azure SQL for beginners (Ep. 22)

SQL Insider Series: 0:11:29

SQL Insider Series: Exporting Azure SQL DB BACPAC file to Azure with Azure Automation | Data Exposed

Data Protection in 0:04:07

Data Protection in Azure SQL | Azure SQL for beginners (Ep. 26)

Set Up Microsoft 0:07:44

Set Up Microsoft Azure SQL Server and SQL Database (Step-By-Step Tutorial)

SQL Insider Series: 0:11:40

SQL Insider Series: Architect your Azure Data Estate with Well-Architected Framework | Data Exposed

Capturing Query Metrics 0:14:41

Capturing Query Metrics in Azure SQL Database | Data Exposed: MVP Edition

How to Scale 0:19:54

How to Scale Your Apps in Azure SQL Database | Data Exposed

SQL Server on 0:06:59

SQL Server on Azure VM Overview | Azure SQL for beginners (Ep. 4)

Introduction to Performance 0:07:45

Introduction to Performance Troubleshooting [1 of 7] | Azure SQL for beginners

Deploy and Verify 0:10:55

Deploy and Verify Azure SQL | Azure SQL for beginners (Ep. 13)

Migrate SQL Server 0:19:38

Migrate SQL Server to Azure | Data Exposed

Connecting SQL Server 0:16:38

Connecting SQL Server 2016 to Azure - SQL Managed Instance link | Data Exposed

Comparing Azure SQL 0:09:23

Comparing Azure SQL Database and SQL Server in a Virtual Machine

Learning How to 0:05:56

Learning How to Transition Your SQL Server Skills to Azure SQL | Data Exposed

Azure SQL Database: 0:20:36

Azure SQL Database: Multi-model features | Azure Friday

Bringing the power 0:21:02

Bringing the power of blockchain to Azure SQL Database and SQL Server with ledger | Data Exposed

SQL Server in 0:24:44

SQL Server in the Cloud: Creating a Microsoft Azure SQL Database (2023 Version)

Link local SQL 0:00:57

Link local SQL Servers to Azure SQL Managed Instances.

Комментарии
Автор

Thank you very much for the great presentation Stephen!!! Elastic Jobs solving multiple challenges!

sergreen
Автор

We need autoscaling for DTU in order to reduce the costs. I know you will reply "there is vCore for that" but no, that is too expensive.

francescomantovani
Автор

we can query from master db for current service objective of a database without breaking connection

Cloudintelligence
Автор

Hey there, god bless your efforts in this channel.
As a newbie sql learner i have general enquiry.
Where should a database optimally be stored inside a company?
Is it convenient to traffic all raw data to a central pc on which i would work on the database software from there(sql server),
or is the database optimally to be located on a separate machine.
Looking forward to learn from you.

hasanmougharbel