You can verify a migrated database with two numbers per table: a row count and a checksum. In this test the row counts matched in both copies while the checksums exposed a changed price and a changed city. It also shows the case change that one checksum function missed and another caught.
Splitting DBCC CHECKDB Across the Week for a Large Database
Keep a large database under regular integrity checks by splitting DBCC CHECKDB work across seven nights and auditing coverage.
PowerShell – How to Install dbatools?
dbatools installs as a PowerShell module on a Windows management machine. Rob Sewell, known as DBA with Beard, introduced me to it.
Faster Backups With BUFFERCOUNT and MAXTRANSFERSIZE, Measured
Measure faster backups by changing BUFFERCOUNT, MAXTRANSFERSIZE, and backup stripes one at a time while tracking speed and memory.
JSON Column Index in SQL Server: Index One Property
A JSON column index is one of the first tools a DBA needs when documents arrive in SQL Server. This test stores 100,000 recipes as JSON, searches one property with no index, then indexes it through a computed column. It also shows the cast that quietly breaks the match and how missing keys behave.
Finding User Objects in master Created by Accident
Find user objects in master, inspect their purpose and dependencies, and prepare a safe move without removing deliberate server helpers.
Finding Which Indexes Use a Custom Fill Factor Setting
Find indexes with a custom fill factor, compare their page counts, and review one rebuild without changing the server-wide setting.







