SQL Server Maintenance Plans Webinar
Kathleen Long, Senior SQL Server DBA
Most DBA’s know you need to be doing some form of maintenance on your databases: backups, index rebuilding\reorganization, update statistics, integrity checks, and system cleanup. SQL Server offers some basic tasks to complete this needed maintenance. The session will cover setting up a maintenance plan including the tasks, schedules, and logging. From there, we will dive deeper into the basic task, find out what is going on behind the scene, and discuss when it is ok to use them and when you should create your own.
At the end of the session, you will know how to create a maintenance plan, how to log results and keep a history of success or failures when you should use what SQL Server has provided and when you should create your own plan.
This presentation has been presented at SQLSaturday #183, Rocky Mountain User Group Training days 2013, and Denver SQL Server User Group.
Our presenter, Kathleen Meadows, has been working with SQL Server since 1998 starting with SQL Server 6.5 up to the latest and greatest. Over the years, Kat has worked in many different environments from manufacturing to dot-coms, and military to government institutions and is now back in the private sector. Currently, as a Senior DBA at XTIVIA, she is focused on monitoring SQL Server installations and troubleshooting performance issues. Kat is also the President of the Colorado Springs SQL Server User Group. She possesses a Bachelor’s degree in Managing Information Systems from Colorado Technical University.