Skills SQL Server DBA Database Administration: Difference between revisions

From MillerSql.com
NeilM (talk | contribs)
No edit summary
NeilM (talk | contribs)
No edit summary
Line 63: Line 63:
   </div>
   </div>
</div>
</div>
SQL Server database backups
SQL Server database backups, differential, incremental backups, transaction log backups


SQL Server database restores
SQL Server database restores

Revision as of 15:47, 6 October 2024

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, 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

Synonyms

Used at:...

Synonyms

Other

Out of hours support

Logging

Testing