Skills SQL Server DBA Database Administration: Difference between revisions
| Line 109: | Line 109: | ||
Duplicate rows | Duplicate rows | ||
File and data concatenation (joining of the content of one file with the next) | |||
== SQL Server upgrades == | == SQL Server upgrades == | ||
Revision as of 15:44, 7 October 2024
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
SQL Agent
Used at: Allen & Overy ING Investment Management
SQL Agent
SQL Scheduled jobs
Alerts
Backups and restores
Used at: Autodata Bluecrest Capital
SQL Server database backups, differential, incremental backups, transaction log backups
SQL Server database restores
Moving databases by detaching, moving, and reattaching their .mdf and .ldf files.
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
Database mirroring and log shipping
Used at: Autodata
Database mirroring and log shipping
Transactional Replication
Merge replication
Synonyms
Used at: MUFG Securities Autodata
Synonyms
Other
Out of hours support
Logging
Testing
TEMPDB database