SSIS Database Maintenance Playbook

Database maintenance is an inescapable part of a database administrator's life. This course teaches you how to use SQL Server Integration Services (SSIS) to automate that work and save time.
Course info
Level
Advanced
Updated
Jun 26, 2020
Duration
1h 10m
Table of contents
Description
Course info
Level
Advanced
Updated
Jun 26, 2020
Duration
1h 10m
Description

Every database administrator needs to have a database maintenance plan, whether they're looking after one database or 1000s of servers. Those plans can be split into regular, scheduled maintenance and on-demand operations for unscheduled requirements. In this course, SSIS Database Maintenance Playbook, you'll learn how to use the power of SQL Server Integration Services to get the job done and explore many related operations that will save you from searching for solutions or writing your own from scratch. First, you'll discover how to plan a maintenance schedule and the pillars that support that work. Next, you'll delve into the operations that you can use for work that come up less frequently, but still need to be done efficiently and correctly. Finally, you'll explore how to parameterize these operations as well as powerful methods for run-time control. When you're finished with this course, you'll have a great tool set that will save you time and get your database maintenance on a solid footing.

About the author
About the author

Gerald is a multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater). 

More from the author
PostgreSQL Functions Playbook
Advanced
2h 28m
Dec 10, 2019
More courses by Gerald Britton
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Gerald Britain. I'm a senior solutions designer specializing in sequel server database technologies. Welcome to my course, the S s s database maintenance playbook. In this course, we're going to work with database maintenance using sequel server integration services or S S. S, as it is often called. You may be a full time TV A with years of experience, maintaining databases or an accidental Devi a someone who has to do the job simply because there's no announce to do it. Either way, a thorough knowledge of the powerful tasks available with S s, I s will equip you with essential tools for this important job. Some of the major topics that we will cover include the critical role played by schedule database maintenance, the importance of designing DB maintenance with business goals and constraints in mind, the essential sis tasks that support the five pillars of database maintenance societies, tasks useful for on demand requests and data migrations and the power of your amateur ization and dynamic runtime operations. By the end of this course, you'll know the key s s A s task used for database maintenance both scheduled and ad hoc you will also learn great techniques that you can use wherever you use as a science and for whatever purpose. Before beginning the course, you should be familiar with sequel server integration services and working with visual studio to design, test and deploy a society's packages and projects. From here, you should feel comfortable diving into advanced topics such as database backup and restore in detail, Advanced Index and statistics maintenance and Managing Sequel Server in the Enterprise. I hope you'll join me on this journey to learn database maintenance with the S S I s database maintenance playbook.