The PASS Data Architecture Virtual Group focuses on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform.

News and Updates

 

EmailSignature

Call for Speakers and Volunteers

We are looking for presenters for the Data Architecture Virtual Chapter. Whether you have 10 minutes worth to discuss on a specific insight, or a raft of full-length decks ready to roll, we want to hear from you.

EMail us at davc@pass.org

Upcoming Meetings

Are There Ticking Time Bombs in Your SSIS Packages?

Wed, Oct 04 2017 13:00 Central Daylight Time

RSVP: None

Are There Ticking Time Bombs in Your SSIS Packages?

Could your seemingly-normal SSIS package be hiding a disaster, waiting to detonate at the most inconvenient time? Integration Services is an incredibly flexible product, and that flexibility can lead to good - and occasionally bad - design patterns. Small and seemingly trivial design decisions can lead to big issues down the road, including leaky data flows, data quality issues, paralyzing performance issues, and other explosive behaviors. In this session, we will explore some of the most common SSIS design patterns that are potentially more harmful than they first appear. From package configuration to control flow constraints, and data flow transformations to logging, we'll demonstrate what can go wrong and show some alternative designs to prevent these types of problems from developing into bigger issues.


Tim Mitchell

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQL Saturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

 

Nutanix is now the Data Architecture Virtual Chapter sponsor. http://bit.ly/sqlonnutanix

 

 

Data Architecture underpins just about everything we do in IT. Without a clear understanding of how data is structured, there is no reliable way to derive meaning from it. Data Architecture drives the design and governance of data systems, and thus should be of interest to any data professional. Data Architecture provides the blue-prints that we all share, whether we be DBAs, data integration developers, database developers, data warehousing professionals, data presentation developers or client-side application developers persisting data for later retrieval.

 

 

 

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