A Series of Unfortunate [Database] Events: Common SQL Anti-Patterns

A session at Boise Code Camp 2016

Saturday 19th March, 2016

11:10am to 12:25pm (MST)

Session Level: 200

Many good programming practices don't work so well when applied to the database. The persistence layer is a very different animal with different capabilities and limitations. Without a good understanding of those differences, we can generate some rather unfortunate events.

Although they may not be quite as tragic as what the Baudelaire children endured in Lemony Snicket's novels, things such as poor performance and unmaintainable code can still ruin your day. In this session, we will work through some of the most common patterns that cause database problems, and for each of them, explore best practices to use instead. This one has a happy ending!

About the speaker

This person is speaking at this event.
Tim Rogers

Database Developer at Clearwater Analytics bio from LinkedIn

I have worked with database technologies for about two dozen years, dealing with everything from FoxPro to Sybase to Oracle, and most recently Microsoft SQL Server. I have enjoyed working at Clearwater Analytics for the past 8 years where I currently function as database developer and SQL trainer. Clearwater is a fun and challenging environment where we get to push the boundaries of SQL Server on a daily basis.

I have had the privilege of presenting at Boise Code Camp in 2014 ("'New' Features in SQL Server 2008 and 2012") and in 2015 ("A Tale of Two CTEs: A Dickens of a Query").

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 11:10am12:25pm MST

Date Sat 19th March 2016

Short URL


View the schedule


See something wrong?

Report an issue with this session