Next Meeting: Mon, Apr 27 2015
Winnipeg SQL UG - April 2015
Event Type: In-Person
Online Meeting URL: None
PIzza and drinks provided - please do not forget to register so we have an accurate count for pizza
Event Time : Mon, Apr 27 2015 17:30 - 20:00 Central Daylight Time
St. Boniface Library - Salle Marie Lynn Bernard
131 Provencher Blvd
Untangling the spaghetti: Patterns and Anti-Patterns in SQL and ETL development
Mike Diehl, Practice Lead, Databases and Business Intelligence Imaginet
Everyone has heard of "spaghetti code", but not many talk about "spaghetti data". Data environments grow over time, and often databases and servers become a tangled mess; if you had some pasta sauce, you could make lunch out of it! Coupling and cohesion are programming principles that guide programmers, but are often ignored in database integration practices. In this session we will look at anti-patterns that are commonplace, and good patterns for development of SQL databases and SSIS packages that minimize coupling and maximize cohesion. If you identify and eliminate the anti-patterns in your environment, and implement the good patterns, then you will untangle the fragile mess and have better stability and code quality in your ETL development.
Mike Diehl is the Practice Lead for Databases and Business Intelligence at Imaginet Resources, a Microsoft partner with offices in Dallas, Calgary, and Winnipeg. Mike has over 20 years of experience using Microsoft database technologies and is also an expert in Agile Analytics, Scrum, Kanban, and Microsoft Team Foundation Server.