I will be the inaugural speaker for the Northern Colorado Database Professionals on September 17, in Loveland, CO. I will be presenting a preview version of my PASS Summit 2012 session about how to migrate to SQL Server 2012. The abstract is below:
Migrating to SQL Server 2012
How do you design and implement a safe and successful migration from an older
version of SQL Server to SQL Server 2012, 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 new core-based licensing in SQL Server 2012? How can
you choose your hardware wisely in light of the new licensing model?
This session will cover several different methods for migrating your
data to SQL Server 2012 while meeting these objectives and minimizing your
hardware and licensing costs. You will also learn how to help make the case that
an upgrade makes good sense from a business perspective.
The following week, I will be at SQLSaturday #169 on September 22, in Denver, CO. I will be presenting an updated version of DMV Emergency Room!, about how to use a special set of DMV queries to help identify and troubleshoot performance issues in an emergency. The abstract is below:
If you have ever been responsible for a mission critical database, you have probably been faced with a high stress, emergency situation where a database issue is causing unacceptable application performance, resulting in angry users and hovering managers and executives. If this hasn’t happened to you yet, thank your lucky stars, but start getting prepared for your time in the hot seat. This session will show you how to use DMV queries to quickly detect and diagnose the problem, starting at the server and instance level, and then progressing down to the database and object level. Based on the initial assessment of the problem, different types of DMV queries will help you narrow down and identify the problem. This session will show you how to assemble and use an emergency DMV toolkit that you can use to save the day the next time a sick database shows up on your watch in the Database ER!
On October 13, 2012, I will be at SQLSaturday #145 in Nashville, TN. I will be presenting Hardware 301: A deeper Dive into Database Hardware. The abstract is below:
Hardware 301: Diving Deeper into Database Hardware
Making the right hardware selection decisions is extremely important for database scalability. Having properly sized and configured hardware can both increase application performance and reduce capital expenses dramatically. Unfortunately, there are so many different choices and options available when it comes to selecting hardware and storage subsystems, it is very easy to make bad choices based on outmoded conventional wisdom. This session will give you a framework for how to pick the right hardware and storage subsystem for your workload type. You will learn how to evaluate and compare key hardware components, such as processors, chipsets, and memory.
Finally, I will be speaking at the PASS Summit 2012 during the week of Nov 6-9, 2012, in Seattle, WA. The abstract for this session is shown below:
How do you design and implement a safe and successful migration from an older version of SQL Server to SQL Server 2012, 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 new core-based licensing in SQL Server 2012? How can you choose your hardware wisely in light of the new licensing model? This session will cover several different methods for migrating your data to SQL Server 2012 while meeting these objectives and minimizing your hardware and licensing costs. You will also learn how to help make the case that an upgrade makes good sense from a business perspective.
All three of these events should be a lot of fun, and I am looking forward to seeing a lot of people at the venues!
Filed under: Microsoft, SQL Server 2012, Teaching Tagged: PASS, PASS Summit, SQLSaturday #169 
