Our November meeting will again be online. NOTE: you MUST RSVP to this Meetup at https://www.meetup.com/Capital-Area-SQL-Server-User-Group/events/281817530/ to view the Zoom URL!
Our November speaker is Pamela Mooney!
Topic: 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.
Pamela Mooney is a Senior Analyst with NISA Investment Advisors, LLC. he road to IT was a long and winding one for her, but she fell in love with SQL Server and knew that she wanted to be a DBA after her first database class in college. She was fortunate enough to be hired in as a junior DBA straight out of school, and never looked back. She is now a senior DBA who loves to mentor and teach – as well as to continue to learn. A one-time, part-time professional musician and songwriter, she has a medical background and am a passionate history nerd. In my spare time, she likes to hike, bike, read, go to the Ren Faire, write, and talk to you.
Our online meeting schedule is as follows:
- 6:00: General chat, discussion, and announcements
- 6:30: Presentation
We usually wrap up between 7:30 PM and 8:00 PM.
Please RSVP to this Meetup, then use the online event URL to join (note: you MUST RSVP for the URL to be visible). We will send out a meeting password as we get closer to the event.
Thanks to our sponsor, Datto, for making this event possible!