Sql Server 2022 Administration
Published 3/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.57 GB | Duration: 3h 24m
Published 3/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.57 GB | Duration: 3h 24m
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