Events

  • Wed
    28
    Jun
    2017

    Join me as I discuss Monitoring Availability Groups on the SQL Data Partners Podcast.  Find out who data synchronization works, what SLA, RPO, RTO are and how they effect your monitoring.  And discover different ways to monitor your availability groups. And more importantly find out what superhero power I want to have.

    Check out all the episodes at SQL Data Partners.

  • Sat
    15
    Jul
    2017
    Gwinnett Technical College, 5150 Sugarloaf Parkway Bldg 900 Bldg, Atlanta, Georgia, 30043

    How do you know when your server is on fire?  Without a set known-good measurements to compare against to look at you don’t.  This session will show you how to capture a performance baseline for a SQL Server instance. The session will help you decide what and when to capture data and where to store it. Then we will walk through different tools and scripts to use.  Then walk you through a scenario of using that data to identify a problem.

    Check out the other sessions at the event to see what you can learn SQLSaturday #652 Atlanta.

  • Sat
    22
    Jul
    2017
    Otterbein University Campus Center, 100 W Home St, Columbus, Ohio, 43081

    How do you know when your server is on fire? Without a set known-good measurements to compare against to look at you don’t. This session will show you how to capture a performance baseline for a SQL Server instance. The session will help you decide what and when to capture data and where to store it. Then we will walk through different tools and scripts to use. Then walk you through a scenario of using that data to identify a problem.

    Check out the other sessions at the event to see what you can learn SQLSaturday #653 Columbus.

  • Sat
    05
    Aug
    2017
    Wesleyan University, 1500 Alliant Avenue , Louisville, Kentucky, 40299

    Family vacation time in Louisville.  See family and learn some SQL.

    This session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems as well as some of the new DMVs you can use to find issues as they arise.

    Check out the other sessions at the event to see what you can learn SQLSaturday #643 Louisville.

  • Sat
    12
    Aug
    2017
    Ivy Tech Noblesville, 300 N 17th St, Noblesville, Indiana, 46060

    This time getting to present in my home state of Indiana.  Go Hoosiers!

    This session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems as well as some of the new DMVs you can use to find issues as they arise.

    Check out the other sessions at the event to see what you can learn SQLSaturday #629 Indianapolis.

  • Wed
    23
    Aug
    2017

    When managing a single server it is easy to keep track of the configuration of that server, but what about when you have more than ten servers to manage or a hundred? How do you know they are setup correctly?  How do you maintain the databases on each server? How do you take care of patching? How do you know when your server is on fire?

    In this talk we will answer these questions and more as we discuss technologies and approaches you can use to make sure your environment is configured and performing at its best.

  • Fri
    01
    Sep
    2017

    Target Audience:

    DBAs that have implemented AGs and need to know different ways to monitor them or what to monitor.

    Abstract:

    Once you have successfully configured Availability Groups, what comes next? In this session, we will go beyond setup and look at how to monitor your Availability Groups.  We will define and cover important metrics and alerts you need to manage a database in an Availability Group.

    You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.

    Why I Want to Present This Session:

    I really like HA/DR technologies.

    Check out the other sessions at:

    https://groupby.org/2017/06/groupby-september-2017-lineup-announced-registration-open/

  • Tue
    19
    Sep
    2017
    TekSystems, 5440 Wade Park Boulevard, Suite 300, Raleigh, NC

    So you have successfully configured Availability Groups, now what? In this session we will look beyond setup and look at how to monitor your Availability Groups.  We will discuss what metrics to look at, what they mean, and what you need to alert on.  You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.  This session is for anyone that uses, or plans to use Availability Groups. You should come in with a basic understanding of Availability Groups to get the most out of this session.

    Check into meetup for location and times.

  • Wed
    04
    Oct
    2017
    Thu
    05
    Oct
    2017
    Norfolk, VA

    Database administration is a fundamental responsibility but we are often reactive to a ticket, an email or conversation about something that happened after the fact. But without a set known-good measurements to compare against how do you know what to look at? This session will show you how to capture a performance baseline for a SQL Server instance. The session will help you decide what and when to capture data and where to store it. Then we will walk through different tools and scripts to use.

    What I will leave with: Understanding of methods and tools to capture performance and identify issues.  You will be able to start collecting performance information and be more knowledgeable about your environment.

    The conference is a one track conference where the speakers will attend the sessions with the attendees to provide interaction with the attendees.  This is going to a fun event where you will make lots of friends and have access to the speakers so come out and join us on the SQL Trail. The cost is currently $400 and will increase to $500 after June 16th.  If you have any questions please go to the website to get more information.

    Check at the two day conference at http://companeroconference.com/.

  • Thu
    09
    Nov
    2017
    5404 Wisconsin Ave # 700, Chevy Chase, MD 20815