WITHOUT_ARRAY_WRAPPER needs a single-row JSON contract. Compare one object with two unwrapped objects and validate the complete generated text.
Finding the One Row That Broke Your Data Load
Trace a data load error to its source row with raw staging, TRY_CONVERT, stable row identifiers, and a rejection report that supports a safe retry.
SQL SERVER – DBA or DBD? – Database Administrator or Database Developer
My poll asked if you are a Database Administrator or Database Developer. Of 694 voters, 63.4% chose developer, so maybe DBD earns a dictionary spot.
SQL SERVER – Concat Function in SQL Server – SQL Concatenation
Is there a CONCAT function in SQL Server? An attendee said MySQL and Oracle have one. I show how the plus operator joins strings, numbers and column values.
geometry STIsEmpty: Empty Shapes Are Different From SQL NULL
geometry STIsEmpty tests whether an existing spatial instance has an empty point set. I keep that condition separate from SQL NULL. A missing database value and a present empty geometry are different inputs.
SQL SERVER – Change Database Access to Single User Mode Using SSMS
I showed before how to set single user mode with T-SQL before a backup. You can also set single user mode using SSMS, from the database properties page.
How to Practise SQL Without a Real Database
You can practise SQL with small invented tables, generated rows, and repeatable exercises without access to a company's production database.