NEED HELP? TALK TO AN EXPERT (904) 638-5743

SQL Server Hardware and Software Configuration

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • 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
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

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.

Outline

 

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

Instructor

BRADLEY BALL

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 http://www.sqlballs.com about SQL Server or anything else that interests him.

System Requirements

  • More information coming soon.

What to Know Before Class

More information coming soon.

REVIEWS

Great class.

Anonymous

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required