Code Smells

Teams Meeting: Link
Abstract
Code Smells - How to Keep Your Code From Stinking!
Maybe you’ve had some experience writing SQL, but no one’s ever told you what not to do. Or maybe you’re aware of some bad habits to avoid when writing SQL, but no one has ever shown you why a bad practice can hurt your query – or SQL Server. Perhaps you feel a little more confident with your TSQL, but don’t understand why your queries aren’t running as quickly as you would like.
Bad SQL coding practices are known in the SQL community as “code smells”. We will work with me through five common coding mistakes that can make performance stink. By the time we’re done, you’ll have a better idea of how to freshen up some problem queries.

Speaker: Pamela Mooney is the Data Services Manager with NISA Investment Advisors, LLC.
The road to IT was a long and winding one for me, but I fell in love with SQL Server and knew that I wanted to be a DBA after my first database class in college. I was fortunate enough to be hired in as a Junior DBA straight out of school, and I have never looked back. I now lead a team of DBAs, and it is a pleasure to work with them, and to learn with (and from!) them. A one-time, part-time professional musician and songwriter, I have a medical background and am a passionate history nerd. In my spare time, I like to hike, bike, read, write, and talk to you.