Sql Server 2022 Administration

Manage SQL Server With My Expert Assistance

What you'll learn

Learn about Microsoft SQL Server

Learn about the potential administration hurdles that mode DBA's face - Ram | CPU | Parallelism

Learn about SQL Server backups, restores and ways to verify if these processes have occurred

Learn about SQL Server settings that most people miss that will cripple your server if not set properly

Requirements

A PC with at least 16 GB of RAM

A PC with at least 100 GB of free disk space

Access To the Internet to download software (SQL Server, Windows and Various Tools)

Description

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. IntroductionIntro to SQL Server: What is SQL Server.Setting UpSetup SQL Server Setup VMware Connecting To SQL ServerSQL Server Connection ManagerSample DB'sThe Absolute EssentialsBackups: 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 AdministrationParallelism: 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 AlertsDatabase 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 MonitorJobs: 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 ViewWhat are current waits, Disk and CPU SQL Server On…VMware AWS (Amazon Web Services) SQL Server LicensingHow To License SQL Server + Costs

Overview

Section 1: Introduction

Lecture 1 Project Introduction

Lecture 2 First Look At SQL Server

Lecture 3 SQL Server Walk Around

Section 2: Setting Up SQL Server 2022 And VMWare For Our Training

Lecture 4 Install VM Ware For Our Lab

Lecture 5 Configure VM Ware & Windows

Lecture 6 Install SQL Server 2022

Lecture 7 Review SQL Server Connection Manager

Lecture 8 Setup Sample DB's

Section 3: SQL Server Backups

Lecture 9 SQL Server Full Backups

Lecture 10 SQL Server Log File Backups

Lecture 11 Backup Review

Lecture 12 Guided Examples

Section 4: Indexes and Index Management

Lecture 13 Overview Of SQL Server Indexes

Lecture 14 Types Of Indexes In SQL Server

Lecture 15 Index Fragmentation And How To View In SQL Server

Lecture 16 Index Management

Lecture 17 Index Review

Lecture 18 Indexes Guided Example

Section 5: SQ: Server Statistics

Lecture 19 SQL Server Stats

Lecture 20 Test Database Statistics

Lecture 21 Statistics Query

Lecture 22 Status Review

Section 6: RAM

Lecture 23 RAM Configuration and Settings

Section 7: Parallelism

Lecture 24 What Is Parallelism In SQL Server - How To Adjust

Lecture 25 Parallelism Overview And Settings

Section 8: User Administration In SQL Server

Lecture 26 SQL Server User Admin

Lecture 27 User Administration Review

Section 9: SQL Server Performance Dashboard

Lecture 28 Performance Dashboard Overview

Lecture 29 Performance Dashboard Demo

Section 10: Operators and Alerts

Lecture 30 Operators and Alerts

Section 11: SQL Agent

Lecture 31 SQL Server Agent

Lecture 32 SQL Server Agent Demo

Section 12: SQL Server Licensing

Lecture 33 SQL Server Licensing

Section 13: SQL Server On AWS

Lecture 34 SQL Server On AWS

Section 14: SQL Server On VMWare

Lecture 35 SQL Server On VMWare

Beginners, IT Pro's and IT Admins or anyone who wants to learn about SQL Server