Master administration, security, performance, and high availability with SQL Server 2022
Are you managing a SQL Server environment without having been trained to do so?
Or are you looking to solidify your foundation and get up to speed with SQL Server 2025?
A poorly configured server can quickly lead to real-world problems: degraded performance, security vulnerabilities, data loss, or unplanned downtime.
This training covers the full scope of a DBA’s responsibilities: installation, configuration, access management, automation, backups, performance monitoring, and high availability. It incorporates the new features of SQL Server 2025, including ZSTD compression, and includes hands-on labs so you can immediately apply what you learn.
Is it for you ?
Beginner or intermediate professionals who manage or will be responsible for managing a SQL Server environment: database administrators, system administrators, developers, analysts, engineers, DevOps professionals, and IT technicians.
Prerequisites
Basic knowledge of SQL or Windows administration
Or Experience with a relational database
Or Experience in operations, infrastructure, application support, or database development
What You'll Walk Away With
- ✓ Install, configure, and optimize SQL Server 2022 for high performance and reliability
- ✓ Manage databases, automate administrative tasks, and prepare for cloud migration
- ✓ Secure access with roles, permissions, auditing, and data protection techniques
- ✓ Implement backup and recovery strategies to ensure data continuity
- ✓ Monitor and tune performance using Query Store, XEvents, indexing, and execution plans
Training content
1 Introduction to SQL Server 2025: Architecture and the DBA Environment
- General architecture of SQL Server.
- The DBA’s role in an organization.
- Administration tools and SQL Server components.
- Points to check before proceeding with an installation.
- Planning the installation of MS SQL Server 2025.
- Metadata, system views, and dynamic management views (DMVs).
2 Configuring and Optimizing Your SQL Server 2025 Server
- Configuring system and user databases.
- Configuring SQL Server services.
- Resource tuning: MAXDOP and cost threshold for parallelism.
- Enabling network protocols.
- Optimizing tempDB.
- Data files and logs (MDF, NDF, and LDF).
- File groups and their impact on performance.
- Optimized in-memory tables and partitioning.
- Managing the transaction log to prevent disk saturation.
- Full-text search.
- Registered Servers and identifying environments.
3 Administering Your Databases and Preparing for Migrations
- Physical and logical organization of databases.
- VLFs and their impact on automatic recovery.
- Executing and automating administrative and scheduled tasks.
- Database compatibility and migrations to MS SQL Server 2025.
- Preparing a SQL Server environment for migration to the cloud.
4 Indexes and Execution Plans: Improving Performance
- Index structure.
- Clustered, non-clustered, and covering indexes.
- Primary key vs. clustered index.
- Column order in an index and its impact on performance.
- Index management: size, usage, fragmentation, maintenance
- Reading an execution plan.
- Database Engine Configuration Wizard
5 Security: Managing Access, Permissions, and Encryption
- Authentication modes: Windows and SQL
- Securing connections and sessions.
- Server, database, custom, and application roles.
- Granting privileges: Grant, Revoke, Deny.
- Database auditing and creating auditable events.
6 Automating Tasks with SQL Server Agent
- Configuring the SQL Server Agent service
- Database Mail.
- Proxies and execution context.
- Alerts on events and performance conditions.
- Automating administrative tasks.
- Running PowerShell scripts.
7 Transferring Data and Introducing SSIS
- Importing and exporting data.
- Import/Export Wizard.
- Introduction to SSIS.
- SSISDB catalog: project-based deployment, execution, and monitoring of packages.
8 Backups and Restores: Protecting Your Data
- RPO and RTO.
- Backup types: full, differential, transaction log.
- Recovery modes.
- Designing a backup and restore plan.
- Simulating a major data loss and performing a lossless restore.
- Storage optimization: compression and encrypted backups.
- ZSTD compression with SQL Server 2025.
- Multi-file backups.
- Overview of the restore process.
- Point-in-time restore.
9 Monitoring and Diagnosing Performance
- Implementing a maintenance plan.
- eXtended Events (XEvents) for tracing activity (replacing Profiler).
- Query Store for monitoring server performance.
- Alert management and configuration
- Monitoring activity and performance.
- Performance Monitor and its configuration options
10 Replication and High Availability
- Implementing replication.
- Configuring high availability with AlwaysOn.
Keep in Mind
Diagnosing a full transaction log; preparing an SQL Server for production; analyzing and selecting indexes; correcting a security model and an SQL Server Agent job; creating a backup strategy; simulating a crash and performing a restore.
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.
