The meeting next week (February 19th) is sponsored by   SQLSkills and Cerner  
We're trying something a little different next week and will be having SQL Server MVP, Glenn Berry, present for the group remotely at 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.
Meeting Schedule for Thursday, February 19th, 2015:

  • 6:00 - 6:10 - Greeting and Housekeeping
  • 6:10 - 7:30 - Presentation
  • 7:30 - Door Prizes and wrap up
    We look forward to seeing you all soon!
    Location:

    Cerner Riverport Campus
    6177 NE Birmingham
    Kansas City, MO  64117

    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.

    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/

    0 Response to "February 19th: Kansas City SQL Server User Group Meeting - SQL MVP Glenn Berry!"

    Post a Comment

    Group Tools

    Random Prize Winner
    Use this tool to generate random numbers for prize drawings.




    Follow this twitter list of the twitter accounts for the user groups. Ask for your group to be added to this list: twitter list
    Subscribe to the Kansas City User Group Newspaper at Paper.li

    Blog Archive

    Followers