- Course
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
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.
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
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.
SSIS Database Maintenance Playbook
-
Version Check | 20s
-
Introducing Database Maintenance Using SSIS | 47s
-
Overview | 1m 39s
-
Understanding the Five Pillars of Database Maintenance | 2m 13s
-
Getting a Handle on the Business Perspective | 1m 23s
-
Introducing SQL Server Integration Services | 1m 24s
-
Picturing SSIS High-level Architecture | 1m 2s
-
Comparing Database Maintenance Plans and SSIS | 1m 57s
-
Module Summary | 1m