Winnipeg SQL Server User Group

Event Detail

Meeting Date: Mon, Apr 27 2015

Winnipeg SQL UG - April 2015

Language: English
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
Winnipeg, Manitoba
Direction: None

Featured Presentation

Untangling the spaghetti: Patterns and Anti-Patterns in SQL and ETL development

Speaker: Mike Diehl, Practice Lead Databases and Business Intelligence Imaginet

Summary: 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.

About Mike: 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 an expert in Agile Analytics, Scrum, Kanban, and Microsoft Team Foundation Server.


Past Events

Meeting Archive





Back to Top