SQL Server Hardware and Configuration
On-Demand Training

Starting At: $895 995
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

Unlimited Elite Pack


Per User Per Year
Free Trial

Unlimited Elite Pack $100 off through March 31th.


Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?


Course Details

SQL Server configuration is an often-neglected part of setting up your organization’s infrastructure for success. Accepting system defaults does not always provide the best results, and in fact, can often result in performance problems and later rework to correct the problems. In this class, you will learn how hardware and software operate together, so you can better understand what your systems can actually achieve and how to configure them properly for SQL Server.
Available with Elite Package only


The course assumes attendees have a strong understanding of SQL Server fundamentals. For example, knowing and using the SQL Server Management Studio (SSMS) interface and associated toolbox items before attending this class.

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7, Windows 8 or Windows 10
  • 2 GHz or faster CPU
  • 2 GB of available RAM (recommended 4 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
    • SQL Server Database Engine
    • SQL Server Management Studio

  • AdventureWorks2012 or AdventureWorks2014 databases installed on the instance

  • AdventureWorksDW2012 or AdventureWorksDW2014 databases installed on the instance

Curriculum For This Course


Bradley Ball

Bradley Ball is a MCITP 2005 and 2008 DBA with over 12 years of experience. Bradley spent 8 years working as a Defense Contractor for clients such as the U.S. Army, The Executive Office of the President of the United States, and Publix Supermarkets. He is the Data Platform Management Lead for Pragmatic Works and a Microsoft VTSP. He has presented at many SQL Saturday events, for PASS SSUGs, SQL Rally, DevConnections, SQL Live 360, and PASS Summit 2011, 2012, 2013. He blogs at http://www.sqlballs.com.

Related Courses

Course Info
3 Comprehensive Modules
10 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
2h 58m
Download Syllabus
Enrollment Price:


Share this course with your friends