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.
Course info
Rating
(67)
Level
Beginner
Updated
Dec 21, 2016
Duration
2h 1m
Table of contents
Course Overview
Introduction
Pre-installation Tasks for the Operating System
Pre-installation Tasks for SQL Server 2016
Installing SQL Server 2016
Post-installation Tasks for SQL Server 2016
Automating Common Maintenance Tasks
Description
Course info
Rating
(67)
Level
Beginner
Updated
Dec 21, 2016
Duration
2h 1m
Description

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.

About the author
About the author

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.

More from the author
More courses by Glenn Berry
Section Introduction Transcripts
Section Introduction Transcripts

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.

Pre-installation Tasks for the Operating System
This is Glenn Barry with sqlskills. com, and I'm recording this course for Pluralsight. This is module two: pre-installation tasks for the operating system. So what are we going to cover in this module? We'll start off talking about the multiple tasks that you actually have to complete before you install SQL Server 2016. This includes things like installing the operating system, patching the operating system, and actually configuring the operating system properly for the best SQL Server experience. Then we'll get into things you have to do at the hardware and BIOS level to make sure you're going to get the best performance and scalability out of this instance. One of the first things you need to do before you install SQL Server is actually provisioning your SQL Server Service Accounts. You're going to need an account for each SQL Server service for the different components you're running, such as the database engine and SQL Server agent, and other things such as reporting services or analysis services that you might be installing. These should be regular domain user accounts in most cases, they don't need to be any kind of special domain admin account. You're going to need the name and the password for those accounts during installation. And also, if you want to, you can save yourself some headaches down the line by using Group Managed Service Accounts, or GMSAs. If you do that, it's a little bit more work up front, but then you don't have to worry about changing the password on your regular user accounts, and they're actually easier to manage in the long term.

Pre-installation Tasks for SQL Server 2016
This is Glenn Berry with sqlskills. com, I'm recording this course for Pluralsight, and this is Module Three, Pre-Installation Tasks for SQL Server 2016. So what are we going to cover in this module? We'll start off talking about how important it is to use a standardized naming scheme for your LUNs, next, I'll talk about the different SQL Server workload types, and how that's going affect how you decide to configure your storage. We'll talk about how you go about choosing what kind of storage type to use, depending on your workload, then we'll get into an introduction to RAID, and talk about how RAID levels affect your SQL Server workloads. Finally, we'll show you how to do some quick tests of each of your logical drives.

Automating Common Maintenance Tasks
This is Glenn Berry from sqlskills. com. I'm recording this course for Pluralsight, and this is Module six, Automating Common Maintenance Tasks. What are we going to cover in this module? We'll start of talking about how you confirm network connectivity from one machine to another. Then we'll move on to how you confirm SQL Server connectivity from one machine to another. We'll get into how you enable database mail. Next we'll cover how you create a new SQL Server Operator. Then we'll show you how to create SQL Server Agent Alert. Then we'll cover how to install and configure Ola Hallengren's Maintenance Solution. Then finally, we'll cover how you add notifications to SQL Server Agent jobs.