Over time, SQL has evolved and offers two distinct styles for performing JOIN operations: the old-style comma-separated join and the more modern explicit JOIN syntax.
SQL SERVER – Stripping HTML Tags from Text
In this blog post, we’ll explore a method for stripping these HTML tags from your text data using SQL Server. Let us explore the post.
Repeatable Test Data With a Fixed Random Seed
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.
SQL SERVER – Resolving the “ps1 cannot be loaded because running scripts is disabled” Error
When with PowerShell scripts, occasionally run into an error saying “ps1 cannot be loaded because running scripts is disabled on this system”.
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.