SQL Server 2012: Installation and Configuration
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.
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using: {{getCurrentPlayerName()}} [Change]
| expand all | collapse all | Progress | Duration | |
|---|---|---|---|
 Introduction |
|
00:16:43 | |
|
Introduction
|
|
01:47 | |
|
Main SQL Server 2012 Editions
|
|
02:50 | |
|
Additional SQL Server 2012 Editions
|
|
01:51 | |
|
Licensing Changes for SQL Server 2012
|
|
02:44 | |
|
Why Install SQL Server 2012 Properly?
|
|
01:09 | |
|
Why Configure SQL Server 2012 Properly?
|
|
00:56 | |
|
Why Maintain SQL Server 2012 Properly?
|
|
03:18 | |
|
Summary
|
|
01:21 | |
|
Course Structure
|
|
00:47 | |
|
Pre-Installation Tasks for the Operating System |
|
00:30:26 | |
|
Introduction
|
|
01:59 | |
|
Getting Domain Accounts Provisioned
|
|
01:39 | |
|
Install and Patch Windows Server 2012
|
|
02:05 | |
|
BIOS and Firmware Updates
|
|
01:32 | |
|
Demo: Dell Support Web site
|
|
02:15 | |
|
Install or Update Your Device Drivers
|
|
01:29 | |
|
Checking Your Power Management Settings
|
|
01:28 | |
|
Windows Power Options
|
|
02:06 | |
|
Demo:Task Manager and CPU-Z
|
|
03:24 | |
|
Grant Windows Rights to the SQL Server Service
|
|
01:03 | |
|
Perform Volume Maintenance Tasks
|
|
02:00 | |
|
Lock Pages in Memory (LPIM)
|
|
01:52 | |
|
Local Group Policy Editor
|
|
01:03 | |
|
Demo: GPEDIT.MSC Usage
|
|
01:51 | |
|
Final OS Configuration Tasks
|
|
02:26 | |
|
Optimize Drives Dialog
|
|
00:46 | |
|
Summary
|
|
00:51 | |
|
What is Next?
|
|
00:37 | |
|
Pre-installation Tasks for SQL Server 2012 |
|
00:28:59 | |
|
Introduction
|
|
00:59 | |
|
Uising a Standard Naming Scheme for Disks
|
|
01:35 | |
|
Considering Your Workload for Storage
|
|
01:35 | |
|
Additional Workload Considerations
|
|
01:34 | |
|
Choosing the Storage Type for SQL Server
|
|
03:23 | |
|
Tips for Requesting Storage
|
|
02:06 | |
|
RAID Basics
|
|
01:04 | |
|
RAID 1
|
|
01:00 | |
|
RAID 5
|
|
01:33 | |
|
RAID 50
|
|
00:59 | |
|
RAID 10
|
|
01:03 | |
|
RAID Level and SQL Server Workloads
|
|
01:45 | |
|
Provisioning Your Logical Drives
|
|
01:12 | |
|
Testing Your Logical Drive Performance
|
|
00:52 | |
|
CrystalDiskMark 3.0.1 x64
|
|
02:04 | |
|
Demo: CrystalDiskMark
|
|
03:36 | |
|
SQLIO Disk Benchmark
|
|
00:55 | |
|
Summary
|
|
01:01 | |
|
What is Next?
|
|
00:43 | |
|
Installing SQL Server 2012 |
|
00:21:16 | |
|
Introduction
|
|
01:42 | |
|
Selecting Which Features to Install
|
|
01:28 | |
|
Instance Configuration
|
|
01:42 | |
|
Specifying Service Accounts
|
|
00:52 | |
|
Server Configuration Screen
|
|
00:33 | |
|
Changing SQL Server Agent Properties
|
|
00:51 | |
|
Database Engine Configuration Tasks (1)
|
|
01:23 | |
|
Database Engine Configuration Tasks (2)
|
|
01:50 | |
|
Database Engine Configuration Tasks (3)
|
|
00:57 | |
|
Error Reporting
|
|
00:50 | |
|
Demo: Installing SQL Server 2012 (1)
|
|
01:52 | |
|
Demo: Installing SQL Server 2012 (2)
|
|
02:02 | |
|
Demo: Installing SQL Server 2012 (3)
|
|
04:01 | |
|
Summary
|
|
00:37 | |
|
What is Next?
|
|
00:36 | |
|
Post-Installation Tasks for SQL Server 2012 |
|
00:28:40 | |
|
Introduction
|
|
00:56 | |
|
How SQL Server 2012 Is Updated
|
|
01:19 | |
|
Optional Update in Microsoft Update
|
|
00:38 | |
|
The Importance of Updating SQL Server 2012
|
|
01:30 | |
|
Obtaining SQL Server 2012 Service Packs
|
|
01:51 | |
|
Installing SQL Server 2012 Service Packs
|
|
01:18 | |
|
Obtaining SQL Server 2012 Cumulative Updates
|
|
01:20 | |
|
Requesting a Specific Cumulative Update
|
|
01:59 | |
|
Demo: Requesting a SQL Server 2012 CU
|
|
02:42 | |
|
Installing a SQL Server 2012 Cumulative Update
|
|
01:16 | |
|
Install the Latest Service Pack and CU
|
|
01:40 | |
|
Setting Instance Properties with SSMS
|
|
02:04 | |
|
Demo: Setting Instance Properties with SSMS
|
|
04:06 | |
|
Setting Instance Properties with T-SQL
|
|
00:37 | |
|
Demo: Setting Instance Properties with T-SQL
|
|
02:36 | |
|
Configuring tembdb Files
|
|
01:13 | |
|
Summary
|
|
00:55 | |
|
What is Next?
|
|
00:40 | |
|
Automating Common Maintenance Tasks |
|
00:28:47 | |
|
Introduction
|
|
00:51 | |
|
Confirming Network Connectivity
|
|
01:49 | |
|
Demo: Using SQL Server Configuration Manager (1)
|
|
01:41 | |
|
Demo: Using SQL Server Configuration Manager (2)
|
|
02:33 | |
|
Confirming SQL Server Connectivity
|
|
02:34 | |
|
Demo: Using a Microsoft Data Link File to Confirm Connectivity
|
|
02:56 | |
|
Enabling Database Mail
|
|
01:22 | |
|
Creating a New SQL Operator
|
|
02:06 | |
|
Creating SQL Server Agent Alerts
|
|
01:40 | |
|
Demo: Creating SQL Server Agent Alerts with T-SQL
|
|
01:41 | |
|
Checking SQL Server Service Properties
|
|
01:11 | |
|
Ola Hallengren's Maintenance Solution
|
|
01:15 | |
|
Implementing the Maintenance Solution Scripts and Agent Jobs
|
|
02:41 | |
|
Demo: Configuring the Maintenance Solution and Agent Jobs
|
|
03:31 | |
|
Course Summary
|
|
00:56 |
