SQL Server - DBA - 1
What is virtual log file (VLF)
Create a SQL database
The importance of Tempdb
Attach and detach a database
Introduction to SQL Server Backups
Full Database Backup
Transaction Log Backups
Differential Backups
Backup strategy for various scenarios
Introduction to SQL Server Database Restore
Restore database with GUI
Restore database using differential
Recovery state in restores
Recovery mode with tail log backup
Backup using Maintenance plan
Backup Admin database using Maintenance plan
Maintenance Plan Tasks
Shrinking a database
The importance of using SQL Server Agent
Multi Server Administration
The importance of DBCC CheckDB
Setting up SQL Database Mail
Error Message Severity Levels
Login in SQL Server
Managing security with T SQL
Selecting Authentication or Mixed Mode security
Accessing SQL Server using SQL Login
Understanding SQL Server Roles
Managing SQL Server Permissions
Best Practice to Secure the SQL Server
SQL Server Security Scripts
SQL Server - DBA - 2
What is a Clustered Index
When to Use or Not use Indexes
Reorganize and Rebuild Indexes
SQL Profiler Best Practice
SQL Server Side Trace
SQL Server Database Engine Tuning Advisor
SQL Server Statistics
Activity Monitor in SQL Server
SQL Server Performance Monitor
SQL Server Optimization
Dynamic Management Views (DMVs)
SQL Server Locks, Blocking, and Deadlocks
SQL Server Extended Events
Extended Event via T-SQL
SQL Server Database Snapshots
SQL Server Import and Export
SQL Server Bulk Copy Program (BCP)
SQL Server Partitioning
SQL Server Contained databases
SQL Server Policy-Based Management (PBM)
SQL Server Linked Servers
SQL Server logs and SQL Agent logs
SQL Server - DBA - 3
Configure Domain Controller and Active Directory for SQL Server
SQL Server Installation For HA
SQL Server Log Shipping
Log shipping Manual Failover
Solving problems of orphaned users when moving a Database from Source to Destination
Monitoring Log Shipping
Database Mirroring
SQL Server Database Mirroring Monitoring
SQL Server Replication Step by Step
SQL Server AlwaysOn
SQL Server Backup Database on Secondary Replicas
Implementing Backup on Secondary Replicas (AlwaysOn Availability Groups)
