DBCC Commands in SQL Server

Description

DBCC (Database Console Commands) were formerly known as Database Consistency Checkers. As many new commands were added to it, now DBCC can check beyond the integrity and consistency of the databases. Thus the name Database Console Commands. The DBCC acts not only at the database level but also at the instance level. Many of the DBCC needs sysadmin or db_owner permissions. There are around 30 commands in SQL Server 2014 which are documented. This lab is divided into four exercises. In the first exercise, we will learn DBCC informational commands. In the second exercise, we will learn DBCC validation commands. In the third exercise, we will learn BCC maintenance commands. In the fourth and final exercise, we will learn DBCC miscellaneous commands.

Exercise 1: DBCC Informational Commands
Exercise 2: DBCC Validation Commands
Exercise 3: DBCC Maintenance Commands
Exercise 4: DBCC Miscellaneous Commands