Question: How to Get Details of All files Associated with Database from MDF? Let us learn about the DBCC command DBCC command dbcc checkprimaryfile.
Writing Rerunnable Deployment Scripts for Database Changes
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.