Whenever I end up on a situation where we have lots of blocking issues with my client, I depend on the script of the Blocking Tree.
SQL Terms vs MongoDB Terms: A Practical Glossary
SQL terms vs MongoDB terms trip up teams that use both products. This glossary maps tables, collections, rows, documents and fields, shows tested SQL Server queries beside the mongosh equivalents, and marks where the vocabulary stops matching.
SQL SERVER – Scrollbar in the Middle – Bugs Fixed by SSMS Team
SSMS 18.5 fixed the Database Properties scrollbar that opened in the middle. Read the funny true story, see the original evidence, and enjoy the fix.
Free Edition Product Key: Developer, Express and Evaluation
A free edition product key tells SQL Server setup which free edition to install: Evaluation, Developer or Express. This post lists the three codes, shows how to pass one to an unattended install and how to check the edition afterwards. It also explains when an Evaluation instance ends.
Remove Extra Log File in SQL Server: Fix Error 5042
To remove extra log file members, SQL Server needs the files to hold no active log. When one does, ALTER DATABASE REMOVE FILE fails with Msg 5042. This post builds a database with two log files, reproduces the error, shows which VLFs keep the file busy and frees it with log backups. It also explains why the file stays offline until the next log backup.
SQL SERVER – Multiple Log Files to Your Databases – Not Needed
I was asked a very interesting question by their DBA about log files. The question was – Is there ever need of multiple log files in SQL Server?
Survey Answers: A Table Design for Questions and Responses
Store survey answers as typed rows instead of one column per question. Then break the design on purpose to see what it blocks and what it cannot.