Skills SQL Server DBA Database Administration: Difference between revisions

From MillerSql.com
NeilM (talk | contribs)
NeilM (talk | contribs)
Line 101: Line 101:


Logging
Logging
Testing

Revision as of 04:41, 3 October 2024

Used at:...

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:...
  Used at: 
  Autodata

SQL Server database 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

Synonyms

Used at:...

Synonyms

Other

Out of hours support

Logging

Testing