Next Meeting: Thu, Aug 21 2014
21 AUG 2014 NTSSUG Meeting
6:00 - 6:20 - Welcome, Announcements & Food
6:20 - 7:20 - Beyond the Basics: Next Level SSIS Development (3 part series) by Tim Mitchell
7:30 - 8:30 - Workload Tuning with Distributed Replay by John Sterrett
8:30 - 8:45 - Raffle and closing
Event Time : Thu, Aug 21 2014 18:00 - 21:00 Central Daylight Time
Your Local Time: Thu, Aug 21 2014 23:00 - 02:00
Microsoft Building LC-1
7000 North Highway 161
Beyond the Basics: Next Level SSIS Development (3 part series)
Tim Mitchell, Group Principal Linchpin People
For anyone who has worked with SSIS even for a short time, the basics are fairly easy to grasp. Creating a simple data flow, adding an SQL task, and performing basic transformations are fairly intuitive even for the newbie SSIS developer. However, SSIS has a lot of capabilities beyond simple source-to-target data loads. From data profiling to data cleansing to unconventional sources and destinations, SQL Server Integration Services has a lot of deeper features that are sometimes overlooked. In this 3-part series, we will cover some of those intermediate-to-advanced level behaviors in SSIS. Among the topics of discussion: Some of the lesser known, but still useful, data exploration and data quality components Making dirty data clean again: Expert data cleansing in SSIS I didn't know you could do that with SSIS! Feel free to bring your complex SSIS questions! Toward the end of the series, as time permits, I'll try to cover questions related to any additional topics from your questions.
About Tim :
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. Tim is an independent BI consultant and a group principal with Linchpin People. As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. Tim is coauthor 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, Texas area. You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.
Workload Tuning with Distributed Replay
John Sterrett , Group Principal Linchpin People
We might know how to tune a query for optimal performance or create additional indexes to ensure faster execution, but how do we ensure that our changes don’t hurt our total workload? Have you ever completed an upgrade and wondered if you were truly getting better performance? Do we know if the new 3rd Party application upgrade will make performance better or worse? In this session, we will go over a process used to tune a workload and answer the common questions above. In this presentation we will also use Distributed Replay and RML Utilities to answer these questions.
John Sterrett is a Group Principal and Sr. Consultant at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a PASS Regional Mentor and founded WVPASS user group and the HADR Virtual Chapter.