North Texas SQL Servers Users Group

Next Meeting

Thursday,

August

21

21 AUG 2014 NTSSUG Meeting

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 21:00 Central Daylight Time
  • Language: English

RSVP Here: None
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

Featured Presentation:

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.

About John:
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.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











Back to Top
cage-aids
cage-aids
cage-aids
cage-aids