This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here                     

Mission Critical SQL Server

28th September 2015 - 1st October 2015

Who is it for?

This course is aimed at SQL Server professionals and IT admins. Before attending this class, participants should have:

  • A good understanding and practical experience of SQL Server administration
  • An understanding of basic IT fundamentals

What you will learn

Covering multiple versions of SQL Server (2008 through 2014, along with available information about 2016) as well as multiple versions of Windows (including Windows Server 2012 R2 and the latest on 2016), this workshop will provide you with holistic and practical approaches to deploying highly available, reliable, and performing SQL Server implementations based on real world experience whether they are on physical servers, virtual machines on a hypervisor, in the public cloud, or a mixture in a hybrid configuration.  

Features such as AlwaysOn Availability Groups, true multi-site failover clustering instances, and support for Windows Server Core will all be covered. Whether you have older SQL Server and Windows deployments and are looking to brush up your skills, considering an upgrade to a newer version of SQL Server or Windows, or looking to implement a new solution that is mission critical, this workshop will teach you what you need to know to be successful through instructional content, demos, and hands on labs.  

The course outline, in detail, is as follows:     

Module 1: Mission Critical Basics  

Ensuring that your SQL Server instances and databases are reliable, available, and highly performing takes much more than just technology or a single feature in SQL Server. Your overall strategy should encompass people and processes, both of which will be covered in this module that sets the foundation for the entire workshop.    

Module 2: Windows Deployment for SQL Server  

One of the challenges that many DBAs face is ensuring that the underlying Windows Server builds are done correctly. Topics such as deploying SQL Server on Windows Server Core will be covered, as well as the Windows portion of failover clustering from a SQL Server perspective. Considerations for clustered solutions, standalone servers, physical, virtual, and the cloud will all be discussed.  

Module 3: SQL Server Failover Clustering Instances  

Besides understanding the Windows portion of clustering which is covered in the previous module, it is essential to know the SQL Server side as well. Learn how to plan, deploy, administer, and troubleshoot clustered instances and deployments of SQL Server, including multi-site FCIs.   

Module 4: AlwaysOn Availability Groups  

Introduced in SQL Server 2012, the AlwaysOn availability groups feature not only provides a way to make databases highly available, but you may be able to take advantage of some of its benefits such as read-only replicas for reporting. Deploying availability groups is deceptively simple, and this module will show you how to plan, implement, and administer availability groups, including multi-site architectures.    

Module 5: Quorum

Quorum is an essential topic for any clustered deployment of SQL Server. Without it, an AG or FCI will be down. This module will focus on not only understanding quorum, but how to architect it keep the underlying WSFC up and running.  

Module 6: Troubleshooting

Deploying FCIs and AGs is one thing. When something goes wrong, you need to be able to find out what happened. This module will show you methodologies and tools for troubleshooting issues in clustered environments.   

Module 7: Patch Management

Patching is arguably the biggest cause of downtime in most environments. This module will discuss how to approach patching in both Windows and SQL Server to ensure that your outages are minimized.  

Module 8: Solution Design  

It isn’t enough to only understand the technologies individually, or what you need to do such as making backups. You need to bring all of the requirements–both technical and non-technical, platform and administration–together and design the right solution for your deployment. You will learn how to approach this challenge and balance the different requirements and factors to produce an actionable plan, not just something that will live in a document or look good as a diagram in Visio.  

Hands-on Labs  

An important aspect of this four-day class is acquiring more than instruction: you will also get the hands on experience. For example, you will be building Windows Server failover clusters and deploying, administering, and maintaining both clustered instances of SQL Server as well as availability groups. The workshop is designed to recognize that students may be at different levels, so there are three different difficulties for selected labs: beginner, intermediate, and advanced. This will offer a challenging and rewarding hands-on encounter no matter if you are relatively new to SQL Server or someone who has been using it for years.

Cost: £1499 (to May 31 2015) 1599 (from June 1 2015) +VAT


Allan Hirt is a Cluster MVP who has been working with SQL Server since 1992.
Besides traveling the world to train and mentor, Allan also works with clients designing and implementing mission critical SQL Server solutions. While a good portion of time is focused on high availability and disaster recovery related topics, he also does quite a bit of work in most of the IT-related infrastructure topics for SQL Server such as consolidation, virtualization, disk configuration, administration, operations, and more.
Over the years, Allan has published numerous whitepapers, articles, and books on mission critical topics. He often presents at events such as PASS Summit, SQLBits, and TechEd North America. His last book was Pro SQL Server 2008 Failover Clustering (Apress, 2009), and its sequel, Mission Critical SQL Server, is due out in 2013.



MSE Meeting Rooms
103a Oxford Street

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

decoration decoration decoration decoration