SQL Server 2012: Installation and Configuration

Learn how to correctly install and configure SQL Server 2012, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance. This course is applicable to anyone who is installing SQL Server for the first time and wants to avoid the common mistakes and pitfalls that are made so often.
Course info
Rating
(480)
Level
Beginner
Updated
Jan 11, 2013
Duration
2h 34m
Table of contents
Introduction
Pre-Installation Tasks for the Operating System
Pre-installation Tasks for SQL Server 2012
Installing SQL Server 2012
Post-Installation Tasks for SQL Server 2012
Automating Common Maintenance Tasks
Description
Course info
Rating
(480)
Level
Beginner
Updated
Jan 11, 2013
Duration
2h 34m
Description

How do you configure Windows correctly for running SQL Server 2012? Which Edition of SQL Server 2012 should you select? 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 answers all these questions and more. The course begins by explaining why it is so important to install SQL Server 2012 correctly, and then explains how to configure Windows for stability and performance, choose a storage RAID level that takes the anticipated SQL Server workload into account, and test the storage to ensure it has the performance required. It then describes and shows the SQL Server 2012 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 2012 instance up-to-date with Service Packs and Cumulative Updates, as well as post-installation configuration tasks such as provisioning tempdb. Finally it explains how to configure Database Mail and SQL Server Agent Alerts so that you are notified of critical errors when they occur, plus installing and configuring a simple solution for regular database maintenance, such as backups and index rebuilds. This course is perfect for anyone who is installing SQL Server for the first time and needs guidance on how to properly configure Windows, SQL Server, storage, and regular maintenance so that the SQL Server installation is stable, performs well, and adheres to configuration best practices.

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

Introduction
Hi, this is Glenn Berry from SQLskills. com. I'm going to recording this course for Pluralsight and it's about SQL Server 2012: Installation and Configuration. This is Module 1: The Introduction. So, what's the point of this course? Well, it turns out that proper installation and configuration of SQL Server is very, very important. It affects the security, the performance, the scalability, and the maintainability of the instance over the long-term. Also, I'll be talking about the SQL Server 2012 Editions that are available. It turns out there's some different editions in previous versions and there's a big change of licensing that you need to be aware of before you decide which edition to purchase and install. It turns out that installing SQL Server 2012 is a lot more complex than it seems. You know, a lot of people just go through and click Next as they go through the installation program and it turns out that a lot of the default choices and configurations are not often the best choice for a production SQL Server instance. Now both the operating system and SQL Server need to be configured correctly to make sure that everything's going to run properly in the future. There's operating system level configurations and settings and there's SQL Server instance-level settings that you need to worry about. Also, both the OS and SQL Server need to be maintained properly. There's Service Packs and individual hotfixes for the operating system and for SQL Server and SQL Server 2012 also has Cumulative Updates.

Pre-Installation Tasks for the Operating System
Hi, this is Glenn Berry for SQLskills. com. I'm recording this course for Pluralsight. It's SQL Server 2012 Installation and Configuration and this is Module 2: Pre-installation Tasks for the Operating System. I'm going to be talking about several different operating system-level tasks that you have to complete before you install SQL Server 2012. These affect security, performance, scalability, and maintainability of the operating system and of SQL Server itself. The first thing you need to worry about is getting some domain accounts provisioned for your SQL Server Service accounts and this will depend on which SQL Server features you're using, how many of these accounts you'll use, and different organizations have different policies for this, but just be aware that it might take a little bit of time for this actually to happen depending on the bureaucracy in your organization. The next thing I have to worry about is getting Windows Server 2012 installed and patched and ready to install SQL Server 2012 on; another thing I always want to take care of is updating the main BIOS and any other firmware on the server itself in making sure that that's all completely ready to go before I try to install SQL Server. I also want to get all the device drivers updated on the server. I also want to check the power management settings on the server, both in the BIOS and in Windows itself to make sure that we're running with the best performance possible. We're also going to go through and talk about how to grant Windows rights to the SQL Server service account for a couple of important things. We'll also make sure you have a static IP address for your database server and finally, we want to make sure that you've got your database server added to the Windows domain before you install SQL Server.

Pre-installation Tasks for SQL Server 2012
Hi, this is Glenn Berry with SQLskills. com. I'm recording this course for Pluralsight. This is SQL Server 2012 Installation and Configuration and this is Module 3: Pre-installation Tasks for SQL Server 2012. So, what am I going to talk about in this module? Well, we'll start out talking about how to use a standardized naming scheme for your disks and directories for SQL Server; then we'll get into considering your workload type for storage and we'll talk about how to choose what sort of storage you're going to use for SQL Server; we'll talk about RAID and what that means; we'll get into the RAID levels and the different kinds of SQL Server workloads and we'll get into provisioning your logical drives; and then finally we'll talk about how to actually test your logical drive performance before you install SQL Server.

Installing SQL Server 2012
This is Glenn Berry from SQLskills. com. I'm recording this course for Pluralsight. This is SQL Server 2012: Installation and Configuration and this is Module 4: Installing SQL Server 2012. What are we going to talk about in this module? Well, there are several important choices you have to make during installation. These affect security, performance, scalability, and the maintainability of your instance over time. You don't want to make the mistake that a lot of people make and just simply click Next on every single dialog. Selecting which instance and shared features to install is also very important. You should only install the features that you actually need now, not ones that you might need in the future. Instance configuration - You need to decide whether you're going to install the default instance or a named instance of SQL Server. Specifying service accounts -- You have to select which accounts to use for each SQL Server Service. These should be the accounts you've already created ahead of time. You also need to go in and change the SQL Server Agent to use automatic startup because it's set to use manual startup by default. When it comes to Database Engine configuration tasks, there's a server configuration tab that's very important and then a data directories tab and then a FILESTREAM tab. Finally, you have to decide whether or not to use error reporting. That's disabled by default, but you might want to turn it on so that you send telemetry to Microsoft to help them fix problems with SQL Server over time.

Post-Installation Tasks for SQL Server 2012
This is Glenn Berry with SQLskills. com. I'm recording this course for Pluralsight. It's SQL Server 2012: Installation and Configuration and this is Module 5: Post-Installation Configuration Tasks for SQL Server 2012 In this module, we'll be talking about how SQL Server 2012 is updated; the importance of updating SQL Server 2012; how do you obtain SQL Server 2012 Service Packs; how to install SQL Server 2012 Service Packs; how do you obtain SQL Server 2012 Cumulative Updates; and how you install them. Also, we'll talk about how to set instance level properties with SQL Server Management Studio and how to set them with T-SQL and then how to configure tempdb data files.

Automating Common Maintenance Tasks
This is Glenn Berry with SQLskills. com. I'm recording this course for Pluralsight. This is SQL Server 2012: Installation and Configuration and this is Module 6: Automating Common Maintenance Tasks for SQL Server 2012. In this module, I'll be talking about some of the things you need to do to make sure that your brand new instance is actually ready for production. These include confirming network connectivity, confirming SQL Server connectivity, enabling Database Mail, creating a new SQL operator, creating SQL Server Agent Alerts, using Ola Hallengren's Maintenance Solution, and adding Schedules and Notifications to SQL Server Agent Jobs.