SQL Server 2016 lets you set MAXDOP on DBCC checks like CHECKDB. Here is how this DBCC Command enhancement works and how to use it.
Identify Used Space in Log File- Interview Question of the Week #090
Question: How to identify Used Space in Log File?
Answer: Use following command to display used log file size and total used space in the log file.
Automated Restore Tests: Proving Backups Work Every Week
Schedule restore tests that select current backups, move files to an isolated server, run CHECKDB, record failures, and rotate databases.
SQL SERVER – What is DBCC TRACEON and DBCC TRACEOFF messages in ERRORLOG?
A client asked about DBCC TRACEON and DBCC TRACEOFF messages in the ERRORLOG. Here is what they mean, using trace flag 1222 for deadlock logging as an example.
Interview Question of the Week #033 – How to Invalidate Procedure Cache of SQL Server?
Clear procedure cache at the narrowest useful scope, remove one plan handle, and compare sp_recompile with statement recompilation.
Page Verify CHECKSUM and Why It Matters
Page verify CHECKSUM detects altered database pages on read; inspect old settings, understand new writes, and review suspect pages.
BACKUP WITH CHECKSUM: What It Checks and What It Cannot
Use WITH CHECKSUM for backups, inspect checksum history, verify backup media, and understand why restored CHECKDB tests are still needed.