Skills SQL Server DBA Database Administration

Used at:...

  Used at: 
  Allen & Overy
  Five Guys
  Bluecrest Capital

Performance tuning

Used at:...

  Used at: 
  Autodata
  Bluecrest Capital

/indexing/statistics

Query hints

SQL Profiler / server-side traces

Query plans / Actual execution plans

SQL 2008 Best Practices Analyzer

Performance Dashboard

Capacity planning

Used at:...

  Used at: 
  Autodata

Capacity planning

SQL Licencing

Security

Used at:...

  Used at: 
  Autodata
  Bluecrest Capital

user accounts

orphaned users

Failed logins

SQL Agent

Used at:...

  Used at: 
  Allen & Overy

SQL Agent

Backups and restores

Used at:...

  Used at: 
  Autodata
  Bluecrest Capital

SQL Server database backups, differential, incremental backups, transaction log backups

SQL Server database restores

SQL Server upgrades

Used at:...

  Used at: 
  Autodata

SQL Server version upgrades & downgrades

Database mirroring and log shipping

Used at:...

  Used at: 
  Autodata

Database mirroring and log shipping

Transactional Replication

Merge replication

Synonyms

Used at:...

  Used at: 
  MUFG Securities
  Autodata

Synonyms

Other

Out of hours support

Logging

Testing

TEMPDB database