Rotating Header Image

EDMPASS Presents: The Jubilee Jitterbug in July with Jen McCown Jackpot

On July 27th 2011 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

Date:  July 27th 2011
Time: 5:45 pm – 7:00 pm
Location: Virtual – Live Meeting
Speaker: Jen McCown
Topic: Unraveling Tangled Code – A Spellbinding Tale of Victory Over Chaos

You will need the Attendee URL:*Ms

 Meeting ID:  PW3NMB
Attendee Entry Code:  J=?b88*Ms

Session Abstract:

Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will vanquish major issues like data abuse and index negligence. We will restructure joins, tame subqueries, and refactor dynamic SQL. We will emerge victorious!

Presenter Information:  Jen McCown (@MidnightDBA)
Jen McCown, MVP, is a SQL Server developer and DBA, currently serving as the lead DBA at a state trade association in Texas. She is Senior Editor at, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. She also writes for Petri IT Knowledgebase and is a forum moderator. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. She has presented at multiple SQL Saturday and 24 Hours of PASS events, PASS Summit 2010, and PASS SQLRally 2011.

5:45 pm – Feature Presentation
7:00 pm – Wrap Ups

If you haven’t signed up already at please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there (virtually).

Enjoy!! (Follow me on Twitter: @ColinStasiuk)

Post to Twitter Post to Delicious Post to Digg Post to StumbleUpon

One Comment

  1. Tizen was originally expected to be a direct competitor to Android and iOS. But following several delays, Samsung launched Tizen on the Z1 as a low-cost option for emerging markets, starting with India.

Leave a Reply

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.