PASS Summit 2018

I will be presenting Migrating to SQL Server 2017 at the PASS Summit 2018 in Seattle, WA. I’m actually presenting a half-day session on Friday, November 9, 2018 in Room 6E. 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.

I will also be covering some SQL Server 2019 considerations in this session.

This is a fun session that I really enjoy presenting. I think this subject is especially relevant with the upcoming end of extended support of SQL Server 2008/SQL Server 2008 R2 and end of mainstream support for SQL Server 2014, which both happen on July 9, 2019.

I honestly believe that CY 2019 is going to be an ideal time for many organizations to migrate from legacy versions of SQL Server (SQL Server 2014 and older) to a modern version of SQL Server (SQL Server 2016 and newer).

This is because you will have the opportunity to upgrade your entire data platform stack with significant new releases, including new processor families from Intel and AMD, wider availability of Intel Optane DC Persistent Memory, a new server operating system release (Windows Server 2019), and a new SQL Server release (SQL Server 2019).

BTW, if you are going to a Tuesday pre-con session at PASS, you should strongly consider Kimberly’s Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality. I have more information about why this session will be a great choice here.

You can register for the PASS Summit 2018 here.

clip_image002        clip_image002



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!




Presenting Two Sessions at the PASS Summit 2017 in Seattle

I’ll be presenting two sessions at the PASS Summit 2017 in Seattle, WA. There will be a half-day session called Migrating to SQL Server 2017 on Wednesday, November 1 in Room 6A, starting at 3:15PM, and then a regular session called Improving SQL Server Performance on Thursday, November 2 in Room 612, starting at 4:45PM.

Here are the abstracts:

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. You will also learn how to help make the case that a complete data platform upgrade makes excellent sense from a business perspective. You will also learn how to do effective capacity planning for the new environment to ensure that you have the best performance possible with a manageable SQL Server 2017 licensing cost.

 

Improving SQL Server Performance

Has anyone ever told you that your SQL Server database or instance was running too fast? Probably not, but it is all too common to hear complaints about poor performance. As a database professional, you need to have the right tools and techniques for finding and correcting performance bottlenecks at all layers of your SQL Server instance. Starting with your hardware and storage, including virtualization, operating system considerations, instance-level configuration settings, database properties, and concluding with index and query tuning, we will cover all of the layers of common performance bottlenecks. You will learn detailed and practical information for improving SQL Server performance at every layer in the system.

 

My SQLskills colleague, Erin Stellato will also be at the PASS Summit 2017, presenting a pre-conference session called Solving Common Performance Problems Using Query Store on Monday, October 30, and then two regular sessions: Query Store and Automatic Tuning in SQL Server and Data Systems at Scale – A Panel Discussion on November 1 and November 2, respectively.

 

The PASS Summit is always a fun and useful conference, where you can connect and reconnect to people in the SQL Server Community. I hope to see you there, in my sessions and in the hallways and escalators!

Update: Just to make it easier to find, here are links to my Migrating to SQL Server 2017 session, Migrating to SQL Server 2017 demos, Improving SQL Server Performance session, and Improving SQL Server Performance demos.