Whether your business hours are 9 to 5 or 24x7x365, your database systems need to be up when you need them. Achieving the availability you require is more than clicking Next on a Wizard, but it’s not impossible to achieve in SQL Server. How you get there is a combination of people, process, and technology. This course will cover each one of those aspects to ensure that you get the entire picture of availability to ensure that your systems are mission critical from Day 1 in production. At the end of the course, you will have real-world knowledge based on actual implementations, not just theory, that you can go back and use immediately.
You will learn a holistic approach to implementing an availability strategy: from learning how to determine your requirements, to understanding the different features and technologies available to you in SQL Server, and finally, planning how to maintain your deployments in the long term. The course will go into detail about SQL Server 2012 and its new features and enhancements, including the enhanced multi-site failover clusters as well as AlwaysOn availability groups. Windows 8 Server and Server Core will also be discussed as they relate to highly available SQL Server deployments. If you are looking for practical advice and knowledge about both today and tomorrow, this course has you covered.
- Course Outline
- Mission Critical Basics: Ensuring that your SQL Server 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.
- Windows Deployment for SQL Server: One of the challenges that many DBAs face is ensuring that the underlying Windows builds are done correctly. 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. Windows 8 Server will also be covered in some capacity.
- SQL Server Failover Clustering: Besides understanding the Windows portion of clustering, it is essential to know the SQL Server component as well. Learn how to plan, deploy, and administer clustered instances of SQL Server, including multi-site clusters using SQL Server 2012.
- SQL Server Failover Clustering: Continued from Day 1
- Database Mirroring, Log Shipping, and Replication: These three features have been in SQL Server for quite some time and are remain valid options for part of your overall SQL Server availability strategy. Each feature will be explored, and you will learn the most important aspects for planning, deployment, and administration, including the best scenarios for when to use them.
- AlwaysOn Availability Groups: A key new feature of SQL Server 2012 is AlwaysOn availability groups. Learn how to implement and administer this new feature, which is built upon a foundation of Windows failover clustering as well as database mirroring.
- Backup and Restore: Arguably the most important aspect of any availability strategy is implementing a solid backup and restore design. This step will be discussed in detail.
- Day-to-Day Administration to Enhance Uptime: Keeping servers, instances, and databases running is more than deploying one of the features covered in this course. There is routine maintenance to consider, as well as periodic patching/upgrading that must occur. Not only are there tasks, but you also need to keep on top of things by monitoring to see when things are a problem–or will be a problem. The top things that you must do to remain up will be covered.
- Solution Design: Last but certainly not least: It isn’t enough to simply understand the technologies individually. 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.
When & Where
Data Education is a full-service training company, specializing in courses targeting DBAs, developers, and business intelligence professionals. Data Education brings the experts in the database field to its students, from bestselling SQL Server authors to the nation’s premier business intelligence consultants.