High Availability in SQL Server 2008

2009

TL; DR

Database availability is important to every DBA and selecting the right solution to satisfy availability requirements can be a difficult choice. Attendees will be presented with an overview of each technology and complementary technologies enabling them to make better choices of availability solution.

Session Details

There are a growing number of availability solutions to choose between and knowing which technology to deploy based on requirements can be a difficult choice. This session will provide an overview of the technologies available, comparing and contrasting these and discussing common combinations of complementary technologies.

Here's a summary of the session:

The availability problem
- How to compare alternatives
Solutions to improve database availability
- Failover clustering
- Database mirroring
- Log shipping
- Replication

Combining High Availability technologies
Geo-clusters and storage replication
Other technologies to improve database availability

3 things you'll get out of this session

Justin Langford's previous sessions

5 Mistakes in Cloud Data Migration

We're fortunate in seeing tons of customers migrate to the cloud - this session covers major

Azure: Maxmise your bang for Buck

Considerations in how you buy Azure to provide maximum bang for buck

Serverless data solutions-what are they and when to use?

Azure introduces a range of new services for transaction processing and analytics solutions which mean we don’t need to deploy virtual machines. This session provides insight into how we see customers deploying evergreen and futureproof solutions.

Hybrid Data Solutions-how to have you cake and eat it!

We live in a cloud first World, but many organisation still run largely on-premise. This session covers how these organisations can begin their journey and leverage Azure data services.

Get started with troubleshooting SQL Server

This session present key tools, methodology and approach for troubleshooting SQL Server. Performance and availability of the database engine has a direct impact on user experience of applications.

DR with the Worlds largest data center

This session will look at providing cost effective DR capability with Azure.

Using Windows Azure to provide SQL Server Disaster Recovery

This session provides an architectural blueprint to deploying disaster recovery solutions combining on-premise and Windows Azure cloud technologies. The session looks at a design pattern to solve a long standing and often expensive issue of DR.

Hadoop, Big Data and SQL Server

There has been rapid development in the capabilities of SQL Server to support big data and hadoop following introduction of the HDInsight Service and HDInsight Server. This session covers SQL Server capability and integration points.

Notes from the field: Cross-team Performance Troubleshooting

This session will be presented jointly by Justin Langford and Gavin Payne . The focus of the session is the approach to a cross-team Performance Troubleshooting engagement where multiple stakeholders were involved.

Notes from the field: High Performance storage for SQL Server

This session provides an overview of a recent customer engagement to investigate storage performance problems and evaluate potential solutions. The session include details on measuring performance of the existing storage solution, profiling SQL Server disk IO activity and tools to simulate load and evaluate performance.