Skills SQL Server DBA Database Administration: Difference between revisions

From MillerSql.com
NeilM (talk | contribs)
NeilM (talk | contribs)
Line 19: Line 19:
</div>
</div>
/indexing/statistics
/indexing/statistics
Query hints


SQL 2008 Best Practices Analyzer
SQL 2008 Best Practices Analyzer

Revision as of 17:12, 6 October 2024

Performance tuning

Used at:...

/indexing/statistics

Query hints

SQL 2008 Best Practices Analyzer

SQL Profiler / server-side traces

Capacity planning

Used at:...
  Used at: 
  Autodata

Capacity planning

SQL Licencing

Security

Used at:...

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

TEMPDB database