{"id":7940,"date":"2015-10-14T17:15:17","date_gmt":"2015-10-14T17:15:17","guid":{"rendered":"http:\/\/craftydba.com\/?p=7940"},"modified":"2016-04-23T17:40:45","modified_gmt":"2016-04-23T17:40:45","slug":"rhode-island-ssug-october-2015","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=7940","title":{"rendered":"Rhode Island \u2013 SSUG \u2013 October 2015"},"content":{"rendered":"<p>I am driving thru America\u2019s Renaissance City, Providence Rhode Island, to present to the RI SQL Server User Group on October 14, 2015.  Check out the <a href=\"http:\/\/www.meetup.com\/Rhode-Island-SQL-Server-Users-Group\/events\/225935381\/\">meetup <\/a>for more details.<\/p>\n<p>I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn.<\/p>\n<p>Here is the gritty details of the presentation that I will be covering that night.<\/p>\n<p><span style=\"color: #008000\">Topic:<\/span><\/p>\n<p>Simplistic design patterns with the SQL Server Stack<\/p>\n<p><span style=\"color: #008000\">Abstract:<\/span><\/p>\n<p>Integration Services is a great development environment for ETL developers.  However, if you are new to ETL tools, there are so many tasks, objects and properties that can be used to design a solution.<\/p>\n<p>Where do you start?<\/p>\n<p>The purpose of this talk is to introduce simplistic design patterns to perform common tasks.<\/p>\n<p>I will be talking about five real world examples and exploring the design choices to solve each one.<\/p>\n<p><span style=\"color: #008000\">Coverage:<\/span><\/p>\n<p>1 &#8211; Define ETL process.<\/p>\n<p>2 &#8211; The Import\/Export wizard for excel file load.<\/p>\n<p>3 &#8211; The dtexec and dtexecui utilities.<\/p>\n<p>4 &#8211; Benefits of the SSIS Catalog.<\/p>\n<p>5 &#8211; Revisiting the excel file load.<\/p>\n<p>6 &#8211; Last time looking at this package.<\/p>\n<p>7 &#8211; Talk about three types of transformations.<\/p>\n<p>8 &#8211; Use the database engine to sort, add columns, aggregate and\/or merge when possible.<\/p>\n<p>9 &#8211; Bad vs Good design &#8211; slowly changing dimensions<\/p>\n<p>10 &#8211; Temporary work files.<\/p>\n<p>11 &#8211; Summary of patterns<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2015\/10\/SDP.zip\">Presentation Bundle<\/a><br \/>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I am driving thru America\u2019s Renaissance City, Providence Rhode Island, to present to the RI SQL Server User Group on October 14, 2015. Check out the meetup for more details. I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn. Here is the gritty details of the presentation that I will be covering that night. Topic: Simplistic design patterns with the SQL Server Stack Abstract: Integration Services is a great development environment for ETL developers.&hellip;<\/p>\n","protected":false},"author":1,"featured_media":7269,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1097],"class_list":["post-7940","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-sql-server--john-f-miner-iii--pass--presentation--rhode-island--user-group--simplistic-design-patterns--importexport-tool--ope"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/7940","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7940"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/7940\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/7269"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}