Skills SQL Server DBA Database Administration
Used at:...
Used at: Allen & Overy Five Guys Bluecrest Capital
Performance tuning
Used at:...
/indexing/statistics
Query hints
SQL Profiler / server-side traces
Query plans / Actual execution plans
SQL 2008 Best Practices Analyzer
Performance Dashboard
Locks, blocking, and deadlocks
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
Source directories for source files
Staging tables
ETL
ELT
Fact, dimension tables
SQL Server upgrades
Used at:...
Used at: Autodata ING Investment Management
SQL Server version upgrades & downgrades
SQL Server versions
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