Fix SQL Server error 3136 by checking the differential base, backup history and restore sequence. Test the matching backups in a separate database.
SQL SERVER – Performance Counter Missing: How to Get Them Back?
A friend opened PerfMon and found every SQL Server performance counter missing for his instance. Here is how we got them back.
SQL SERVER – Table Space Allocation Details using DMV
Beyond DBCC IND and EXTENTINFO, the DMV dm_db_database_page_allocations shows table space allocation details. My friend Balmukund pointed me to it.
SQL SERVER – Using Bitwise And (&) Instead of a Junction Table – Notes from the Field #053
Stuart Ainsworth shows a cool trick: using Bitwise And (&) instead of a junction table to get more performance with fewer code changes.
Azure SQL Database Wait Stats: Reading sys.dm_db_wait_stats
Read Azure SQL Database wait stats with sys.dm_db_wait_stats, identify log-rate governance, and compare resource percentages before scaling.
SQL SERVER – Unable to Restore From Backup After Detach Operation
A young guy came to me and said – “I found a bug in SQL Server Restore”. How to fix Unable to Restore From Backup After Detach Operation.
SQL SERVER – PowerShell way of Restarting SQL Server Service
Restarting SQL Server service with PowerShell is one line, and it is wrong on a named instance. The right name, -Force, and when it is really up.










