Write rerunnable deployment scripts with guarded schema changes, version records, and a dry run on a restored database copy.
SQL SERVER Management Studio and SQLCMD Mode
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
This blog post is a bit of a different post than the normal blog posts which I write as the topic of this blog post is SQL Terms vs MongoDB Terms.
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.