Rotating Header Image

EDMPASS July 2011 – LiveMeeting Presentation Recording

On July 27th EDMPASS was lucky enough to have Jen McCown (@MidnightDBA) as a guest (virtual) speaker.

Here is the session abstract: Unraveling Tangled Code – A Spellbinding Tale of Victory Over Chaos

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!

If you were unable to attend the Live Meeting session here is a recording of the presentation.

Big thanks to Jen for doing this for us and if you are a SQL Server presenter and have interest in doing a Live Meeting session for EDMPASS please feel free to contact me.

If you’d like to chat with me about this or anything else (SQL or other) please leave a comment or hit me up on my Twitter: @ColinStasiuk

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

Leave a Reply

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