• Accidental DBA

  • 2 Day Course  |  £795.00 (+VAT)

Target Audience

If you have ever found yourself at the helm of your company’s SQL Server simply because you “happen to know a little SQL” and it has now become your job to keep your SQL Server estate afloat? Then this is the course for you.

Required Knowledge

  • Basic understanding of relational databases
  • Basic T-SQL knowledge

Purpose of the Course

By the end of this course you will be able to confidently maintain and monitor SQL Server, alongside having a thorough understanding of disaster recovery, index maintenance, and baselining so that you can deal with any issues raised and remain calm and in control should a crisis ever arise. This information will be the underlying knowledge to build on when looking to improve and upgrade your career.

Topics Covered

  • Server Hardware
  • SQL Server Configuration Settings
  • Disaster Recovery
  • Security
  • Database Maintenance
  • Index and Statistics Maintenance
  • Baselining

Course Modules

Module 1: Basic Database Management

  • Hardware Overview
  • Configuration Overview
  • System Database Overview
  • Disaster Recovery Overview
  • Index Maintenance Overview
  • Baselining Overview

Module 2: Server Hardware

  • Local Disks
  • SAN Disks
  • Memory
  • CPU

Module 3: SQL Server Configuration

  • Max Server Memory
  • Max Degree of Parallelism
  • Optimise for Ad Hoc Workloads
  • Backup Compression
  • Dedicated Administrator Connection
  • Misc Settings to Consider

Module 4: Backup and Restore

  • Recovery Models
  • Backup Types
  • Restore Types
  • High Availability Overview

Module 5: High Availability

  • Strategy Planning
  • Mirroring
  • Log Shipping
  • Replication
  • Failover Clustering
  • Availability Groups

Module 6: SQL Server Security

  • Domain and SQL Authentication
  • Logins and Users
  • Database Level Permissioning
  • Object Level Permissioning

Module 7: Database Maintenance

  • System Databases
  • TempDB
  • User Databases
  • Shrinking Databases

Module 8: Index Maintenance

  • Reindex vs Reorg
  • Fill Factor
  • Unused Indexes
  • Statistics Maintenance

Module 9: Monitoring

  • Profiler
  • Extended Events
  • Live Query Monitoring

Module 10: Baselining

  • Why do we baseline?
  • Windows Performance Counters
  • SQL Server Counters
  • DMVs to Track
  • Would you like to discuss your training requirements with me?

    I'm always happy to help so, whatever your question, simply give me a call or send me a message and I'll get back to you as quickly as possible.