SQL Server: Installing and Configuring SQL Server 2016

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.