Overview
Discover the essential tasks of SQL Server database administration in this comprehensive conference talk. Learn about the five critical responsibilities of a database administrator: setting up regular backups to safeguard your databases, performing integrity checks to detect and prevent data corruption, maintaining indexes for optimal performance, managing disk space to accommodate database growth, and implementing alerting systems to proactively identify issues. Gain insights into the importance of security and performance management, and receive valuable resources for further learning. Equip yourself with the fundamental knowledge needed to effectively care for and maintain SQL Server databases, ensuring their reliability, security, and performance.
Syllabus
BEGINNING ADMIN: THE CARE AND FEEDING OF SQL SERVER
Taught by
PASS Data Community Summit