SQM02 Workshop: Maintaining SQL Server for Non-DBAs

11/17/2014

8:00am - 5:00pm

Don Jones

MVP

Curriculum Director for IT Pro Content

Pluralsight

Learn about performance tuning, backup and recovery, indexes and index tuning, storage optimization, and much more.

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 to 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