30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

Real World SQL Server High Availability

You can read the Microsoft marketing messages about how wonderful the HA options are in SQL Server. So what are they like in the real world? This session will discuss the theory, and see how it works in practice, related to my experience of Failover Clustering, Database Mirroring, Log Shipping and other "HA" options that exist. The session will also cover business considerations, like how expensive the solutions are, both for hardware purchase and software licensing.

Speaker focus

Tom Pullen

tom2.jpg
Tom has been a DBA since 1998, he started out using SQL Server 4.2 and 6.5. He currently works for Helveta, a small company providing asset tracking software. He has previously worked for RM Education and Oxfam. He is a Senior DBA, with responsibility for system design, maintenance, database design, performance tuning, scalability and platform architecture. He has written several articles for sql-server-performance.com. He presented at SQL Bits 2, 4 and 6 (he only likes even numbers - so let's make SQL Bits 7 the exception that proves the rule!).

Tom Pullen's blog http://thomaspullen.spaces.live.com/blog/



Downloads

No items to download

Other sessions from this conference

A whistlestop tour of SSIS add-ins
Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study
An introduction to Master Data Services
Building cubes from ODS or Operational Systems
Cache-warming strategies for Analysis Services 2008
Common Integration Services Problems
Creating High Performance Spatial Databases
Data & Backup Compression in SQL Server 2008
Data Visualisation with Bing Maps for Enterprise
Data Warehouse on a Fast Track forwards
Data warehousing features in SQL 2008
Designing for simplification
Designing I/O systems for SQL Server
Excel - An Excellent Data Mining Tool
Getting Dimensional with Data
I need my reports..........Yesterday!
Introducing Project Madison
Introducing SQL Server Master Data Services
Introduction of MS StreamInsight.
Introduction to the Microsoft BI Technology Stack
Let’s make SQL fly – a technical session for developers and administrators who believe in magic!
Lets go more functional - F# WHAT , WHY and BI
Microsoft SQL Server 2008 R2: What’s New in Reporting Services
Optimistic Concurrency Internals
Powershell – old tricks for a new dog?
Put Your Feet Up : Simplified Management using the Enterprise Policy Management Framework
Report Builder 3
Self Service Business Intelligence- Project Gemini
Server consolidation with SQL Server
SQL 2008 Development Features
SQL Injection Attacks (and how to prevent them)
SQL Server 2008 - Unstructured Data Storage Solutions and Best practices
SQL Server optimization stuff you won’t find on Google (yet)
SQL, NoSQL, SomeSQL - A look at non-relational databases
SQLDataSources, LINQDataSources and EntityDatasources in Database Design
SSIS in SQL Server 2008
Strapped for cache? - Troubleshooting memory problems in SQL Server 2008
The R2 Duo: Running SQL Server 2008 R2 on Windows Server 2008 R2 Core
T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig
Using Perfmon and Profiler
Virtualising SQL Server
Vital Statistics
What's new in R2 for the DBA
When a query plan goes wrong