AlwaysOn: Maximizing High Availability with SQL Server 2012

2012

TL; DR

Mission critical is a major focus of SQL Server 2012 with enhancements to failover clustering and the new AlwaysOn availability groups feature. Come get advanced training on how to plan and implement highly available SQL 2012 deployments.

Session Details

When it comes to the availability landscape, SQL Server 2012 changes the game for SQL Server deployments. There many new enhancements and for traditional failover clustering deployments for instances such as flexible failover policies and multi-site clusters that can and will change the way you plan, deploy, and administer. In addition to the changes to failover clustering, there is a whole new feature: AlwaysOn availability groups. Availability groups is an evolution of database mirroring that also takes some of the better bits from failover clustering to provide a robust availability solution. Availability groups may also enable some scenarios that you have had trouble with in the past, such as using a standby database for reporting and some maintenance instead of just for standby purposes. This full day will take a deep dive into these two features and get you prepared for planning and deploying highly available SQL Server 2012 databases and instances. If you do not want a basic "this is failover clustering" or a quick introduction to availability groups, nor do you want just a day of theory, this day is exactly what you need.

3 things you'll get out of this session

Allan Hirt's previous sessions

Business Continuity for Hybrid and Cloud Native SQL Server Deployments

With more and more deployments of SQL Server becoming hybrid or cloud native, how do you need to think about availability? This session will give you the foundation on how to approach availability in the new world.

Modern Infrastructure Fundamentals for SQL Server

Even in a cloud provider or virtualized, you still need to worry about the infrastructure supporting SQL Server. This session will cover what that means in the modern world.

Dealing with Bad Networks - The Availability Conundrum

Are you trying to increase uptime locally or for disaster recovery but your network is terrible? Join the club. This session will discuss different techniques, their pros and cons, as well as considerations for availability when your network is flaky at best.

A Distributed Availability Groups Primer

A distributed availability group is not your mother's availability group. Want to know more? Attend this session.

Common Troubleshooting Techniques for AGs and FCIs

Learn how to troubleshoot AGs ad FCIs.

Storage Spaces Direct and Storage Replica for FCIs

Learn how to plan and implement storage spaces direct and storage replica for FCIs.

Top 10 Clustering Dos and Dont's

Clustered instances (FCIs) and availability groups (AGs) can still be the source of pain and confusion for many. Learn from one of the world's experts on clustering SQL Server about some of the most important considerations to clustering success.

Clustering SQL Server: What Does It Mean In 2015?

Clustering no longer means just installing a clustered instance of SQL Server (FCI). Availability groups also are clustered. This session will demystify clustering as it relates to SQL Server.

SQL Server Storage vNext: Welcome to the Future

The way our data will be stored is changing and it's all about your network. Come find out why CSVs, SMB, Windows Scale Out File Servers, fast networks, and maybe even the cloud are in your future.

Patch Management Strategies for SQL Server Deployments

Patching is often the cause of most of our downtime be it hardware, Windows, or SQL Server. This session will guide you around pitfalls to increase your uptime and reliability while managing your downtime related to patching and updating

A Preview of High Availability in SQL Server 2012

Mission critical is a major focus of SQL Server 2012. There are quite a few changes in this release to ensure that you maximize your uptime and reliability when it comes to SQL Server. This session will start preparing you for what is coming.

Multi-Site Failover Cluster With SQL 2008 and Denali

Planning a failover clustering implementation in a single data center is fairly straightforward, but what happens when you want to span data centers? Come and find out how to plan a multi-site failover cluster.

So Many High Availability Options, So Little Time

This session will compare and contrast the various SQL Server high availability options and discuss the things you need to do - both SQL Server and non-SQL Server - that you need to do to achieve availability.