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.
Glenn works as a Principal Consultant at SQLskills.com. He has been a SQL Server MVP since 2007, and he is also an Adjunct Faculty member at University College - University of Denver. He is the author of the book SQL Server Hardware (Redgate 2011), and he wrote chapters for both SQL Server MVP Deep Dives books.
Course Overview My name is Glenn Berry and welcome to my course, SQL Server 2016: Installing and Configuring. I'm a Principal Consultant with SQL Skills as well as a Microsoft Data Platform MVP and this topic's one that I feel very passionate about. In the course of my career as a database administrator and consultant, I've never had anyone tell me that their database or database server was too fast. It's all too common for people to complain about slow application performance and often jump to the conclusion that any performance or scalability issue must be caused by your database server. Quite often, many application and database performance issues are actually caused or aggravated by inappropriate SQL Server installation and configuration. I want to give you the best practices and tools that you can use to help prevent your SQL Server instance from being a performance or scalability bottleneck. I also want to show you how to properly configure your operating system and hardware for SQL Server usage. We also cover how to test and benchmark your store chip system and how to automate many common maintenance tasks. If you work with SQL Server in any capacity, whatever your level, this course is relevant to you. Experience installing previous versions of SQL Server is helpful, along with a basic understanding of how SQL Server works. I hope you'll join me as we explore the world of SQL Server performance and reliability with SQL Server 2016: Installing and Configuring here on Pluralsight.