SQM02 Workshop: SQL Server Maintenance and PTO Crash Course


8:00am - 5:00pm

Level: Introductory to Intermediate

Don Jones


Curriculum Director for IT Pro Content


Stuck supporting SQL Server because you're the "Microsoft person" in your shop? Not looking to become a "DBA," but still need to maintain SQL Server? Are you mainly supporting SQL Server as a back-end to a third-party application, and have no control over the application code or queries? This is the (non-hands-on) workshop for you. Longtime SQL Server instructor Don Jones brings you JUST what you need to know to keep SQL Server up and running - along with a serious look at what you can actually do (and mustn't touch) when supporting a third-party database application. Learn about performance tuning, backup and recovery, indexes and index tuning, storage optimization, and much more. It's a great way to kick off your SQL Server Live! experience, and gain the background information you'll need to really leverage other courses at the conference!

You will learn:

  • Learn key maintenance tasks
  • Automate maintenance for hands-off, worry-free operations
  • Tune indexes and storage for maximum performance