Skills SQL Server DBA Database Administration
Used at: Allen & Overy Five Guys Bluecrest Capital
Performance tuning
/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: Autodata
Capacity planning
SQL Licencing
Security
user accounts
orphaned users
Failed logins
Standard vs integrated security
SQL Agent
Used at: Allen & Overy ING Investment Management
SQL Agent
SQL Scheduled jobs
SQL Maintenance tasks / cleanups
Alerts
Backups and restores
Used at: Autodata Bluecrest Capital
SQL Server database backups, differential, incremental backups, transaction log backups, simple vs full recovery models.
SQL Server database restores
Moving databases by detaching, moving, and reattaching their .mdf and .ldf files.
Disaster recovery
Business Continuity
Data Migration
Source directories for source files
Staging tables
ETL
ELT
Fact, dimension tables
Trigger files
Header rows (in files).
Duplicate rows
File and data concatenation (joining of the content of one file with the next)
SQL Server upgrades
Used at: Autodata ING Investment Management
SQL Server version upgrades & downgrades
SQL Server versions
SQL Server versions:
- 2000
- 2005
- 2008
- 2012
- 2016
- 2017
SQL Server named instances
Database mirroring and log shipping
Used at: Autodata
Database mirroring and log shipping
Transactional Replication
Transactional Replication
Articles (tables being published)
Log Reader
Distribution database
Merge replication
Subscription database
Snapshots
SkipErrors 20598 flag
distribution.dbo.MSrepl_errors table
Suspect state (database)
Synonyms
Used at: MUFG Securities Autodata
Synonyms
Other
Out of hours support
Logging
Testing
TEMPDB database
Windows clustering. Microsoft Cluster Server.