Learn restoring one table by restoring a separate database copy, choosing a recovery point, and safely moving reviewed rows back.
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.
SELECT 7 & 7 or 7 ^ 7: Bitwise XOR, AND and OR on Integers
Understand bitwise XOR, AND and OR in T-SQL, test and change integer flags, explain two sevens, and compare the newer bit functions.
Memory-Optimized Table Variables
Memory-optimized table variables can avoid tempdb work, but they need a filegroup, indexed table type, memory budget, and workload tests.
SQL SERVER – Fix: Error: Compatibility Level Drop Down is Empty
Fix it when the compatibility level drop down is empty in database properties, with SQL Server 2012 and 2014 on one machine. Cause and fix.
UNISTR and Unicode Escapes in SQL Server 2025
Build Unicode strings with UNISTR in SQL Server 2025, compare NCHAR, and preserve accented letters, Hindi text, and emoji in storage.
SQL SERVER – DMV to Identify Incremental Statistics – Performance improvements in SQL Server 2014 – Part 3
Part 3 of my series on SQL Server 2014 performance improvements: a DMV to identify incremental statistics, after the basics and a simple example.