Skills SQL Server DBA Database Administration

From MillerSql.com
Revision as of 15:52, 6 October 2024 by NeilM (talk | contribs)

Performance tuning

Used at:...
  Used at: 
  Autodata

/indexing/statistics

SQL 2008 Best Practices Analyzer

Capacity planning

Used at:...
  Used at: 
  Autodata

Capacity planning

SQL Licencing

Security

Used at:...
  Used at: 
  Autodata

user accounts

orphaned users

SQL Agent

Used at:...
  Used at: 
  Allen & Overy

SQL Agent

Backups and restores

Used at:...

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

SQL Server database restores

Data Migration

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:...

Synonyms

Other

Out of hours support

Logging

Testing