Teaching Old Dogs New Tricks
ABSTRACT
Data assets at organizations tend to stick around for a while--many of the databases we work with are old enough to vote. These databases tend to be full of code and patterns which made sense in SQL Server 2005 but are not the best approach today. In this session, we will walk through what has changed in the T-SQL landscape over the past several versions of SQL Server, providing practical tips on how to improve an existing code base without installing new SQL Server components. Just because that database is old doesn't mean it has to look that way.ADDITIONAL MEDIA
I presented this for the Triangle Area SQL Server Users Group on August 13, 2024.SLIDES
Click here to access the slides for this presentation.
The slides are licensed under Creative Commons Attribution-ShareAlike.
DEMO CODE
Click here to access demo code for this presentation.
The source code is licensed under the terms offered by the GPL.