Yes, we're already running the CTP versionYes, our development and testing is completeNo, we're using SQL 2005, but will upgrade laterNo, we're using SQL 2005 and don't plan to upgradeNo, we're using SQL 2000 and will upgradeNo, we're using SQL 2000 and don't plan to upgradeWhat's SQL Server 2008??[show results]

What will you do if your 1TB+ database solution crashes now? I hope you have the latest backup set... But have you ever tested your restore strategy? Have you measured how long it will take? How much data will you lose? How long can your business survive without your core line-of-business database? How much money will you loose per hour? Will your business survive a substantial outage?

It's amazing how many organisations have not thought about these sorts of considerations. Or made assumptions about the availability and recoverability of their database solution. Only to find out the hard way.

Implementing a high-availability solution in SQL Server is critical in our 24x7 world where users are accessing your database solutions continuously.

Likewise it is important to have a disaster recovery and business continuity plan in place.

In this session Victor Isakov (MCA, MCM, MCT, MVP) will cover the different high-availability technologies available in SQL Server. He will discuss how these technologies work, demonstrate them in action and discuss their relative pros / cons. Although Victor will focus on failover clustering and Availability Groups, he will also cover Database Mirroring, Log Shipping and Replication. With over 20+ years of architecting and implementing high-availability solutions Victor will provide plenty of practical advice, case studies and real-world examples.

Finally Victor will discuss disaster recovery, business continuity and how it slots into high-availability.

This should prove to be a very practical session that can help you achieve the number of nines that your business is after.

Speaker: Victor Isakov (SQL Server Solutions)

Victor Isakov is a Database Architect and Microsoft Certified Trainer who provides consulting and training services to various organizations in the public, private and NGO sectors globally, and been involved in different capacities at various international events and conferences. He has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server Certification and Microsoft Official Curriculum for both instructor led training (ILT) and e-Learning. He is one of the first IT professionals to get the Microsoft Certified Master and Microsoft Certified Architect certifications globally.
Venue: Sydney Mechanics' School Arts |
Duration 12:00 - 14:00 |
On: Wednesday, June 4, 2014