September 2012
Intermediate to advanced
444 pages
12h 17m
English
book
SQL Server 2012 Integration Services Design Patterns
by Andy Leonard, Matt Masson, Tim Mitchell, Jessica M. Moss, Michelle Ufford
Content preview from SQL Server 2012 Integration Services Design Patterns
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
CHAPTER 1
Metadata Collection
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 on 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 RDBMS systems provide metadata to help DBAs monitor their systems. If you’ve been a DBA for a few years, you may even have ...