Presented by Tim Mitchell
Total Running Time: 189
There is a great deal of focus on the development of SQL Server Integration Services (SSIS) packages which perform data movement, transformation, and cleansing operations. However, the work doesn't end there. Once the packages are done and ready, there's still overhead in making sure that they are properly deployed, secured, and monitored.
In this three-session course, we'll cover the administrative side of SSIS. We'll walk through the various deployment options, including a full review of the SSIS Catalog infrastructure. We will address security in SSIS, from managing sensitive information (such as passwords and metadata) in the packages to securing the SSIS Catalog.
Finally, we'll review monitoring SSIS packages, including a review of logging and validation. The entire presentation will be full of demos, giving you not just the theory but a live glimpse into how it truly works.
By the end of this course, you will:
- Gain a high-level understanding of the responsibilities of managing, monitoring, and protecting SSIS packages during and after deployment
- Learn about the moving parts of the SSIS catalog, and how it fits into the deployment life cycle of the ETL infrastructure
- Master the security model in the SSIS catalog, including how to set up and manage permissions on assets in the catalog
- Grasp ways to properly manage the package execution life cycle, including monitoring, logging, and maintenance operations
Session 1: Exploring the SSIS Catalog
In 2012, Microsoft rewrote the book on SQL Server Integration Services by introducing the SSIS catalog. The SSIS catalog revolutionized the way packages were deployed, stored, and secured by moving to a more integrated and easily managed infrastructure. The storage and execution of packages, the way they communicate with one another, and logging were all revamped in the SSIS catalog.
In this session, we will walk through the SSIS catalog: its moving parts, the deployment story, and day-to-day management. We will examine how packages are stored in the catalog, how package configurations have changed (for the better!), and what takes place during a package execution. Much of this presentation will be demo-based, so you'll get to see all of these moving parts in action.
Session 2: The SSIS Execution Life Cycle
Developing the SSIS package is only half of the battle. Once completed and deployed, there's still a significant amount of work that goes into executing, monitoring, and logging packages to make sure that they are running properly.
In this session, we'll cover the life cycle of a package post-deployment. Specifically, we'll address the different ways in which packages may be executed from the SSIS catalog, monitoring in-progress packages, and proper logging techniques. This presentation will be mostly demo, so attendees will get a driver's seat perspective on what is involved in managing packages deployed to the SSIS catalog.
Session 3: Managing Security in SSIS
Data security is important. But what about metadata security? Too often, our focus on security revolves solely on restricting access to the data itself, disregarding the fact that the moving parts of the ETL – package metadata, configurations, and execution permissions – must be managed as well to ensure that the data ecosystem is secure.
In this session, we'll cover the essentials of securing the SSIS catalog. We will walk through security of individual packages, including package/project protection levels. We will cover the configuration story, and demonstrate how to properly secure sensitive information (such as connection strings) outside of the package. Finally, we will discuss and demonstrate security in the catalog itself, including management of who can (and cannot) browse, edit, and execute packages.
About Our Instructor:
Tim Mitchell is a business intelligence consultant, author, and trainer. He has been working with SQL Server for a decade, working primarily in business intelligence, ETL/SSIS, data quality, and reporting. He holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce, and has been a Microsoft SQL Server MVP since 2010. Mitchell is an independent business intelligence consultant and a partner with Linchpin People.
As an active member of the community, he has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, IT/Dev Connections, SQL Saturday events, and various user groups and webcasts. Mitchell is co-author of the book, SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2. He is an active group member and speaker at the North Texas SQL Server User Group in the Dallas area.
Need to be invoiced or interested in registering 2 or more people? Please contact our customer service team at email@example.com or by phone at 800-262-1954 or 913-967-1719. Invoicing options and group discounts are available.