MS SQL Server DBA

·      Responsibilities of a Database Administrator

·      Types of DBAs, SQL Server Version History

·      What's New in SQL Server 2022 for DBAs

·      Editions of SQL Server

·      Enterprise vs. Standard Editions

·      Hardware and Software Requirements

·      Advantages of Instances

·      Types of Instances:

-      Default Instance & Named Instances

·      Pre-Installation Steps

·      Installation Process

·      Viewing Installation Log Files

·      Common Installation Issues

·      Adding or Removing Components

·      Installing Service Packs

·      Configuring Services and Startup Parameters

·      Setting Data and Log File Paths

·      Memory Configuration

·      Enabling Remote Connections

·      Configuring Network Protocols and Ports

·      Setting Default Backup Folder

·      System Defined Databases

·      Moving System Databases

·      Managing TempDB

·      Data Files, Log Files, Filegroups

·      Extents and Page Architecture

·      Tracking Free Space

·      Troubleshooting Log File Full Issues

·      Creating Databases

·      Adding Files and Filegroups

·      Security Enhancements

·      Windows Authentication:

·      Creating Logins from Windows Users and Groups

·      Orphan Logins

·      SQL Server Authentication:

·      Creating and Testing SQL Logins

·      Setting Authentication Mode

·      Understanding Server Roles

·      Working with Users

·      Resolving Orphan Users

·      Understanding Database Roles

·      Understanding Permissions

·      Security Auditing

·      Common Security Issues

·      Full

·      Bulk Logged

·      Simple

·      Why We Need Backups

·      Backup Types:

·      Full

·      Differential

·      Transaction Log

·      File or Filegroup

·      Copy-Only, Mirrored, and Tail Log Backups

·      Backup Devices

·      Backup of System Databases

·      Performing Restorations

·      Point-in-Time Recovery

·      Viewing Backup Details

·      Troubleshooting Backup Issues

·      Introduction to High Availability

·      Features and Jobs

·      Requirements for Implementation

·      Configuring Log Shipping

·      Monitoring and Manual Failover

·      Transferring Logins

·      Log Shipping Tables and Stored Procedures

·      Handling Issues

·      Internals and Advantages

·      Setting up HADR and Adding DB to AG

·      Adding Replica in AG

·      Setting up Listener and Read-Only Replicas

·      Patching in Always On

·      Troubleshooting and Maintenance

·      Introduction and Advantages

·      Replication Entities and Architecture

·      Replication Agents

·      Snapshot, Transactional, Merge, Peer-to-Peer Replication

·      Configuring and Managing Replication

·      Monitoring and Tuning Replication Performance

·      Failover Clustering Overview

·      Windows Clustering Overview

·      Requirements

·      Installation and Configuration

·      Applying Service Packs and Fixes

·      Moving Groups

·      Adding Nodes

·      Troubleshooting Cluster Issues

·      Maintenance Plans

·      Configuring Database Mail:

·      Architecture

·      Profiles and Accounts

·      Sending Mails

·      Configuring SQL Server Agent

·      Creating Operators, Alerts, and Jobs

·      Managing and Monitoring Jobs

·      Auto Alerts for Job Status

·      Database Indexes and Defragmentation

·      Health Checks

·      SQL Server Profiler and Extended Events

·      Traces and Configurations

·      Monitoring Tools:

·      System Monitor

·      Database Engine Tuning Advisor

·      Dynamic Management Views (DMVs)

·      SQL Server and Windows Error Logs

·      Troubleshooting Locks and Deadlocks

·      Transaction Isolation Levels

·      Blocking and Terminating Processes

·      Using DAC

·      Managing Databases

·      Creating Azure SQL DB

·      DTU vs. vCore Models

·      Migrating SQL DB to Azure using DMA & DMS

·      Automatic and Manual Backups

·      Point-in-Time, Long-Term, Deleted DB Restore

·      Geo-Restore and Importing Databases

·      Vertical and Horizontal Scaling

·      Zone Redundancy and DR Options

·      Geo-Replication and Auto-Failover

·      Azure Portal Monitoring

·      Query Performance Insight

·      Monitoring with DMVs

·      Tuning Azure SQL Database