St. Louis SQL Server User Group

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

Join Our Group Online!
http://groups.yahoo.com/group/stlssug

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

 

EventDisplay

Next Meeting

Tuesday,

March

10

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, 
https://www.eventbrite.com/e/stlssug-march-10th-meeting-tickets-94935551791 

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

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 

Abstracts

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.
 

PASSChapterLogo.jpg

sql_micro_sm.gif

sql_ca_sm.gif

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids