[Pluralsight] SQL Server 2012 - Installation and Configuration (2013)
Date: 28 February 2013 | Posted by: pm1
![[Pluralsight] SQL Server 2012 - Installation and Configuration (2013)](http://s20.postimage.org/dgezvrvot/026b2f701b3d0684e49ae9e5690f77d5.jpg "[Pluralsight] SQL Server 2012 - Installation and Configuration (2013)")
[Pluralsight] SQL Server 2012 - Installation and Configuration (2013) | WMV | 243 MB
Genre: Video Training
Genre: Video Training
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.
Course this is Applicable to anyone Who is installing SQL Server for the first time and Wants to avoid the common pitfalls and Mistakes That are made ??SO Often. 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? Installation Which Should you Choose options for SQL Server, and How do you Keep SQL Server up-to-Date After installing IT? This Course All These answers 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 Has the IT Performance required. It then describes and Shows the SQL Server 2012 Installation Process, Including options Which to Choose or not, Along with common Configuration Mistakes to avoid. After IT That 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 Maintenance regular SO That the SQL Server installation is stable, performs well, and adheres to configuration best practices.
Content
Introduction
Introduction
Main SQL Server 2012 Editions
Additional SQL Server 2012 Editions
Licensing Changes for SQL Server 2012
Why Install SQL Server 2012 Properly?
Why Configure SQL Server 2012 Properly?
Why Maintain SQL Server 2012 Properly?
Summary
Course Structure
Pre-Installation Tasks for the Operating System
introduction
Getting Domain Accounts provisioned
and Patch Install Windows Server 2012
BIOS and Firmware Updates
Demo: Dell Support Web Site
Install or Update Your Device Drivers
Checking Your Settings Management Power
Windows Power Options
Demo: Task Manager and CPU-Z
Windows Rights Grant to the SQL Server Service
Perform Volume Maintenance Tasks
Lock Pages in Memory (LPIM)
Local Group Policy Editor
Demo: GPEDIT.MSC Usage
Final OS Configuration Tasks
Optimize Drives Dialog
Summary
What is Next?
Pre-Installation Tasks for SQL Server 2012
Introduction
Uising a Standard Naming Scheme for Disks
Considering Storage for Your Workload
Workload Additional Considerations
Choosing the Storage Type for SQL Server
Tips for Requesting Storage
RAID Basics
RAID 1
RAID 5
RAID 50
RAID 10
and RAID Level SQL Server Workloads
Provisioning Your Logical Drives
Logical Drive Testing Your Performance
CrystalDiskMark 3.0.1 x64
Demo : CrystalDiskMark
SQLIO Disk Benchmark
Summary
What is Next?
Installing SQL Server 2012
Introduction
Selecting Which Features to Install
Instance Configuration
Specifying Service Accounts
Server Configuration Screen
Changing SQL Server Agent Properties
Database Engine Configuration Tasks (1)
Database Engine Configuration Tasks (2)
Database Engine Configuration Tasks (3)
Error Reporting
Demo: Installing SQL Server 2012 (1)
Demo: Installing SQL Server 2012 (2)
Demo: Installing SQL Server 2012 (3)
Summary
What is Next?
Post-Installation Tasks for SQL Server 2012
Introduction
How SQL Server 2012 Is Updated
Optional Update Microsoft Update in
The Importance of Updating SQL Server 2012
Obtaining SQL Server 2012 Service Packs
Installing SQL Server 2012 Service Packs
Obtaining SQL Server 2012 Cumulative Updates
Requesting a Specific Cumulative Update
Demo: Requesting a SQL Server 2012 CU
Installing a SQL Server 2012 Cumulative Update
Install the Latest Service Pack and CU
Setting with SSMS Instance Properties
Demo: Setting Properties with SSMS Instance
Instance Setting Properties with T-SQL
Demo: Setting Instance Properties with T-SQL
Configuring tembdb Files
Summary
What is Next?
Automating Common Maintenance Tasks
introduction
Confirming Network Connectivity
Demo: Using SQL Server Configuration Manager (1)
Demo: Using SQL Server Configuration Manager (2)
Confirming SQL Server Connectivity
Demo: Using a Microsoft Data Link File to Confirm Connectivity
Enabling Database Mail
Creating a New SQL Operator
Creating SQL Server Agent Alerts
Demo: Creating SQL Server Agent Alerts with T-SQL
SQL Server Checking Service Properties
Ola Hallengren's Maintenance Solution
Implementing the Maintenance Solution Scripts and Agent Jobs
Demo: Configuring the Maintenance Solution Agent Jobs and
Course Summary
.
.
.
DownloaD:
http://www.tutorial-ebook.com/pluralsight-sql-server-2012-installation-and-configuration-2013/
.
.
.
See full article