Blog Post

SQL Saturday Madison Preconference Sessions

,

sql saturday 287 madisonThe next location for my ‘Virtualization for SQL Server DBAs’ SQL Saturday preconference training session is Friday, March 28th, in Madison, Wisconsin. If you are a SQL Server DBA or infrastructure administrator and wish to know how to properly and efficiently manage your mission-critical SQL Servers when virtualized, or want to know how to squeeze the most performance from your environment, this session is for you!

VMware vExpert and SQL Server performance expert David Klee leads this full-day, hands-on introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those new to virtualization and/or infrastructure concepts to become familiar with the concept and purposes of virtualization and how it can benefit them as data professionals. Participants will gain exposure to all layers of virtualization underneath SQL Server, from storage to hypervisor to the SQL Server instance, and will learn how to construct the entire stack with the focus on SQL Server performance.

Upon completion of this course, attendees will be able to:

  • Understand key virtualization and cloud concepts
  • Determine the optimal infrastructure configuration for best performance
  • Construct a SQL Server virtual machine template with best practices for agility and performance
  • Understand how and what stack metrics to benchmark and baseline to ensure proper objective performance measurement
  • Identify and remediate common virtualized SQL Server performance killers
  • Understand proper virtualized capacity management techniques for long term management

Attendees with the following experiences will benefit the most from this course:

  • Basic familiarity with the core components of a server
  • SQL Server installation and configuration
  • Exposure to SQL Server performance metric measurement and identification

A working set of the screens and configuration settings referenced in the session, together with the reference slides and documentation, will be provided to attendees, for prospective reference in working with virtualized SQL Server in their own environments.

For more details and to register for this session, please visit the SQL Saturday Madison home page!

Two other great preconference sessions are also being held on the same day!

Jes Borland (blog | twitter) and Ted Kruger (blog | twitter) are holding a session called “Make Me a Tuning Believer”.

Are you an accidental DBA or developer that has been told to make a T-SQL query run faster? How many times have you heard complaints from the business about a report taking 5 minutes, 10 minutes, or longer to run? Have you found yourself lost in the mix of execution plan operations and indexing and scans?

Come to this class to build your query and execution plan tuning skills from beginning to end. We’ll focus on the everyday DBA’s and developer’s needs for tuning, and build up to more advanced methods which can be taken directly to work and bring immediate improvements in performance.

The workshop will show you skills and tools that revolve around what you will see most commonly in any business, such as:

  • The life cycle of a transaction
  • Preventing bad T-SQL coding practices
  • Reading an Execution Plan
  • Plan Cache and Monitoring
  • Execution Plan Tuning
  • Capturing bad execution plans that need to be tuned

You’ll also have plenty of time to ask your questions and get answers!

Dan English (blog | twitter) is also holding a fantastic session called “Self Service BI to the Max”.

Having the freedom and ability to easily explore and provide reporting and valuable insights within an organization has been a challenge for years. Well no more! The time to unlock and open up the doors to information is now. In this all-day pre-conference you will see that with the use of Excel you can be empowered to easily load and relate data, build business logic and calculations, enrich data with additional sources, and build highly visual and compelling reports.

We will explore Excel, Power Query, Power Pivot, Power View, and Power Maps and show you how you can maximize the investment in the tools that Microsoft has provided. By the end of the day you will see how you will no longer be held back to waiting for a report request or being able to not ask the questions you have wanted to, take the next step and see what powers await you with Excel and unleash your data!

 

I want to go to both of these precons but will be busy with my own. I hope you can attend one of these sessions. These are world class training sessions at an incredible price. Even if you cannot lend your Friday for a precon, do not miss the free SQL Saturday event! Register for it here, and I cannot wait to see you there!

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating