http://www.sqlservercentral.com/blogs/sql_awesomesauce/2011/09/19/presenting-_1C20_tangled-code_1D20_-at-charleston-ug-tuesday-9_2F00_20/

Printed 2014/09/20 04:22AM

Presenting “Tangled Code” at Charleston UG Tuesday 9/20

By Jen McCown, 2011/09/19

On Tuesday, September 20 at 5p CST (6pm Charleston time), I will present “Unraveling Tangled Code” via LiveMeeting at the brand-spanking-new Charleston SC User Group!

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!

Join us for the meeting:

URL: https://www.livemeeting.com/cc/mvp/join
Meeting ID: K57954
Entry Code: rk-+*T9Sz

 

Happy Days,
Jen McCown
www.MidnightDBA.com/Jen


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.