Session 1: Building the Foundation on SQL Server 2012

Presented by: Colin Spence

Running Time: 70 min

Since SQL Server forms the foundation of the SharePoint environment, it is critical that it be designed properly to scale appropriately and meet the organization’s needs. Topics to be covered will include these:

Overview of the benefits and advances in SQL Server 2012

Pros and cons of physical vs. virtual configurations, use of aliases, multiple instances, and other design decisions

Review of differences between SQL Server 2012 versions

Analysis of pros and cons of mirroring vs. AlwaysOn Availability Groups, the two most popular high availability (HA) configurations

Key performance optimization strategies, from drive configurations to maintenance plans to Windows PowerShell and third-party utilities

Session Slides