When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
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.
This Course Includes
pluralsight
4 (111 reviews )
2 hour 1 minutes 
english
Online - Self Paced
core courses
pluralsight
About SQL Server: Installing and Configuring SQL Server 2016
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.
What You Will Learn?
- Course Overview : 1min.
- Introduction : 16mins.
- Pre-installation Tasks for the Operating System : 21mins.
- Pre-installation Tasks for SQL Server 2016 : 27mins.
- Installing SQL Server 2016 : 15mins.
- Post-installation Tasks for SQL Server 2016 : 20mins.
- Automating Common Maintenance Tasks : 19mins.