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!




Speaking at PASS Summit 2018

I am honored to have been selected to present a half-day session at the PASS Summit 2018 in Seattle, WA. My session is Migrating to SQL Server 2017, and here is the abstract:

Migrating to SQL Server 2017

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.

This is a topic that I have presented and taught multiple times, and it is something I am quite passionate about. I think it is also increasingly relevant as SQL Server 2014 will be falling out of Mainstream support on July 9, 2019, and both SQL Server 2008 and SQL Server 2008 R2 will be falling out of Extended Support on July 9, 2019. Next July is sort of a looming deadline for many organizations!

I am also going to be doing a preview version of this session in the first slot of the next 24 Hours of PASS Summit Preview event on June 12th, 2018.

Hopefully I will see you at both events!




PASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality

PASS has publicly announced their Pre-conference Sessions for the PASS Summit 2018 in Seattle, WA. There are seven sessions on Monday, November 5, 2018, and nine sessions on Tuesday, November 6, 2018. There are good sessions on both days, from many well-known speakers.

In my honest opinion, the most valuable session for most database professionals who care about query performance is Kimberly Tripp’s Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality on Tuesday. Kimberly is the world-class master on this subject, as evidenced by her many blog posts, presentations, and Pluralsight courses.

Kimberly is a very talented and passionate presenter and teacher. Long before I worked for SQLskills (way back in 2006 when I was working at NewsGator), I had the chance to take the week-long predecessor class to the current IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1. That class was a life-changer for me, and it had a huge effect on my career.

Since then, I have seen how Kimberly presents and teaches many times over the years. I have learned so much from both her content and from her presentation and teaching style by watching her. Unlike some well-known presenters, she doesn’t use cute pictures or silly marketing gimmicks in her presentation content. She is not there to just “put on a show” for entertainment purposes.

She prepares very detailed, content-dense slides that are a very useful resource to keep and review long after the session is over. She also has the depth of knowledge and experience to actually improvise and modify her demonstrations in response to questions during a session. As any experienced presenter knows, that is a pretty big deal.

She actually understands what she is teaching at a very deep level, and she has the many years of teaching experience to explain it clearly to people with any level of experience. Despite the lack of cute pictures or costumes, she does her presentations in a very engaging manner because of her real passion for the subject.

Here are her relevant Pluralsight courses that I would recommend watching to prepare for this pre-conference session:

SQL Server: Optimizing Stored Procedure Performance

SQL Server: Optimizing Stored Procedure Performance – Part 2

SQL Server: Optimizing Ad Hoc Statement Performance

SQL Server: Indexing for Performance

SQL Server: Why Physical Database Design Matters

BTW, Kimberly did not put me up to writing this post. In fact, she might be a little embarrassed by all of this praise. She might even mock fire me on Twitter once she sees it. I just felt I needed to spread the word about this pre-conference session.