SQL Server 2012 - Installation and Configuration [2013, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

SQL Server 2012 - Installation and Configuration

Год выпуска: 2013
Производитель: Pluralsight
Сайт производителя: http://pluralsight.com/training/Courses/TableOfContents/sqlserver-2012ic
Автор: Glenn Berry
Продолжительность: 2h 34m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание:
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.

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.
[spoiler="Содержание"]
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
Install and Patch Windows Server 2012
BIOS and Firmware Updates
Demo: Dell Support Web site
Install or Update Your Device Drivers
Checking Your Power Management Settings
Windows Power Options
Demo:Task Manager and CPU-Z
Grant Windows Rights 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 Your Workload for Storage
Additional Workload Considerations
Choosing the Storage Type for SQL Server
Tips for Requesting Storage
RAID Basics
RAID 1
RAID 5
RAID 50
RAID 10
RAID Level and SQL Server Workloads
Provisioning Your Logical Drives
Testing Your Logical Drive 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 in Microsoft Update
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 Instance Properties with SSMS
Demo: Setting Instance Properties with SSMS
Setting Instance 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
Checking SQL Server Service Properties
Ola Hallengren's Maintenance Solution
Implementing the Maintenance Solution Scripts and Agent Jobs
Demo: Configuring the Maintenance Solution and Agent Jobs
Course Summary
[/spoiler]
Видео: wmv3, 1024x768, 15fps, ~1500kbps
Аудио: wma2, 128kbps, 44.1kHz, Stereo
[spoiler="Скриншоты"]

[/spoiler]
Доп. информация: NO Exercise Files