Database Training Days 101: SQL Server Database Administration Best Practices with MSSQLTips

Whether you’re a new or experienced SQL Server DBA, the responsibilities can quickly become overwhelming. Proactive database administration is crucial to keep SQL Server running smoothly, but best practices aren’t always followed. In this MSSQLTips webcast, SQL Server MVP Joseph D'Antoni and Oracle ACE Janis Griffin will guide you through the essential practices you need to implement to maintain a healthy SQL Server environment. Learn what you need to do to keep the lights on and ensure your systems are optimized for high availability and performance.

Topics that will be discussed include:

• Best practices for SQL Server configuration
• The importance of backup and restore strategies
• Understanding maintenance tasks and their impact
• The role and management of TempDB
• Why you should never shrink a database
• How SQL Server version changes can affect maintenance
• High availability and cloud options for SQL Server

Speakers:

• Joseph D'Antoni, Senior Architect and SQL Server MVP at Denny Cherry and Associates Consulting
• Janis Griffin, Oracle ACE Director at Quest Software