Skills SQL Server DBA Database Administration: Difference between revisions

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


== Performance tuning ==
== Performance tuning ==
<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
  <div>''Used at:...''</div>
  <div class="mw-collapsible-content">
  ''Used at: ''
  ''[[Role_Autodata|Autodata]]''
  </div>
</div>
/indexing/statistics
/indexing/statistics



Revision as of 04:37, 3 October 2024

Used at:...

Performance tuning

Used at:...
  Used at: 
  Autodata

/indexing/statistics

SQL 2008 Best Practices Analyzer

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