SQL Server with Mr. Denny

Oct 28 2019   4:00PM GMT

Is it time for an SSIS checkup?

Denny Cherry Denny Cherry Profile: Denny Cherry


On November 15th, 2019 Meagan Longoria and Kerry Type will present their webcast “Is it time for an SSIS checkup?”.

Database health checks are a familiar concept to many people. We check database and server settings, ensure security is appropriately implemented, and validate HADR plans to meet business needs. But do you ever assess the health of your SSIS projects? Do you know what things you should look for? Join us as we talk through what we think should be included in a data integration health check specific to SSIS, whether you run SSIS on your own machine or as an Integration Runtime within Data Factory.

We’ll discuss server configurations such as memory allocation and Kerberos, development processes and source control, and creating and populating non-production environments. Next, we’ll show you some design patterns and anti-patterns that can affect the quality and speed of your data integration processes. Then we’ll talk about appropriate settings and use of the SSIS catalog. We will also, of course, address data security and sensitivity. And we’ll finish with maintenance and support topics.

Organizations running SSIS should be able to easily answer questions such as “What is my longest-running package?”, “Who should be contacted when a package fails, and who is their backup?”, “Is the SSISDB being backed up?”, “What is our HADR plan?”, and “What are our SLAs for data being available to consumers?”.

Don’t let your SSIS environment become neglected. Learn the concepts you need to know to keep it healthy.

Go over to the webcast’s webpage to sign up for the webcast.


 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: