MySQL has no ROW_NUMBER() function like SQL Server. Here are two methods for generating row number values for each row with a variable in a SELECT statement.
Querying Nested JSON Arrays With OPENJSON
Query nested JSON arrays with OPENJSON, preserve element positions, pass inner arrays with AS JSON, and handle missing or strict paths.
SQL Puzzle – A Quick Fun with Bit Wise Operator – Part 2
Part 2 of my quick fun with Bit Wise Operator puzzle uses OR. Why does SELECT 1 | 100 return 101? Leave your answer in the comments.
9 Things You Should be Doing with Your Backups – Backup Tips – SQL Server Backup Tips
Nine SQL Server Backup tips every DBA should follow, starting with the simplest one: never keep backups on the same physical drive as the database files.
Idempotent Deployment Scripts: Safe to Run Twice
Build idempotent deployment scripts with guarded schema changes, versioned data fixes, and repeat-run checks for the intended state.
Comparing Data Between Two Tables
Comparing data between two tables uses EXCEPT, full joins, and hashes, with explicit NULL and duplicate rules for trustworthy results.
SQL SERVER – Rename a Table Name Containing [ or ] in the Name – Identifier in the Table Name
My colleague renamed a table to [] by accident and sp_rename failed. Here is how to rename a table name containing [ or ] characters.






