SQL Server 2012: Installation and Configuration
Pluralsight
Course Summary
Learn how to correctly install and configure SQL Server 2012, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance. This course is applicable to anyone who is installing SQL Server for the first time and wants to avoid the common mistakes and pitfalls that are made so often.
-
+
Course Description
How do you configure Windows correctly for running SQL Server 2012? Which Edition of SQL Server 2012 should you select? How do you choose a RAID level for the SQL Server storage? Which installation options should you choose for SQL Server, and how do you keep SQL Server up-to-date after installing it? This course answers all these questions and more. The course begins by explaining why it is so important to install SQL Server 2012 correctly, and then explains how to configure Windows for stability and performance, choose a storage RAID level that takes the anticipated SQL Server workload into account, and test the storage to ensure it has the performance required. It then describes and shows the SQL Server 2012 installation process, including which options to choose or not, along with common configuration mistakes to avoid. After that it explains how to keep your SQL Server 2012 instance up-to-date with Service Packs and Cumulative Updates, as well as post-installation configuration tasks such as provisioning tempdb. Finally it explains how to configure Database Mail and SQL Server Agent Alerts so that you are notified of critical errors when they occur, plus installing and configuring a simple solution for regular database maintenance, such as backups and index rebuilds. This course is perfect for anyone who is installing SQL Server for the first time and needs guidance on how to properly configure Windows, SQL Server, storage, and regular maintenance so that the SQL Server installation is stable, performs well, and adheres to configuration best practices.
-
+
Course Syllabus
Introduction- 16m 43s
—Introduction 1m 47s
—Main SQL Server 2012 Editions 2m 50s
—Additional SQL Server 2012 Editions 1m 51s
—Licensing Changes for SQL Server 2012 2m 44s
—Why Install SQL Server 2012 Properly? 1m 9s
—Why Configure SQL Server 2012 Properly? 0m 56s
—Why Maintain SQL Server 2012 Properly? 3m 18s
—Summary 1m 21s
—Course Structure 0m 47sPre-Installation Tasks for the Operating System- 30m 25s
—Introduction 1m 58s
—Getting Domain Accounts Provisioned 1m 39s
—Install and Patch Windows Server 2012 2m 4s
—BIOS and Firmware Updates 1m 32s
—Demo: Dell Support Web site 2m 14s
—Install or Update Your Device Drivers 1m 28s
—Checking Your Power Management Settings 1m 27s
—Windows Power Options 2m 6s
—Demo:Task Manager and CPU-Z 3m 24s
—Grant Windows Rights to the SQL Server Service 1m 2s
—Perform Volume Maintenance Tasks 1m 59s
—Lock Pages in Memory (LPIM) 1m 51s
—Local Group Policy Editor 1m 2s
—Demo: GPEDIT.MSC Usage 1m 51s
—Final OS Configuration Tasks 2m 26s
—Optimize Drives Dialog 0m 46s
—Summary 0m 51s
—What is Next? 0m 37sPre-installation Tasks for SQL Server 2012- 28m 59sInstalling SQL Server 2012- 21m 16sPost-Installation Tasks for SQL Server 2012- 28m 40sAutomating Common Maintenance Tasks- 28m 47s