As database professionals, we all know how to manage SQL Server Agent jobs using SQL Server Management Studio (SSMS), TSQL, and PowerShell. With Azure Data Studio and SQL Server Agent extension, we have new tools to create, maintain and manage SQL Agent jobs using Notebook. These are called Notebook Jobs. Once you successfully execute a Notebook job manually or via schedule, each run's results are saved into a separate Notebook, which you can easily share with others. In this episode of Data Exposed: MVP Edition, Taiob Ali will walk you through every step of Notebook Jobs.
0:00 Show begins
0:31 About Taiob Ali
1:34 Benefits of SQL Server Agent Jobs
4:50 Demo
12:30 Getting Started
✔️ Resources:
Github: [ Ссылка ]
About Taiob Ali:
Taiob Ali, Microsoft Data Platform MVP, is an accomplished technical leader with a proven record of success. During his last 15 years, he has worked with the Microsoft Data Platform and MongoDB, both on-premises and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience managing large database projects, including massive data migration, intricate process design, testing and deployment, performance tuning, and long-term capacity planning.
Taiob is currently working at “GMO LLC” as Database Solutions Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual chapters, Data Saturdays, and Azure conferences. He is a board member of New England SQL Server User Group, founder of 'Database Professionals Virtual Meetup Group', and organizer of Boston Data Saturday.
About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have a very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products, and solutions, to solve real-world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: [ Ссылка ]
📌 Let's connect:
Twitter: Taiob Ali, [ Ссылка ]
Twitter: Anna Hoffman, [ Ссылка ]
Twitter: AzureSQL, [ Ссылка ]
🔴 To watch other MVP Edition episodes, see our playlist: [ Ссылка ]
To check out even more Data Exposed episodes, see our playlist: [ Ссылка ]
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: [ Ссылка ]
Microsoft SQL Server: [ Ссылка ]
Microsoft Developer: [ Ссылка ]
#AzureSQL #SQLServer #NotebookJobs #ADS #AzureDataStudio
Ещё видео!