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.
Table of 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
- 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
Rapidgator.net
- bit.ly/1oF9K0u
No comments:
Post a Comment