SQL Server |
- RDBMS
- Client-Server
- Editions & Versions
- SQL Server Management Studio
- SQL Server Configuration Manager
|
Installing SQL Server |
- The problem is choice
- Disk Set-up
- System Databases
- Upgrading SQL Server Joins
|
Server Configuration |
- Windows Settings
- Server Settings
- Server Advanced Settings for Performance
|
Databases |
- There are always two
- File Placement
- Auto Growth
- Filegroups
|
Indexes |
- Clustered & Non-Clustered
- Primary Keys
- Heaps
- B-Tree Basics
|
The Database Objects! |
- Stored Procedures
- Triggers
- Error Handling
|
Statistics |
- Auto Update Statistics
- Criticality of Statistics
|
Data Movement |
- Backup & Restore
- Attach/Detach
- Import/Export
- SELECT INTO
- BULK INSERT
- SSIS
|
Monitoring SQL Server |
- Profiler
- Extended Events
- Performance Monitor
- DMVs
- SSIS
|
Maintenance |
- Maintenance Plans
- Scripts
- Database Mail
- Alerts
- Operators
|
Automation |
- Fragmentation
- Updating Statistics
- Check your integrity
|
Backup and Restore |
- Recovery Model, Full or Simple
- Transaction Logs
- What to do in a disaster?
- Tail of the Log
|
Security |
- Logins & Server Roles
- Database Users
- Database Objects
|
High Availability |
- Log Shipping Overview
- Clustering Overview
- AlwaysOn Overview
- Database Mirroring Overview
|