North Texas SQL Servers Users Group

Next Meeting




19 JUN 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 - The Top Customer Problems: How to avoid calling Bob (Level 300) by Bob Ward
7:30 - 8:30 - Beyond the Basics: Next Level SSIS Development (3 part series) by Tim Mitchell
8:30 - 8:45 - Raffle and closing

Featured Presentation:

The Top Customer Problems: How to avoid calling Bob (Level 300)

Bob Ward, Principal Architect Microsoft

Come learn about the top problems customers call Microsoft for the SQL Server Database Engine. We will cover a range of topics including performance, errors, memory, and others. Learn more about the details of what customers bring to Microsoft support and learn the specific steps Microsoft uses to help customers resolve these problems. This session will include demonstrations of the tools built into the SQL Server product that you can use every day while deploying, managing, or troubleshooting your SQL Server environment As a bonus, we will talk about new troubleshooting tools coming for SQL Server 2014.

About Bob:
Bob Ward is a Principal Architect for the Microsoft Database Systems Group, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 25 years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 including Azure. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as SQL PASS Summit, SQLBits, SQLIntersection, and Microsoft Inspire and Microsoft Ignite. You can follow him at @bobwardms or Bob is the author of the new book Pro SQL Server on Linux available for Apress Media.

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 or follow him on Twitter at

Thank You to the 



of our May 2018 

SQL Saturday!

Back to Top