Mission Critical SQL Server
3rd February 2014 - 6th February 2014
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 2012) as well as multiple versions of Windows (including Windows Server 2012), this workshop will provide you with holistic and practical approaches to deploying highly available SQL Server implementations based on real world experience.
The latest features introduced in SQL Server 2012 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.
NOTE: As of the writing of this class description, Windows Server 2012 R2 is not released to the public and SQL Server 2014 has no release date. Should those releases become available before the start of the class, information about them will most likely be incorporated as well if applicable.
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 builds are done correctly whether they are using Windows Server 2008 R2, 2012, or something else. Topics such as deploying SQL Server 2012 on Windows Server Core will be covered, as well as the Windows portion of failover clustering from a SQL Server perspective.
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 clusters using SQL Server 2012
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: The Rest of the SQL Server Story
Whether it is looking at older, legacy features such as log shipping, replication, or database mirroring, looking at options like virtualization, or performing proactive administration to ensure reliability, health, and ultimately uptime, there is more to the availability story of SQL Server than the two marquee features of FCIs and AGs. This module will cover what you need to think about and possibly implement, including solid backup and restore and patching strategies, to ensure that you are positioned to have the availability your business requires.
Module 6: 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 November 30 2013) £1599 (from December 1 2013) +VAT
116-120 Goswell Road
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.