Submitted by Michal Poreba
Code quality matters!
You probably have worked with SQL queries before. What was the experience like? Have you ever looked at a piece of SQL and thought... G! that's ugly! Have you seen a query that worked just fine in development but annoyingly not in production, or it used to work for a while, but then started timing out without any change or a warning?
This session is for you! Let's take a hard look at code quality on an example from a language nobody loves, the T-SQL. I will show you some ugly queries and teach you how to transform them into good, clean code, that not only looks right but also performs well.
He lives in Wales where he currently works as a Senior SQL Server DBA at Vizolution in Swansea. In his free time, he speaks obscure languages, plays music with code or dives in local caves trying to find places no human has ever been to before. An intermittent blogger at https://dbain.wales, and a once-in-a-while contributor to a few OSS projects.