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.