SQL Server Advanced Administration (2008/2014)

Duration: 4 Days


This course is at aimed at SQL Server 2008 database administrators who wish to build on their basic administration skills and learn how to manage multiple SQL Server deployments and implement some of the more advanced administration and management services. This course, along with the SQL Server 2008 Essential Administration Course, helps to prepare delegates for the 70-432 Microsoft MCTS exam.


Delegates attending this course should have SQL Server 2008 administration knowledge up to the level provided by the “SQL Server 2008 Essential Administration” course.

Course includes

A comprehensive set of reference notes covering course topics and follow-up telephone support.

Course outline

DBA Maintenance Tasks

  • DBA Maintenance Tasks
  • Manage Services
  • Maintain Security
  • User Account Management
  • Linked Server Management
  • Impersonation
  • Index Maintenance
  • Index Types
  • Spatial
  • Clustered/Non-Clustered
  • XML
  • Filtered
  • Include
  • Updating & Creating Index & Column Statistics
  • Automatic v Manual Update
  • Enabling and Disabling Indexes
  • Rebuilding and Re-organizing Indexes
  • Database Engine Tuning Advisor
  • Manage Collations
  • Data File Maintenance
  • Shrinking Databases and Data Files
  • Automatic v Manual
  • Data Purging
  • Database Maintenance Plans
  • Maintain Database Integrity
  • Suspect Pages
  • Performance & Tuning
  • Checking Log Files

Command Line Administration Tools

  • Using Powershell
  • Using sqlcmd

Advanced Database Design

  • Partitioning
  • Partitioned Tables
  • Partitioned Indexes
  • Sparse Columns
  • Row/Page Compression
  • Enabling Filestream Support
  • Implementing Full Text Indexing
  • Implementing Transparent Database Encryption(TDE)
  • Creating Database Snapshots

Transferring Data

  • Overview of Data Transfer
  • bcp utility
  • Import & Export Wizards
  • Introduction to SQL Server Integration Services

Implementing Replication

  • Overview of Replication
  • Managing Publications and Subscriptions
  • Configuring Replication in Some Common Scenarios

Advanced Monitoring of SQL Server

  • Monitoring with DDL Triggers
  • Logon Triggers
  • Using Event Notifications

Performance Tuning Services

  • Profiler
  • Performance Monitor
  • Dynamic Management Views
  • Using Resource Governor
  • Performance Studio
  • Data Collector

Policy-Based Management

  • Using Policy-Based Management

Implementing Service Broker

  • A sample application

High Availability

  • Database Mirroring
  • Log Shipping
  • Clustering

Course Dates

London CentralLondon GreenwichBristol

Dates Price Book Now
21 - 24 Nov £1395 Book Now
19 - 22 Dec £1395 Book Now
See more dates...
All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260
All prices are per person and are subject to VAT
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)

Related Courses

"Trainer's knowledge was immense, clearly an experienced practitioner."

Joseph Chamberlain College

"The course was well structured, clear and in a comfortable setting. The tutoring was exceptional."


"I am writing to say thank you for organising my FileMaker training day; I learned so much with my trainer, Nick, and have come away with such a great database. It delighted both the Director and my job share partner. I feel I have left with a great amount of knowledge that can help the business immensely. I learned more than I thought I would and would like to thank Transmedia for being so helpful!"

Lucie Mills



© Transmedia . 277 Greenwich High Road London SE10 8NB  UK . 0208 269 4260
Designed by Transmedia's Web Team