Skills SQL Server DBA Database Administration: Difference between revisions
No edit summary |
|||
| Line 15: | Line 15: | ||
''Used at: '' | ''Used at: '' | ||
''[[Role_Autodata|Autodata]]'' | ''[[Role_Autodata|Autodata]]'' | ||
''[[Role_Bluecrest_Capital|Bluecrest Capital]]'' | |||
</div> | </div> | ||
</div> | </div> | ||
| Line 20: | Line 21: | ||
SQL 2008 Best Practices Analyzer | SQL 2008 Best Practices Analyzer | ||
SQL Profiler / server-side traces | |||
== Capacity planning == | == Capacity planning == | ||
Revision as of 16:41, 6 October 2024
Used at:...
Used at: Allen & Overy Five Guys Bluecrest Capital
Performance tuning
Used at:...
Used at: Autodata Bluecrest Capital
/indexing/statistics
SQL 2008 Best Practices Analyzer
SQL Profiler / server-side traces
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 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
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:...
Used at: MUFG Securities Autodata
Synonyms
Other
Out of hours support
Logging
Testing