30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

High Availability in SQL Server 2008

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

Speaker focus

Justin Langford

Justin is a Principal Consultant for Coeo Ltd, a Microsoft Gold Partner providing SQL Server consulting services for upgrade, performance tuning, scalability and availability solutions for all versions of SQL Server.  Coeo also offer Remote DBA services to customers who outsource management and 24x7 operations of their SQL Server platform.  Justin works delivering and maintaining SQL Server solutions for customers in a variety of industry sectors throughout Europe.
    Prior to joining Coeo - Justin spent three years working for Microsoft as a Premier Field Engineer.  In this role, he delivered SQL Server support consulting to some of Microsoft’s largest finance and government customers in Europe.  Justin has co-authored Wrox IT Pro: SQL Server Performance Tuning, two Syngress exam guides on SQL Server 2008 and contributed four chapters to the recently released Wrox SQL Server 2008 Internals and Troubleshooting guide with Christian Bolton, James Rowland-Jones, Jonathon Kehayias and Brent Ozar.

Justin Langford's blog http://sqlblogcasts.com/blogs/justinl



Downloads

No items to download

Other sessions from this conference

AddIns for SSMS - build your own
Comparing Azure storage and SQL Data Services
Data Mining and SSIS - makes sense.
Data Warehouse Data Modelling
Data Warehousing features in SQL 2008
Database Maintenance Optimization
Designing Effective Aggregations in Analysis Services 2008
Effective test-driven database development
End to End Report Creation and Management in SQL Server Reporting Services 2008
Implementing Clustering using SQL Server
Instrumenting, Monitoring and Auditing of SSIS ETL Solutions
Making the SQL developer one of the family with Visual Studio Team System
Message in a bottle: Service Broker from 1 to 100 in 75 minutes!
NHibernate – Open Source Object Relational Mapping (ORM)
Performance Optimization with SQL Server 2008
Performance Tuning your TSQL
Securing and Hardening a SQL Server Implementation - Notes from the Field
SQL Server Architecture: The life of a query
SQL Server’s storage engine
SSIS by example
SSIS Nuggets Live
Stop throwing hardware at the problem !
Understanding ADO.NET Data Services
Understanding Graphical Execution Plans
Universal calculated measures in MDX queries
Upgrading To SQL Server 2005 & 2008: Notes & Best Practices
What’s New in SQL Server 2008 T-SQL