October 8, 2013 Leave a comment
In preparation for the upcoming PASS Summit, I will be presenting each of the sessions I will be doing at the Summit this week. The first will be Wednesday at the Philadelphia SQL Server Users Group, where I will be presenting my session on Hybrid Availability Groups.
Into the Blue: Extending AlwaysOn Availability Groups
For many organizations, having a second data center or co-location center doesn’t make sense, financially or logistically. Typically, this would limit options for building out a disaster recovery (DR) solution. However, now with Windows Azure virtual machines and SQL Server AlwaysOn Availability Groups, you can connect your on-premise solution to a real-time secondary replica, providing read scalability and a solid DR solution.
This session will demonstrate how to extend an Availability Group into Windows Azure, discussing the pros and cons as well as the cost of the solution. You will walk away with a solid understanding of AlwaysOn functionality within Windows Azure VMs, the costs and benefits of building a DR solution within Windows Azure, and how Azure-based backup and recovery can work.
I will also be presenting this at the PASS Summit in Room 217 D from 2:45-4 PM (1445-1600) on Friday 18 October.
On Friday, I will be presented to the Albuquerque (NM) SQL Server User’s Group on my other PASS Summit topic–
Accelerate Database Performance Through Data Compression
Much like the cars of the 1970s sacrificed gas mileage for better performance, database technology has also made its share of sacrifices for efficiency. Fortunately, times have changed significantly since then. Just as adding a turbocharger to a car delivers more power while saving fuel, the addition of compression to a database accelerates read performance while saving disk space.
Come learn how, why, and when compression is the solution to your database performance problems. This session will discuss the basics of how compression and deduplication reduce your data volume. We’ll review the three different types of compression in SQL Server 2012, including the overhead and benefits of each and the situations for which each is appropriate, and examine the special type of compression used for ColumnStore indexes to help your data warehouse queries fly. As with turbo, data compression also has drawbacks, which we’ll cover as well.
I’ll be doing this at PASS Summit in Room 203A at 3-4:15 PM (1500-1615 for my non-US readers) on Wednesday 16 October.
I hope to see many of you either at these presentations or at Summit!!