xx
■ CONTENTS
Microsoft Azure Integration .......................................................................................... 632
Backup to Microsoft Azure ..................................................................................................................632
Managed Backup to Microsoft Azure ..................................................................................................633
File Snapshot Backup for Database Files in Azure .............................................................................633
Summary ...................................................................................................................... 635
■Chapter 32: High Availability Technologies ....................................................... 637
SQL Server Failover Cluster.......................................................................................... 637
Database Mirroring and AlwaysOn Availability Groups ................................................. 641
Technologies Overview .......................................................................................................................641
Database Mirroring: Automatic Failover and Client Connectivity ........................................................644
AlwaysOn Availability Groups..............................................................................................................646
Log Shipping ................................................................................................................ 648
Replication ................................................................................................................... 649
Designing a High Availability Strategy .......................................................................... 651
Summary ...................................................................................................................... 654
■Part VII: Columnstore Indexes ........................................................ 657
■Chapter 33: Column-Based Storage and Batch Mode Execution ....................... 659
Data Warehouse Systems Overview ............................................................................. 659
Columnstore Indexes and Batch Mode Execution Overview ........................................ 662
Column-Based Storage and Batch Mode Execution ...........................................................................663
Columnstore Indexes and Batch Mode Execution in Action ................................................................665
Column-Based Storage ................................................................................................ 673
Storage Format ...................................................................................................................................673
Compression and Storage Size ...........................................................................................................675
Metadata ............................................................................................................................................677
Design Considerations and Best Practices for Columnstore Indexes ........................... 681
Reducing Data Row Size.....................................................................................................................681
Giving SQL Server as Much Information as Possible ..........................................................................681
Maintaining Statistics .........................................................................................................................681
Avoiding String Columns in Fact Tables ..............................................................................................682
Summary ...................................................................................................................... 684