Azure SQL Database Maintenance Plans with DYNAMIC Azure Data Factory Pipeline!!
Daniel Taylor aka, DBABulldog, joins us to show how you can use the amazing Ola Hallengren's SQL Server Maintenancce Solutions to manage your database maintenance in Azure SQL Database! Wait... WHAT'S THAT YOU SAY?!? THERE'S NO SQL AGENT!!! WE DON'T NEED ONE!! Dan walks you through step by step how to use Dynamic Pipelines in Azure Data Factory to schedule your maintenance!!
Ola Hallegren's Scripts
How to Create a Dynamic Pipeline in Azure Synapse Analytics or Azure Data Factory!!
Quickstart: Get started with Azure Data Factory
Quickstart: Create a single database - Azure SQL Database
SHOULD WE DO INDEX MAINTENANCE ON AN AZURE SQL MANAGED INSTANCE OR AZURE SQL DATABASE?
chapters
00:00 Introduction
00:54 Pre-Requisites
01:37 Environment & Deploy Database Objects
02:45 Create Link Service
04:55 Create Database Lookup Table
08:22 Foreach Loop Against Azure SQL DBs
14:35 Debug & Validate
15:39 Closing thoughts
/*******************
/CONNECT WITH US!!
/*******************
Tales from the Field
Twitter:
Linkedin:
Blusky:
Bradley Ball
Twitter:
Linkedin:
Blusky :
Daniel Taylor
Twitter:
Linkedin:
Blusky:
Neeraj Jhaveri
Twitter:
Linkedin:
Blusky:
Josh Luedeman
Twitter:
Linkedin:
Blusky:
Andrés Padilla
Twitter:
Linkedin:
Watch video Azure SQL Database Maintenance Plans with DYNAMIC Azure Data Factory Pipeline!! online without registration, duration 16 minute 35 second in high hd quality. This video was added by user Tales From The Field 15 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1 thousand once and liked it 47 people.