Dba 101

Database Skills Checklist

DBA Guides

• Performance Monitor Quick Check
• Storage Performance via TSQL
• Auditing SQL Server
• Database Maintenance Checklist / Database Maintenance 2
• Analysing a SQL Database 

• Blocking
• RESTORE - FILELISTONLY / TSQL
• Orphanned Logins

Configuration

• Default Port Numbers

Shrinkfile

Security -

• Login Error Codes

DBCC

• DBCC CHECKDB ('DatabaseName') WITH NO_INFOMSGS
• DBCC CHECKDB ('DatabaseName') WITH PHYSICAL_ONLY
• DBCC UPDATEUSAGE(‘DatabaseName’)

Managing MSDB

• Delete SQL Agent Job History
• Remove Database Backup History
• Remove files over X days old