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:
Смотрите видео Azure SQL Database Maintenance Plans with DYNAMIC Azure Data Factory Pipeline!! онлайн без регистрации, длительностью 16 минут 35 секунд в хорошем hd качестве. Это видео добавил пользователь Tales From The Field 15 Май 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1 тысяч раз и оно понравилось 47 людям.