*****UPDATE*************

The location has changed to the Cerner headquarters for this month and possibly ongoing for the evening meetings.  This facility is only about 3 miles West of Riverport off of 210.  The new address is: 

2702 Rockcreek Parkway
Kansas City, MO  64117

The exterior doors will be locked, but the room we're in (Cowboy) is on the first floor just to the right of the front door.  If someone is not waiting at the door to let you in, you should be able to easily flag someone down in the room to open it for you.  If you can't find the building or can't get in for some reason, please give me a call.  816-607-1337

****************************

The meeting tomorrow evening (February 19th) is sponsored by Cerner  

We're trying something a little different will be having SQL Server MVP, Glenn Berry, present for the group remotely to Cerner

Please RSVP for free here (please be sure to register if you're reasonably sure you can make it, as we use this list for food and door prizes):   http://kcssug.eventbrite.com

Presenter: Glenn is a Microsoft SQL Server MVP. He has worked as a SQL Server professional for many years in a variety of roles, including stints with NewsGator and Avalara. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.

Topic: Dr. DMV's Troubleshooting Toolkit

Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains numerous DMV queries that you can quickly and easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.

Please note, this will be an evening meeting at the Cerner Riverport Campus, drinks and food will be available.

We look forward to seeing you all soon!

Location:

UPCOMING EVENTS

March 19th - User Group Meeting

Presenter: Tristan Wilson

Using SQLIO to Test Your Disk Subsystem

Disk performance is a key metric in Sql Server performance. Is your storage performing its best? How do you know? This session will review different methodologies for testing your disk subsystem. We'll use Microsoft's SQLIO tool to determine the I/O capacity of a given configuration. By understanding the maximum capabilities of your disks, you'll better understand the performance capacity of your storage subsystem. 

April 16th  - User Group Meeting

Presenter and Sponsor: Paul Randal from SQL Skills

Performance Troubleshooting Using Wait Statistics

One of the first things you should check when investigating performance issues are wait statistics - as these can often point you in the direction for further analysis. Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem - what is often called 'knee-jerk performance tuning'. In this session, you will learn what waits are, how to analyze them, and potential solutions to common problem patterns.

April 21st - 22nd -     PASS Business Analytic Conference, Santa Clara CA

If you are planning to attend the PASS BAC conference this year, use the following code for a $300 discount on advance pricing.

BFFBG

Lastly, congratulations to Nathan Heaivilin on winning the Jambox from the meeting last month, We're working on getting the site moved to a new easier to use template and will have the slides from last month and this available there as soon as we do.  I'll will keep you all posted here when we do.

KC SQL Server User Group web site: http://kansascity.sqlpass.org/