{"id":983,"date":"2013-12-04T15:59:19","date_gmt":"2013-12-04T15:59:19","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=983"},"modified":"2024-01-06T16:46:30","modified_gmt":"2024-01-06T16:46:30","slug":"dec-11-2013-ssis-design-patterns-for-better-performance-matt-batalon","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=983","title":{"rendered":"Dec-2013 ~ SSIS Design Patterns for Better Performance ~ Matt Batalon"},"content":{"rendered":"<p><a href=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/matt-batalon.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-thumbnail wp-image-710\" title=\"matt-batalon\" alt=\"\" src=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/matt-batalon-150x150.jpg\" width=\"150\" height=\"150\" \/><\/a><\/p>\n<p><span style=\"color: #800000;\">Presenter:<\/span> Matt Batalon<\/p>\n<p><span style=\"color: #800000;\">Topic:<\/span> SSIS Design Patterns for Better Performance<\/p>\n<p>These days ETL developers face two common problems:<br \/>\n1: They are managing more and more ETL processes that have to complete in a shorter time window, and<br \/>\n2: their data is continuously growing. Today, more and more data has to be extracted from multiple sources, transformed, and loaded into its intended destination faster than ever before. SQL Server Integration Services is a robust product with lots of different options to choose when building an ETL package. Of course speedy hardware helps when it comes to performance, but have you ever wondered how the decisions you make when developing a package can affect the package&#8217;s performance? Come to this session to explore how SSIS handles memory, and have a better understanding of how certain tasks and transformations can affect your package&#8217;s performance.<\/p>\n<p><span style=\"color: #800000;\"><br \/>\nBiography:<\/span><\/p>\n<p>Matt has 15 years of experience in the Information Technology field with a focus on software development and database administration. For the past ten years, he has worked extensively with Microsoft SQL Server and the .NET framework.<br \/>\nHe has a Bachelors Degree from Bryant University with a concentration in Computer Information Systems, and also holds the Microsoft Certified Information Technology Professional (MCITP) Certification in Database Administration.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Presenter: Matt Batalon Topic: SSIS Design Patterns for Better Performance These days ETL developers face two common problems: 1: They are managing more and more ETL processes that have to complete in a shorter time window, and 2: their data is continuously growing. Today, more and more data has to be extracted from multiple sources, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[185],"tags":[157,10],"class_list":["post-983","post","type-post","status-publish","format-standard","hentry","category-2013-events","tag-design-patterns","tag-ssis"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=983"}],"version-history":[{"count":6,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/983\/revisions"}],"predecessor-version":[{"id":1127,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/983\/revisions\/1127"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}