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

Who this course is for

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

https://www.udemy.com/course/sql-server-2022-administration/