Speaking at SQLSaturday Denver on October 12, 2019

I’ll be presenting Dr. DMV’s Troubleshooting Toolkit at SQLSaturday Denver on October 12, 2019. This free event will be held at University of Denver – Sturm Hall, 2040 S Race St, Denver, Colorado, 80210. My session is at 10:15AM.

I always enjoy presenting at SQLSaturday events, and meeting new people, many of which have never been to a SQLSaturday event before.

Here is the abstract of the session:

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 a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases. This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance, and databases in order to avoid performance and scalability issues.

In plain terms, I’ll be going through my SQL Server 2019 Diagnostic Information Queries, explaining what they mean, and how to interpret the results. This is always a lot of fun, and people seem to enjoy it. I hope I see you there!

Fix It

SQLSaturday Oregon

I will be delivering a full day pre-con session called Migrating to SQL Server 2017 on November 2, 2018 in Portland, OR. Here is the abstract:

How do you design and implement a safe and successful migration from an older version of SQL Server to SQL Server 2017 with no data loss and virtually no downtime? What if you have a limited hardware budget for the upgrade effort and you are worried about the core-based licensing in SQL Server 2017? How can you choose your hardware wisely in light of the new licensing model? How can you convince your organization that the time is right to upgrade to SQL Server 2017? This session will cover several different methods for migrating your data to SQL Server 2017 while meeting these objectives and minimizing your hardware and licensing costs.

The early-bird price for this is $149.00 until October 21, 2018. You can register for this session here.

I will also be presenting High Availability/Disaster Recovery 101 at the actual SQLSaturday Oregon event on November 3, 2018. Here is the abstract:

How do you design a SQL Server 2017 infrastructure in order to meet specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels? There are many aspects to consider, from technology choices and licensing, to policies and procedures. This session outlines and compares the various HA/DR technologies available in SQL Server 2017, showing how you can combine them to design and build a solution to help meet your HA/DR goals. This session also teaches you how to formulate policies that enable effective use of technology in your organization.

You can register for SQLSaturday Oregon here.

SQLSaturday #808 - Oregon 2018

SQLSaturday Oregon is one of the larger SQLSaturday events in the United States, and they have a great roster of speakers this year. Portland is a fun city with a lot of good breweries and tap rooms

I hope to see you there!

Analyzing I/O Performance from SQLSaturday #300

I had the opportunity to present Analyzing I/O Performance at SQLSaturday #300 in Kansas City, MO on September 13, 2014. I think the session went well, judging by the amount and type of questions that I got during and after the presentation, along with the written feedback forms that I read afterwards.

The overall event was well-run, and well-attended, with some good barbeque for lunch. I have a lot of respect for the organizers and volunteers for SQLSaturday events.

You can get a PDF version of my deck here, and the queries that I ran here.

One side benefit of this event was a chance to drive my red Tesla back and forth between Parker, CO and Kansas City, MO, using the free Tesla Supercharger network (and a 50 amp circuit at my sister’s house in Topeka, KS). I talk a little about this trip in these two blog posts:

Tesla Road Trip to SQLSaturday #300 in Kansas City

Tesla Model S Road Trip Results