Workshops, Monitoring, Maintaining, and Tuning, For Database Administrators, For IT Professionals

SQM01 Workshop: Being a SQL Server DBA - Even If You'd Rather Not


8:00AM - 12:00PM

Level: Introductory to Intermediate

Don Jones


Curriculum Director for IT Pro Content


Are you stuck being a database administrator just because you’re the “Microsoft person” in your environment? Less concerned with writing queries than just maintaining SQL Server and getting back to your “real” job? Congratulations: You’re a Reluctant DBA, and this half-day workshop is made for you! Microsoft expert, author, and MVP award recipient Don Jones introduces you to everything you’ll need to know to make SQL Server work better, longer, and faster. You’ll learn how SQL works under the hood, learn the basics of the T-SQL query language, and learn how to perform critical tasks like backup and recovery. You’ll learn about core performance troubleshooting and tuning techniques, including how to use SQL Profiler and the Database Engine Tuning Advisor. You’ll learn about your options for high availability, and peek into techniques and technologies for multi-server administration. Administering a SQL Server that supports a prepackaged application? You’ll also learn what’s generally safe and unsafe to do, so that you can focus your efforts on where they’ll make the most difference.

This is not a hands-on workshop and power for laptops will not be provided in the session room.