Generate repeatable test data with a fixed RAND seed or row-number hashes, then verify identical names and amounts across runs.
SQL SERVER – Query Store Feature for Secondary Replicas
SQL Server 2022 extends the Query Store feature for secondary replicas. Here is how to enable it and what to watch before using it.
PS1 Cannot Be Loaded Because Running Scripts Is Disabled
PS1 cannot be loaded because PowerShell’s execution policy blocks scripts by default. You can set RemoteSigned, bypass the policy for one session, or choose Unrestricted as a last resort. Here is each option, and the scope to check.
Blocking Alert: A T-SQL Check for Sessions Blocked Too Long
Short blocking is normal. This check flags lock waits past a threshold and walks each chain to the session at the front of the line.
SQL SERVER – How to Move a Table into a Schema in T-SQL
If you’ve ever wondered how to move a table into a schema in T-SQL, this post is for you. One ALTER SCHEMA TRANSFER command does the job.
SQL SERVER – Fix – Error – The certificate chain was issued by an authority that is not trusted
ASP.NET Core applications can sometimes result in the error “The certificate chain was issued by an authority that is not trusted.”
BDD vs TDD: One Small Feature, Two Ways to Test It
BDD vs TDD is easy to mix up until you test the same feature both ways. This post checks one delivery rule with a unit test and then with a plain-language scenario, runs the unit test, and explains when each approach fits.