SQL Server: Installing and Configuring SQL Server 2016

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours | 252 MB

Genre: eLearning | Language: English

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.

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.