Skills SQL Server DBA Database Administration: Difference between revisions

Latest revision as of 18:45, 11 October 2024

Used at:...

  Used at: 
  Allen & Overy
  Five Guys
  Bluecrest Capital

Performance tuning

Used at:...

  Used at: 
  Autodata
  Bluecrest Capital
  ING Investment Management

/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
  ING Investment Management
  Autotrader

user accounts

orphaned users

Failed logins

Standard vs integrated security

SQL Agent

Used at:...

  Used at: 
  Allen & Overy
  ING Investment Management

SQL Agent

SQL Scheduled jobs

SQL Maintenance tasks / cleanups

Alerts

Backups and restores

Used at:...

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

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

  Used at: 
  Autodata

Database mirroring and log shipping

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

  Used at: 
  MUFG Securities
  Autodata

Synonyms

Other

Out of hours support

Logging

Testing

TEMPDB database

Windows clustering. Microsoft Cluster Server.

@@ Line 1: / Line 1: @@
-SQL Server performance tuning/indexing/statistics
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_Allen_Overy|Allen & Overy]]''
+   ''[[Role_Five_Guys|Five Guys]]''
+   ''[[Role_Bluecrest_Capital|Bluecrest Capital]]''
+   </div>
+</div>
-Security/user accounts
+== Performance tuning ==
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_Autodata|Autodata]]''
+   ''[[Role_Bluecrest_Capital|Bluecrest Capital]]''
+   ''[[Role_ING_Investment_Management|ING Investment Management]]''
+   </div>
+</div>
+/indexing/statistics
-Logging
+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 ==
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_Autodata|Autodata]]''
+   </div>
+</div>
+Capacity planning
+SQL Licencing
+== Security ==
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_Autodata|Autodata]]''
+   ''[[Role_Bluecrest_Capital|Bluecrest Capital]]''
+   ''[[Role_ING_Investment_Management|ING Investment Management]]''
+   ''[[Role_Autotrader|Autotrader]]''
+   </div>
+</div>
+user accounts
+orphaned users
+Failed logins
+Standard vs integrated security
+== SQL Agent ==
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_Allen_Overy|Allen & Overy]]''
+   ''[[Role_ING Investment_Management|ING Investment Management]]''
+   </div>
+</div>
+SQL Agent
+SQL Scheduled jobs
+SQL Maintenance tasks / cleanups
+Alerts
+== Backups and restores ==
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_Autodata|Autodata]]''
+   ''[[Role_Bluecrest_Capital|Bluecrest Capital]]''
+   </div>
+</div>
+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
-backups and restores
+File and data concatenation (joining of the content of one file with the next)
+== SQL Server upgrades ==
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_Autodata|Autodata]]''
+   ''[[Role_ING_Investment_Management|ING Investment Management]]''
+   </div>
+</div>
 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 ==
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_Autodata|Autodata]]''
+   </div>
+</div>
+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 ==
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_MUFG_Securities|MUFG Securities]]''
+   ''[[Role_Autodata|Autodata]]''
+   </div>
+</div>
+Synonyms
+== Other ==
 Out of hours support
+Logging
+Testing
+TEMPDB database
+Windows clustering. Microsoft Cluster Server.