SQL Server related posts on this site.
Server Administration
- Authentication Modes
- Basic Database Configuration
- Compression
- Database Console Commands (DBCC)
- Detach/Attach Database
- File Groups
- Instance Configuration and Management
- Moving Database Files
- Partitioning
- sp_configure
- Transaction Logs
- Concurrency
- Troubleshooting
- Auditing
- Basic Backups
- Basic Restores
- Index Fragmentation
- Execution Plans and Indexes
- Query Tuning (Basic Approach)
- Database Mail
- SQL Server Agent (Jobs)
- Exporting and Importing Data
- High Availability (HA) and Disaster Recovery (DR) Overview
- PowerShell Introduction
- Maintenance Plans
- Patch SQL Server Always On Cluster