Build JSON_OBJECT and JSON_ARRAY values in SQL Server 2022, control null handling, nest arrays, and compare rowset and aggregate output.
SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020
Indexes get fragmented as data grows. I asked my friend Tim Radney what he does then, and here are his index fragmentation next steps from the field.
MSDTC and Distributed Transactions Across Linked Servers
Understand MSDTC for linked-server transactions, inspect RPC promotion settings, diagnose coordination errors, and compare simpler designs.
SQL SERVER – Performance Statistic Collection – Notes from the Field #018
Good tuning starts with good numbers. In Notes from the Field #018, David Klee explains Performance Statistic Collection and how DBAs should gather server data.
Storing Images in varbinary(max): Size, Reads and Backups
Store images in varbinary(max), read file bytes with OPENROWSET, inspect LOB allocation, and evaluate backup and retrieval costs.
Running SQL Server on an Azure Virtual Machine
SQL Server on an Azure virtual machine keeps instance control while moving storage and hosting to Azure; learn disk, backup, and sizing checks.
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.