North Texas SQL Servers Users Group

Next Meeting

Thursday,

July

17

17 JUL 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 - How Active Directory Affects SQL Server By Ryan Adams
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:

How Active Directory Affects SQL Server

Ryan Adams, DBA Verizon

If you have ever had a Kerberos or SSPI context error, then you won't want to miss this session. SQL Server has a large surface area and Active Directory can influence a big part of it. I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server. By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.

About Ryan:
Ryan Adams has worked for Verizon for 16 years. His primary focus is the SQL Server Engine, high availability, and disaster recovery. Previously he was a Senior Active Directory Architect and designed the company's worldwide Active Directory infrastructure. He serves on the Board of Directors for the North Texas SQL Server User Group and is President of the PASS Performance Virtual Chapter. He is also a PASS Regional Mentor and holds the following certifications: MCP MCSA MCSE MCDBA MCTS MCITP.

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.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











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