3 MIN READ

Connect to SQL Server and Identify Your Instance

Connect securely, distinguish an instance from a database, and collect a reproducible configuration baseline.

Read tutorial

3 MIN READ

Create a SQL Server Database and Inspect Its Files

Create a small lab database, insert a fixture, and understand data files, log files, and growth settings.

Read tutorial

3 MIN READ

Understand SQL Server Architecture Through Active Requests

Relate sessions, query execution, waits, and storage activity to the Database Engine.

Read tutorial

3 MIN READ

Test SQL Server Schema Permissions with a Database Role

Create a schema-scoped reader role and prove both allowed and denied operations.

Read tutorial

3 MIN READ

Choose a SQL Server Recovery Model and Diagnose Log Reuse

Understand recovery objectives, start a backup chain, and investigate why log space cannot be reused.

Read tutorial

3 MIN READ

Back Up SQL Server and Prove a Restore to a New Database

Create a copy-only backup and restore it under a separate name with explicit file relocation.

Read tutorial

3 MIN READ

Build a Measured SQL Server Maintenance Routine

Check integrity, inspect index size, and update statistics without routine shrinking.

Read tutorial

3 MIN READ

Schedule and Monitor a SQL Server Agent Maintenance Job

Create a disabled integrity-check job, test it manually, and enable a monitored schedule.

Read tutorial