SQL Server 2022 Database Administration Essential Training

Install SQL Server 2022 developer edition with a custom setup, configure mixed mode authentication, assign data, log, and backup directories, and connect using Management Studio.

Install the latest SQL Server Management Studio (SMS 19) and complete the setup. Connect to local host or IP and verify SQL Server 2022 Developer Edition.

Learn about five system databases and their roles: resource, msdb, master, model, and tempdb, and how they store metadata, backup history, templates for new databases, and temporary workspace.

Explore how SQL Server stores data and logs in data files and log files, including primary and secondary files (MDF), and how file groups and alter database manage storage.

Explore contained databases that isolate from the instance and other databases, with metadata in the database, same collation, and partial containment for easier migration and failover.

Understand the distinction between server logins and database users, and how logins map to databases. Learn to grant and deny permissions inside a database to a user, not the login.

Create and manage logins and database users, map logins to users, grant data reader permissions, and rename, revoke, disable, or drop users with scripts to prevent orphaned users.

Create a contained database user with a SQL user password in Demo DB, assign data reader and writer roles, and connect by name so the database authenticates the user.

Configure a server audit in SQL Server 2022, set queue delay and file destination, enable server and database audit specifications for login, backup, and failure events, and review logs.

Identify columns that may hold sensitive data using data discovery and classification in SQL Server Management Studio, view the schema, classify data, and save recommendations to generate a report.

Learn to run SQL vulnerability assessments on SQL Server 2022 to discover and remediate database vulnerabilities, generate actionable remediation scripts, customize baselines, and improve security and compliance.

Learn the principles of backup and restore for SQL Server databases, and implement a well-planned strategy to protect data and minimize risk of loss.

Perform differential backups that contain only data changed since the last full backup, making them smaller and faster to create. Restore requires applying the full backup, then the differential.

Learn how to perform reliable SQL Server backups and restores, including full, differential, and transaction log restores, point-in-time recovery, and upgrade implications.

Explore how to design a backup and restore strategy for SQL Server 2022, balancing full, differential, and log backups with RPO and R2 goals, scheduling, and automation.

Create a SQL Server Agent job to insert data into the time tracker table every minute, using a T-SQL step on the demo DB and configure schedule and notifications.

Configure and test SQL Server database mail by creating an email profile, adding an SMTP account (gmail), setting profile security, and sending a test email.

Automate daily full backups with SQL Server maintenance plans via the maintenance wizard, store to disk, clean up backups older than four weeks, and generate reports.

Review SQL Server logs to troubleshoot configuration, startup issues, and trace flags; use SP_recycle_error_log to recycle logs, and view agent and database mail logs across seven logs.

Learn how clustered, non-clustered, columnstore, XML, and full-text indexes boost query performance in SQL Server 2022. Read execution plans, apply missing index guidance, and maintain indexes through rebuilds and reorganizations.

Explore how SQL Server 2022 query store captures runtime statistics and execution plans to troubleshoot performance, force prior plans, and analyze top queries and resource waits across databases and replicas.

Learn to download, install, and configure SolarWinds Database Performance Analyzer, create a repository, register a SQL Server instance, and set alerts to monitor performance and blocking.

Learn to migrate a SQL Server database to an AWS EC2 instance using backup and restore, including copying backups, restoring with relocated files, and handling orphan users and job scripts.

Detach and attach a database to move it between servers or drives, handling active connections and locating data and transaction log files using Adventureworks as an example.

Export a bacpac archive from on premise and import it to docker sql server. Connect via sql management studio and rename the database to adventureworks 2022 for azure migration.

Master the first 90 days with a 30-60-90 roadmap: learn dev, qa, uat, and production environments, and document change while proving reliability through proactive problem solving.