FOR JSON PATH omits NULL properties by default. Compare INCLUDE_NULL_VALUES with missing properties and empty strings in a complete output example.
Tagging With a Many-to-Many Table: Storing and Querying Hashtags
Store hashtags in a tag and bridge table, normalize input, query any or all requested tags, and count weekly trends without scans.
SQL SERVER – Soft Delete – IsDelete Column – Your Opinion
Soft delete with an IsDelete column marks rows as deleted but keeps them. Michael J Swart dislikes it, and I agree. I share a similar story and ask your opinion.
Data, Log and tempdb File Placement: Checking Where Everything Lives
Check file placement for data, logs, and tempdb, inspect volume free space, and plan a Windows file move with a verified recovery path.
SQLAuthority News – Fathers and Daughters
My daughter turns one today and I feel so lucky to be a father of daughter. A few words on the special bond between fathers and daughters, with her photos.
Keeping a Change Log for Every Database
A change log for every database records what changed, when, why, and by whom, with a simple table and a habit of updating it.
Return Codes: Keep Procedure Status Separate From Data
Return codes carry procedure status separately from application values. This private demonstration compares result sets, captured output and omitted OUTPUT. It also separates an optional no-work request from a genuine raised error.