Learn restoring one table by restoring a separate database copy, choosing a recovery point, and safely moving reviewed rows back.
Vertical Partitioning: Moving Rarely Used Columns Off a Hot Table
Moving rarely used columns to a side table can cut reads, or change nothing. Here is how to measure it and what it costs your writes.
Casting JSON Arrays to the vector Type for Embeddings
A cast checks the count of numbers, not the model they came from. Here is a simple staging pattern that loads good rows and reports the rest.
NT SERVICE Accounts in sysadmin: What They Are For
A security scan wants those service logins gone. Here is how to see what each one is for before you click Delete.
MySQL – Introduction to User Defined Variables
MySQL user defined variables let you store a value and use it later in your query, with no data type to declare. Here is how to set and read them.
SQL SERVER – Merge Two Columns into a Single Column
A reader wanted to merge two columns into a single column that lists all values from both. Here is the simple query I suggested for the task.
SQL SERVER – Parsing SSIS Catalog Messages – Notes from the Field #030
The SSIS Catalog captures a lot of cool information by default. Andy Leonard shares the query he uses for parsing SSIS Catalog messages in SSISDB.