Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

SQL Server: Understanding and Using DBCC Commands

This course will teach you which DBCC commands to use to enhance your production environment in SQL Server. You'll see demos of how to use DBCC commands, along with replacement Dynamic Management Objects, as well as scenarios for when to use them.

Erin Stellato - Pluralsight course - SQL Server: Understanding and Using DBCC Commands
by Erin Stellato

What you'll learn

There are many DBCC commands available to database administrators and developers. Some are for the greater good; others can wreak havoc in a production environment. In this course, SQL Server: Understanding and Using DBCC Commands, you'll explore DBCC commands that are useful and relevant, whether you're a DBA or a developer (this course is for SQL Server 2005 and up). First, you'll cover the most basic commands and the informational commands--when to use them and how, in order to minimize impact on the solution. Next, you'll learn about the maintenance commands and how to recognize when a DBCC command has been superceded by a Dynamic Management Object, along with examples of how to use them. Finally, you'll learn about undocumented DBCC commands and go through scenarios on when to use them. By the time you're done, you'll have a greater understanding of DBCC commands and you'll be able to use those commands to optimize your environment.

Table of contents

About the author

Erin Stellato - Pluralsight course - SQL Server: Understanding and Using DBCC Commands
Erin Stellato

Erin Stellato is a Principal Consultant with SQLskills and a SQL Server MVP. She has worked as a SQL Server professional since 2003 and her interests include Internals, Performance Tuning, High Availability and Disaster Recovery. Erin is an active member of the SQL Server community as a presenter and blogger.

More Courses by Erin