In Notes from the Field #031, John Sterrett explains Planned and Unplanned Availability Group failovers in AlwaysOn, a topic that confuses many DBAs.
SQL SERVER – Contest Winner – What Next on SQL in Sixty Seconds – Poll Result
The poll for the next SQL in Sixty Seconds videos is closed, and most readers want performance tuning. Here are the results and the contest winner.
Restoring One Table: Restore a Copy and Move the Rows Back
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.