SQL Server Hardware and Software Configuration

Part Of The On-Demand Courses


  • How hardware and software operate together so you can better understand what your systems can actually achieve
  • How to configure them properly for SQL Server


This course includes:

Course Description

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.



Module 01 | Class Introduction
10m 34s total


Module 01A | Class Introduction
10m 34s


Module 02 | Hardware Environment and Configuration
111m 06s total


Module 02A | Hardware Concepts
08m 06s


Module 02B | CPU
41m 15s


Module 02C | Memory
18m 23s


Module 02D | Storage
38m 41s


Module 02E | Network
05m 21s


Module 03 | Software Environment and Configuration
55m 72s total


Module 03A | Windows Requirements and Instant Database File Initialization
13m 28s


Module 03B | Instance Level Settings
14m 24s


Module 03C | TempDB Settings
06m 15s


Module 03D | Database Level Settings
22m 05s



Data Platform Practice Manager
Bradley Ball is a former Microsoft SQL Server and Data platform MVP with over 15 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States, the former Data Platform Practice Manager for Pragmatic Works Consulting, and a former Microsoft Premier Support for Developer Sr. Consultant. He has presented at many SQL Saturdays, for PASS SSUG’s across the US from California to Florida to New Hampshire, SQL Rally, DevConnections, SQLBits 2015, SQL Live 360 2011-2018, & the PASS Summit 2011-2015. He is the Managing Author for the Wiley Professional Microsoft SQL Server Administration Guide and wrote Chapter 14 Page & Row Compression for PRO SQL Server 2012 Best Practices and he can be found blogging on about SQL Server or anything else that interests him.

System Requirements

  • More information coming soon.

What to Know Before Class

More information coming soon.


Great class.


Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.



• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!