Events

  • Sat
    14
    Jan
    2017
    Middle Tennessee State University (MTSU), 1301 East Main Street, Murfreesboro, Nashville, Tennessee, 37132

    Having a good disaster recovery strategy is important for all DBAs. SQL Server offers several options, but how do you choose the right one to meet your business requirements? In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and High Availability Groups. Then we will talk about how to choose the best one to meet your needs.

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

  • Sat
    14
    Jan
    2017
    Middle Tennessee State University (MTSU), 1301 East Main Street, Murfreesboro, Nashville, Tennessee, 37132

    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 #581 Nashville.

  • Sat
    11
    Mar
    2017
    William Peace University, 15 E Peace Street, Raleigh, North Carolina, 27604

    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 out the other sessions at the event to see what you can learn SQLSaturday #592 Raleigh.

  • Sat
    18
    Mar
    2017
    Community College Workforce Alliance - J Sargeant Reynolds Community College, 1651 E Parham Rd, Richmond, Virginia, 23228

    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 out the other sessions at the event to see what you can learn SQLSaturday #610 Richmond.

  • Sat
    25
    Mar
    2017
    Colorado Technical University, 4435 North Chestnut Street, Colorado Springs, Colorado, 80907

    Having a good disaster recovery strategy is important for all DBAs. SQL Server offers several options, but how do you choose the right one to meet your business requirements? In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and High Availability Groups. Then we will talk about how to choose the best one to meet your needs.

    Check out the other sessions at the event to see what you can learn SQLSaturday #584 Colorado Springs.

  • Tue
    28
    Mar
    2017
    Greensboro, NC

    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.

  • Sat
    06
    May
    2017
    Loyola University, 8890 McGaw Road, Columbia, Maryland, 21045

    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 out the other sessions at the event to see what you can learn SQLSaturday #615 Baltimore.

  • Thu
    01
    Jun
    2017

    In a recent SQLSaturday conference, I walked into the speakers room and asked the question–What is the first thing you change after you install SQL Server?  It was interesting to get their take on the server setup and I think you will enjoy the conversation.  There are various answers on this one but some of the speakers have mentioned stuffs like set auto grow files, SQL Prompt, SQL parameter class and max memory among others.  I would like to thank Kevin Feasel, Jonathan Stewart, Eugene Meidinger, Raymond Kim, Tracy Boggiano, Mindy Curnutt, Thomas Grohser, and Vladimir Oselsky for their suggestions.

  • Sat
    03
    Jun
    2017
    Montgomery County Community College, 340 Dekalb Pike, Whitpain Township, PA , Philadelphia, Pennsylvania, 19422


    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 #638 Philadelphia.

  • Sat
    10
    Jun
    2017
    Nova Southeastern University, 3301 College Ave, Davie, Florida, 33314

    While sunning in the Florida sun on vacation I will be presenting on managing a lot of instances.

    When managing a single instance it can be fairly easy to keep track of the configuration of that instance, but what about when you have more than 10 instances to manage? How do know they are setup correctly?  How do you maintain the databases on each instance and their configurations? How do take care of patching? In this talk we will answer these questions and more as we discuss best practices and technologies (such as PowerShell and CMS) to help keep your instance configurations in-sync.

    Check out the other sessions at the event to see what you can learn SQLSaturday #627 South Florida.

  • Sat
    10
    Jun
    2017
    Nova Southeastern University, 3301 College Ave, Davie, Florida, 33314

    While sunning in the Florida sun on vacation I will be presenting on managing a lot of instances.

    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 #627 South Florida.

  • Sat
    24
    Jun
    2017
    UT Chattanooga EMC Building, 784 Vine Street, Chattanooga, Tennessee, 37403

    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 out the other sessions at the event to see what you can learn SQLSaturday #624 Chattanooga.

  • Wed
    28
    Jun
    2017

    One of the newer features in SQL Server is availability groups, which can help solve a number of business problems.  As administrators, availability groups introduce some complexity as we are tasked to make sure the Recovery Point Objective (RPO) and Recovery Time Objective (RTO) can be meet for these servers.  The complexity comes because we have different instances that must work together, but they don’t always see eye to eye.  In this episode, we chat with Tracy Boggiano of channeladvisor about how they go about monitoring their availability groups and the pros and cons of the out of the box tools.  Our discussion touches on process of  the availability group process and my scripts are posted at here for you look at reviewing your environments.  Hope you enjoy this discussion.

    Check the episode 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 out meetup for location and times.

  • Sat
    23
    Sep
    2017
    George Dean Johnson, Jr. College of Business and Economics, 160 East St. John Street, Spartanburg, SC

    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 new features in 2017.

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

  • Sat
    23
    Sep
    2017
    George Dean Johnson, Jr. College of Business and Economics, 160 East St. John Street, Spartanburg, South Carolina, 29306

    How do you know when your server is on fire? Without a set of known-good measurements to compare against, you don’t. This session will show you how to capture a performance baseline for a SQL Server instance and help you decide what to capture, and where to store it. Finally we will put it all together by walking through a scenario using the captured baseline data to identify a problem.

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

  • Sat
    30
    Sep
    2017
    Pittsburgh Technical College, 1111 McKee Road, Oakdale, PA, Oakdale, Pennsylvania, 15071

    How do you know when your server is on fire? Without a set of known-good measurements to compare against, you don’t. This session will show you how to capture a performance baseline for a SQL Server instance and help you decide what to capture, and where to store it. Finally we will put it all together by walking through a scenario using the captured baseline data to identify a problem.

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

  • 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. If you have any questions please go to the website to get more information.

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

  • Sat
    07
    Oct
    2017
    Seminole State College of Florida, 100 Weldon Blvd Building UP, Sanford, Florida, 32773

    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.

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

  • Sat
    07
    Oct
    2017
    Seminole State College of Florida, 100 Weldon Blvd Building UP, Sanford, Florida, 32773

    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 new features in 2017.

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

  • Sat
    14
    Oct
    2017
    Central Piedmont Community College (CPCC), 2800 Campus Ridge Road, Charlotte, North Carolina, 28105


    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 #683 Charlotte.

  • Thu
    02
    Nov
    2017
    16:45Washington State Convention Center, Seattle, WA

    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.

    Check out the conference at http://www.pass.org/summit/2017/Home.aspx.

     

  • Wed
    08
    Nov
    2017
    http://dba.pass.org/

    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 new features in 2017.

  • Thu
    09
    Nov
    2017
    06:305404 Wisconsin Ave # 700, Chevy Chase, MD 20815

    An important part of being a proactive DBA is knowing how your system is performing at all times so that you can quickly and easily diagnose problems when they occur. In this session, I will review why it is important to have a standard set of metrics to examine when performance goes awry. I will present an open source solution for collecting SQL server performance metrics that works on both Linux and Windows. Finally, we will walk through a real-world example of how this solution was used to correctly identify and resolve a production issue.