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,

June

23

STLSSUG June 23, 2015 Meeting

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

Supplementary Materials

The following event attachments are available to you:

St. Louis SQL Server User Group Meeting
June 23rd 1:00 pm- 4:00 pm cst
Vendor Presentation 4:15 pm- 5:00 pm
 
The next St. Louis SQL Server User Group meeting will be on June 23rd from 1:00 pm – 4:00 pm with a vendor presentation from 4:00-5:00pm.    Please RSVP, so that we can have a count for a lunch order,

https://www.eventbrite.com/e/stlssug-june-23-2015-meeting-tickets-17010429653


Also, please feel free to forward this meeting announcement to anyone who may be interested in attending.
 
This will also be broadcasted as a lync meeting.  Lync meeting link is listed below
 
Location: Microsoft St. Louis Office, Three City Place Drive, Suite 1100, St. Louis, MO  63141.  Parking is in the garage behind / next to the building.  There is an entrance to the building from the 2nd floor in the garage.
 
Agenda
12:30 – 1:00    Registration - Lunch Provided -  Covenant Technology Partners
http://www.covenanttechnologypartners.com/

1:00                Kevin Kline, SQL Sentry –  Ten Query Tuning Techniques Every SQL Programmer Should Know
   
2:00                Kevin Kline, SQL Sentry –  Top 10 DBA Mistakes on SQL Server

3:00                Kevin Kline, SQL Sentry –  End-to-End Troubleshooting Checklist for Microsoft SQL Server 
 
4:00                 Raffle Drawing –  Apress, Wrox, McGraw-Hill, Murach, Wiley, O'Reilly/MS Publishing Books and more!

4:15 Vendor Presentation - Kevin Kline,  SQL Sentry http://www.sqlsentry.com

Kevin Kline
Kevin is a well-known database expert and software industry veteran. A long-time Microsoft SQL Server MVP and noted leader in the IT industry, Kevin is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide, has a monthly column at DBTA magazine, and regular webcasts at SSWUG.Org. He tweets at @kekline and blogs at http://KevinEKline.com, as well as at http://ForITPros.com for issues of IT leadership. Kevin is the Director of Engineering Services at SQL Sentry, a leading vendor of database and business intelligence tools. 

Abstract: 
Title:  Ten Query Tuning Techniques Every SQL Programmer Should Know

SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all.  Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

Abstract:  
Title:  Top 10 DBA Mistakes on SQL Server

Microsoft Microsoft SQL Server is easier to administrate than any other relational database on the market.  But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since many of us fall into the role of database administrator without professional training, we end up encountering issues that others solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again?

 This session will answer questions like:

- What are some of the strengths of SQL Server then also turn out to be weaknesses?
- Why do inexperienced database administrators make their own job more difficult and less efficient? 
- What is the one thing that DBAs and Devs always clash over?
- What's the one mistake likely to get a DBA fired?

There is a short list of mistakes that, if you know of them in advance, will make your life much easier.  These mistakes are the “low hanging fruit” of application design, development, and administration.  Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.
 

Abstract:  
Title:  End-to-End Troubleshooting Checklist for Microsoft SQL Server 

Learning how to detect, diagnose and resolve performance problems in SQL Server is tough.  Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.  

In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:

• XEvents, Profiler/Traces, and PerfMon 
• Using Dynamic Management Views (DMVs)
• Advanced Diagnostics Using Wait Stats
• Reading SQL Server execution plan 


Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.Learning how to detect, diagnose and resolve performance problems in SQL Server is tough.  Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. 

 

 Join Lync Meeting     
https://join.microsoft.com/meet/ehendrix/VN8FCP1Q
 
Join by phone
+13149941870 (USA, Saint Louis)          English (United States) 
Find a local number 
Conference ID: 41053818
Forgot your dial-in PIN? |Help     
 
NOTICE
Microsoft Lync Meeting can be used to record meetings. 
By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.

 

PASSChapterLogo.jpg

sql_micro_sm.gif

sql_ca_sm.gif

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