Abstract
The first Integration Services design pattern we will cover is metadata collection. What do we mean by metadata collection? Good question. This chapter could also be called “Using SSIS to Save Time and Become an Awesome DBA.” Many DBAs spend a large portion of time monitoring activities such as verifying backups, alerting on scheduled job failures, creating schema snapshots (“just in case”), examining space utilization, and logging database growth over time, to name just a very few. Most Relational Database Management Systems (RDBMS’s) provide metadata to help DBAs monitor their systems. If you’ve been a DBA for a few years, you may even have a “tool bag” of scripts that you use to interrogate metadata. Running these scripts manually is easy when you have just one or two servers; however, this can quickly become unwieldy and consume a large portion of your time as your enterprise grows and as the number of database servers increases.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Andy Leonard
About this chapter
Cite this chapter
Leonard, A., Mitchell, T., Masson, M., Moss, J., Ufford, M. (2014). Metadata Collection. In: SQL Server Integration Services Design Patterns. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0082-7_1
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0082-7_1
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0083-4
Online ISBN: 978-1-4842-0082-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books