Next Meeting: Wed, Sep 24 2014
Twice in a Lifetime: T-SQL Refactoring 101
Mike Donnelly, Consultant Digineer
Whether it’s because you inherited the code from the “last guy,” or your stored procedures haven’t been looked at since the database was created in 2001, there will come a time when you need to rewrite old code. When you start this project you may ask yourself, how did I get here? And you may ask yourself, how do I work this? This is not my beautiful database. This is not my beautiful T-SQL. Letting the data go by, information flowing to the end users is the goal. Refactoring old code can be tedious, but necessary. Sometimes it isn’t just about identifying the worst queries in your application, but figuring out how to rewrite everything to introduce the best practices that the last guy didn't know about five years ago.
This session will cover ways to quickly find old T-SQL antipatterns, tools that can help make things easier to update code, and deprecated features that can’t be used in modern versions of SQL Server. Don't leave your old T-SQL the same as it ever was.
Mike works for Digineer as a SQL Server Consultant in the Twin Cities. He has been working with SQL Server for 13 years, holds the MCSE: Data Platform certification and currently serves as the chapter leader for PASSMN. He is an avid runner, blogger, and a wannabe gourmet chef.
5:30 PM - 6:00 PM: General Announcements
6:00 PM - 6:30 PM: Dinner & networking
6:30 PM - 7:45 PM: Main Presentation
7:45 PM - 8:00 PM: Closing comments & wrap-up
Event Time : Wed, Sep 24 2014 17:30 - 20:00 Central Daylight Time
Add the meeting to your calendar: iCal
2310 Crossroads Dr Madison, Wisconsin
It's the building with the Cisco sign facing the interstate near East Towne Mall. Park behind the building and walk in main entrance. Our room will be straight ahead on the first floor. Get a Bing map to the meeting location.
If you are having trouble joining the meeting, try adding ?sl=1 to the URL to use the Lync web client.
Need Lync? (64-bit) (32-bit)Other Downloads