Honestly, there is an alternative way to quickly use SSMS SQLCMD mode as a development environment, let us learn about it today.
oStress Load Test: Run Many Sessions Against SQL Server
An oStress load test runs one query from many connections at once, so you can watch SQL Server under a crowd. This post explains the main switches and runs a small first test with five connections. It also builds the same test with sqlcmd workers, for machines without oStress.
What is Transactional Replication Supported Version Matrix? – Interview Question of the Week #274
Question: What is the Transactional Replication Supported Version Matrix?
The rules for the supported versions are pretty simple and clearly written.
SQL SERVER – Blocking Tree – Identifying Blocking Chain Using SQL Scripts
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.
Forcing a Plan in Query Store and Checking That It Held
Use forcing a plan in Query Store with verified IDs, then audit force failures and runtime results every week so the fix stays useful.
Duplicate Statistics: Auto-Created Stats That Shadow Index Statistics
Find duplicate statistics on index-leading columns, compare freshness and sampling, and generate cautious DROP STATISTICS candidates.