SQL Server: Installing and Configuring SQL Server 2016
Learn how to correctly install and configure SQL Server 2016, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance.
What you'll learn
How do you configure Windows correctly for running SQL Server 2016? 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, SQL Server: Installing and Configuring SQL Server 2016, answers all these questions and more. The course begins by explaining why it is so important to install SQL Server 2016 correctly and then explains how to configure Windows for stability and performance. It then describes and shows the SQL Server 2016 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 2016 instance up-to-date with Service Packs and Cumulative Updates, as well as post-installation configuration tasks. Finally it explains how to configure Database Mail and SQL Server Agent Alerts so that you are notified of critical errors when they occur. When you're finished with this course, you'll be better prepared to install SQL Server for the first time.
Table of contents
- Introduction and Provisioning SQL Server Service Accounts 2m
- Install and Patch Windows Server 2016 2m
- BIOS/UEFI, Firmware, and Device Driver Updates 3m
- Checking Your Power Management Settings and Using CPU-Z 3m
- Demo: Windows Power Plan Settings 1m
- Demo: Using CPU-Z 2m
- Grant Windows Rights to SQL Server Service Account 2m
- Demo: Granting Rights to the SQL Server Service Account 2m
- Final OS Configuration Tasks and Hardware Settings 2m
- Enabling Hardware Virtualization Support 2m
- Module Summary 1m
- Introduction 1m
- Using a Standardized Naming Scheme 2m
- SQL Server Workload Types and I/O Considerations 3m
- Choosing and Requesting the Storage Type for SQL Server 3m
- RAID and Common RAID Levels 5m
- RAID Controller Considerations 2m
- RAID Level Choice and Provisioning Logical Drives 3m
- Benchmarking Your Storage and Using CrystalDiskMark 3m
- Demo: Using CrystalDiskMark to Test Your Storage 2m
- Demo: Using Microsoft DiskSpd to Test Your Storage 2m
- Module Summary 1m
- Introduction and Updating SQL Server 2016 3m
- Obtaining the Service Packs and Cumulative Updates 1m
- Demo: Obtaining the Latest Cumulative Update 2m
- Demo: Installing a Cumulative Update 2m
- Maintaining SQL Server Management Studio (SSMS) 1m
- Demo: Installing an SSMS Update 1m
- Instance-level Configuration Settings 3m
- Demo: Changing Instance-level Properties with SSMS 3m
- Demo: Changing Instance-level Properties with T-SQL 3m
- Module Summary 1m
- Introduction 1m
- Confirming Network and SQL Server Connectivity 3m
- Demo: SQL Server Configuration Manager 2m
- Demo: Using Microsoft Data Link 1m
- Enabling Database Mail and Creating a New SQL Operator 2m
- Creating SQL Server Agent Alerts 2m
- Ola Hallengren's Maintenance Solution 3m
- Demo: Configuring the Ola Hallengren Maintenance Solution 2m
- Suggested Default Maintenance Job Schedule 2m
- Module and Course Summaries 2m
About the author
Glenn works as a Principal Consultant at SQLskills.com. He has been a SQL Server MVP since 2007, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, and performance tuning. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher P... more