St. Louis SQL Server User Group

Welcome to the St. Louis SQL Server User Group (STLSSUG)   

Join Our Group Online!

PASS Summit 2019 Seattle, WA November 6-8
Use code LGDIS7RW6 to receive a $150 discount off your PASS Summit 2019 registration



Next Meeting




STLSSUG March 10, 2020 - Code Smells ( level 200), Drop it Like It's Hot (level 200)

  • In-Person @ 3 City Place Drive St. Louis, Missouri, United States (map)
  • 13:00 - 16:00 Central Daylight Time
  • Language: English

St. Louis SQL Server User Group Meeting
March 10th 1:00pm – 4:00 pm
The next St. Louis SQL Server User Group meeting will be on March 10th from 1:00pm – 4:00 pm

Please RSVP, so that we can have a count for a lunch order, 

Also, please feel free to forward this meeting announcement to anyone who may be interested in attending.
Location:      Daugherty Business Solutions
                    3 City Place Drive
                    11th Floor,  Multipurpose Room 2
                   St. Louis, MO 63141 
12:30 – 1:00    Registration –  Lunch provided - Daugherty Business Solutions

1:00    Pamela Mooney, NISA Investment Advisors, LLC. - Code Smells - How to Keep Your Code From Stinking! (Level 200)

2:30    Pamela Mooney, NISA Investment Advisors, LLC. – "Drop it Like It's Hot!  Safely Dropping (and Instantly Restoring) Database Objects" (Level 200)

4:00    Raffle Drawing 


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.

"Drop it Like It's Hot!  Safely Dropping (and Instantly Restoring) Database Objects"
How many times have you received a request to drop a stored procedure, view, function or (yikes) a table, only to hear the next day, "Oops!  I didn't think it was being used!  Can you put it back?" 

Sure, you have backups.  But what if there was a safer, faster way to restore objects - especially tables, with the data intact?  Let me walk you through my rename/drop process. It's fast, it's easy, and it's safe.  You'll spend a minute to set it up, under a second to run it, and the drops will take care of themselves.  And you will get on with your life.

Pamela Mooney is a Senior Analyst 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’m 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, I have a medical background and am a passionate history nerd. In my spare time, I like to hike, bike, read, go to the Ren Faire, write, and talk to you.




Back to Top