Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Building NextGen Scalable & Highly Available Architectures with Microsoft SQL Server 2008 R2

PASS Data Community Summit via YouTube

Overview

Explore advanced techniques for building highly scalable and available architectures using Microsoft SQL Server 2008 R2 in this comprehensive conference talk from PASS Data Community Summit. Dive deep into the latest features and their implementation requirements, examining real-world customer reference architectures for both scale-up and scale-out scenarios. Learn about crucial scalability, high availability, and disaster recovery features, including database mirroring, snapshot databases, clustering, resource governance, and Peer-to-Peer replication. Discover how SQL Server 2008 R2 enhancements can drive business improvements in enterprise database environments, with insights from a real-world implementation and lessons learned. Gain valuable knowledge on addressing data management challenges, understanding different database workloads, and leveraging key technologies such as server virtualization support, live migration, and shared services architecture. Master best practices for consolidation, virtualization, and implementing a robust data access framework to create next-generation database solutions.

Syllabus

Introduction
Agenda
Data Management Challenges
Reasons for Data Management Challenges
Database Workloads
ReadWrite Compromise
WeApps
Paradigm Shift
Key Technologies Features
Guest OS Support
Live Migration
Server Virtualization Support
Shared Services Architecture
Non VM Shared Services Architecture
Resource Governor
Resource Pool
Classifier Function
Best Practices
Consolidation
Virtualization
PeertoPeer
Data Access Framework
Database snapshots
Database snapshot example
How Snapshots work
Reference Architecture

Taught by

PASS Data Community Summit

Reviews

Start your review of Building NextGen Scalable & Highly Available Architectures with Microsoft SQL Server 2008 R2

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.