Mission Critical SQL Server
27th March 2017 - 30th March 2017
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 2016) as well as multiple versions of Windows (including Windows Server 2012 R2 and 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 Always On 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: Always On Availability Groups
Introduced in SQL Server 2012, the Always On 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.
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 December 31 2016) £1599 (from January 1 2017) +VAT
Aldersgate House, 135-137 Aldersgate Street, EC1A 4JA
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.
Chris Webb's Introduction to MDX course was well-run, informative and good value. It gave me a good understanding of the key principles and ideas and how to apply them to real world situations. It was great environment to learn in, with Chris giving excellent practical exercises and having the depth of knowledge to answer to any group questions.