SQL Server 2022 Administration

SQL Server 2022 Management is designed for IT professionals, data analysts, or anyone needing to manage SQL Server Thos course covers essential configurations, methods and best practices that apply to over 85% of SQL Server installations.

Mike Bennyhoff is an experienced SQL Server administration professional with a history of assisting over 75 clients including HP and Rolls-Royce. I aim to make SQL Server systems more resilient and efficient without extensive database theory in the shortest time possible.

Introduction

• Intro to SQL Server: What is SQL Server.

Setting Up

• Setup SQL Server

• Setup VMware

• Connecting To SQL Server

• SQL Server Connection Manager

• Sample DB's

The Absolute Essentials

• Backups: Different types of backups, SQL recovery modes, and checking backup consistency.

• Indexes: Types of indexes, maintaining them, and setting up plans to reorganize indexes.

• Stats: Importance of statistics and how to maintain them.

• RAM: How to set and check RAM settings in SQL Server.

Settings and User Administration

• Parallelism: Cost threshold and max degree of parallelism settings.

• User Administration Creating SA and DBO users, disabling users, and managing user roles.

SQL Mail and SQL Alerts

• Database Mail: Setting up and configuring database mail.

• Operators: Setting up operators for email notifications.

• Database Alerts: Creating alerts for specific error numbers and testing them.

Jobs and Activity Monitor

• Jobs: Automating tasks with SQL Server Agent jobs, scheduling, and monitoring.

• Activity Monitor: Using Activity Monitor to track server performance, identify bottlenecks, and kill blocked processes.

Performance Dashbard

• How to Open and View

• What are current waits, Disk and CPU 

SQL Server On...

• VMware

• AWS (Amazon Web Services) 

SQL Server Licensing

• How To License SQL Server + Costs