Skills SQL Server DBA Database Administration

From MillerSql.com
Revision as of 20:55, 7 October 2024 by NeilM (talk | contribs) (→‎Other)
Used at:...

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:...

Capacity planning

SQL Licencing

Security

Used at:...

user accounts

orphaned users

Failed logins

SQL Agent

Used at:...

SQL Agent

SQL Scheduled jobs

Alerts

Backups and restores

Used at:...

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.

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:...

SQL Server version upgrades & downgrades

SQL Server versions

SQL Server versions:

  • 2000
  • 2005
  • 2008
  • 2012
  • 2016
  • 2017

Database mirroring and log shipping

Used at:...

Database mirroring and log shipping

Transactional Replication

Transactional Replication Log Reader Distribution database Merge replication

Synonyms

Used at:...

Synonyms

Other

Out of hours support

Logging

Testing

TEMPDB database

Windows clustering. Microsoft Cluster Server.

Retrieved from ‘https://wiki.millersql.com/wiki/index.php?title=Skills_SQL_Server_DBA_Database_Administration&oldid=748’