Skills SQL Server DBA Database Administration: Difference between revisions
| Line 99: | Line 99: | ||
SQL Server version upgrades & downgrades | SQL Server version upgrades & downgrades | ||
SQL Server versions | |||
* 2000 | |||
* 2005 | |||
* 2008 | |||
* 2012 | |||
* 2016 | |||
* 2017<br /> | |||
== Database mirroring and log shipping == | == Database mirroring and log shipping == | ||
<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;"> | <div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;"> | ||
Revision as of 09:39, 7 October 2024
Used at:...
Used at: Allen & Overy Five Guys Bluecrest Capital
Performance tuning
Used at:...
Used at: Autodata Bluecrest Capital
/indexing/statistics
Query hints
SQL Profiler / server-side traces
Query plans / Actual execution plans
SQL 2008 Best Practices Analyzer
Performance Dashboard
Capacity planning
Used at:...
Used at: Autodata
Capacity planning
SQL Licencing
Security
Used at:...
Used at: Autodata Bluecrest Capital
user accounts
orphaned users
Failed logins
SQL Agent
Used at:...
Used at: Allen & Overy ING Investment Management
SQL Agent
SQL Scheduled jobs
Alerts
Backups and restores
Used at:...
Used at: Autodata Bluecrest Capital
SQL Server database backups, differential, incremental backups, transaction log backups
SQL Server database restores
Data Migration
SQL Server upgrades
Used at:...
Used at: Autodata ING Investment Management
SQL Server version upgrades & downgrades
SQL Server versions
- 2000
- 2005
- 2008
- 2012
- 2016
- 2017
Database mirroring and log shipping
Used at:...
Used at: Autodata
Database mirroring and log shipping
Transactional Replication
Merge replication
Synonyms
Used at:...
Used at: MUFG Securities Autodata
Synonyms
Other
Out of hours support
Logging
Testing
TEMPDB database