56,966 blogs · [ { "id": "01a0d2dd-2a53-72dd-99da-d5c0f47e46d2", "title": "Plansplaining part 35. A bug in Table Spool and an invisible property on Stream Aggregate", "url": "https://sqlserverfast.com/blog/hugo/2026/09/plansplaining-part-35-a-bug-in-table-spool-and-an-invisible-property-on-stream-aggregate/", "published_at": "2026-09-16T10:08:24+00:00" }, { "id": "01a087e4-bbaf-7233-aed7-ed30fc261285", "title": "A new treatment starts", "url": "https://sqlserverfast.com/blog/hugo/2026/09/a-new-treatment-starts/", "published_at": "2026-09-01T16:19:09+00:00" }, { "id": "01a087e4-bbaf-7233-aed7-ed30fc4bbc10", "title": "Storage structures 6 – JSON indexes", "url": "https://sqlserverfast.com/blog/hugo/2026/07/storage-structures-6-json-indexes/", "published_at": "2026-07-17T10:54:04+00:00" }, { "id": "01a087e4-bbb0-7358-aeb7-1b7e223eaaed", "title": "Slow progress is better than no progress", "url": "https://sqlserverfast.com/blog/hugo/2026/07/slow-progress-is-better-than-no-progress/", "published_at": "2026-07-16T11:20:01+00:00" }, { "id": "01a087e4-bbb0-7358-aeb7-1b7e22582ba3", "title": "Vimeo messed up, and you and I get the consequences", "url": "https://sqlserverfast.com/blog/hugo/2026/07/vimeo-messed-up-and-you-and-i-get-the-consequences/", "published_at": "2026-07-11T11:07:06+00:00" }, { "id": "01a087e4-bbb0-7358-aeb7-1b7e225b3a26", "title": "T-SQL Tuesday 200 – Query red flags", "url": "https://sqlserverfast.com/blog/hugo/2026/07/t-sql-tuesday-200-query-red-flags/", "published_at": "2026-07-07T14:00:16+00:00" }, { "id": "01a087e4-bbb0-7358-aeb7-1b7e22c2a424", "title": "Plansplaining part 34 – XML indexes revisited", "url": "https://sqlserverfast.com/blog/hugo/2026/06/plansplaining-part-34-xml-indexes-revisited/", "published_at": "2026-06-30T15:43:38+00:00" }, { "id": "01a087e4-bbb0-7358-aeb7-1b7e2320f945", "title": "Change is the only constant", "url": "https://sqlserverfast.com/blog/hugo/2026/06/change-is-the-only-constant/", "published_at": "2026-06-27T14:12:18+00:00" }, { "id": "01a087e4-bbb0-7358-aeb7-1b7e2363d236", "title": "Another crazy week", "url": "https://sqlserverfast.com/blog/hugo/2026/06/another-crazy-week/", "published_at": "2026-06-19T19:36:41+00:00" }, { "id": "01a087e4-bbb0-7358-aeb7-1b7e23de8396", "title": "Storage structures 5 – XML indexes", "url": "https://sqlserverfast.com/blog/hugo/2026/06/storage-structures-5-xml-indexes/", "published_at": "2026-06-16T11:34:32+00:00" }, { "id": "01a087e4-bbb0-7358-aeb7-1b7e247e04f4", "title": "Video training update 2026", "url": "https://sqlserverfast.com/blog/hugo/2026/06/video-training-update-2026/", "published_at": "2026-06-13T14:11:56+00:00" }, { "id": "01a0d1d2-d261-720a-9a7b-6ed393023951", "title": "Optional Parameter Plan Optimization", "url": "https://sqlserverfast.com/blog/hugo/2026/06/optional-parameter-plan-optimization/", "published_at": "2026-06-06T10:16:06+00:00" }, { "id": "01a0d1d2-d261-720a-9a7b-6ed3937f0ac6", "title": "Storage structures 4 – Memory-optimized columnstore", "url": "https://sqlserverfast.com/blog/hugo/2026/05/storage-structures-4-memory-optimized-columnstore/", "published_at": "2026-05-27T09:04:00+00:00" }, { "id": "01a0d1d2-d261-720a-9a7b-6ed3942a4422", "title": "Parameter Sensitive Plan Optimization", "url": "https://sqlserverfast.com/blog/hugo/2026/05/parameter-sensitive-plan-optimization/", "published_at": "2026-05-23T09:08:14+00:00" }, { "id": "01a0d1d2-d261-720a-9a7b-6ed3943d7509", "title": "Back on track", "url": "https://sqlserverfast.com/blog/hugo/2026/05/back-on-track/", "published_at": "2026-05-19T12:08:16+00:00" }, { "id": "01a0d1d2-d261-720a-9a7b-6ed394dd00a6", "title": "Between despair and hope", "url": "https://sqlserverfast.com/blog/hugo/2026/05/between-despair-and-hope/", "published_at": "2026-05-09T12:37:13+00:00" }, { "id": "01a0d1d2-d261-720a-9a7b-6ed395c65f3e", "title": "Request for help – video hosting", "url": "https://sqlserverfast.com/blog/hugo/2026/04/request-for-help-video-hosting/", "published_at": "2026-04-21T16:43:10+00:00" }, { "id": "01a0d1d2-d261-720a-9a7b-6ed3965a454d", "title": "Bad parameter sniffing, what is it and what can you do about it", "url": "https://sqlserverfast.com/blog/hugo/2026/04/bad-parameter-sniffing-what-is-it-and-what-can-you-do-about-it/", "published_at": "2026-04-13T17:26:24+00:00" }, { "id": "01a0d1d2-d261-720a-9a7b-6ed397167b2b", "title": "Home for now", "url": "https://sqlserverfast.com/blog/hugo/2026/04/home-for-now/", "published_at": "2026-04-09T11:24:12+00:00" }, { "id": "01a0d1d2-d261-720a-9a7b-6ed39802d8f6", "title": "Ups and downs", "url": "https://sqlserverfast.com/blog/hugo/2026/03/ups-and-downs/", "published_at": "2026-03-31T18:59:16+00:00" }, { "id": "01a0d1d3-3177-704d-bb9a-2fd76c950ecd", "title": "To be where I need to be", "url": "https://sqlserverfast.com/blog/hugo/2026/03/to-be-where-i-need-to-be/", "published_at": "2026-03-23T19:54:18+00:00" }, { "id": "01a0d1d3-3177-704d-bb9a-2fd76d45cf0f", "title": "SQL injection, and how to prevent it", "url": "https://sqlserverfast.com/blog/hugo/2026/03/sql-injection-and-how-to-prevent-it/", "published_at": "2026-03-16T19:34:09+00:00" }, { "id": "01a0d1d3-3177-704d-bb9a-2fd76e231ec2", "title": "Back in hospital", "url": "https://sqlserverfast.com/blog/hugo/2026/03/back-in-hospital/", "published_at": "2026-03-15T18:59:00+00:00" }, { "id": "01a0d1d3-3177-704d-bb9a-2fd76e88b992", "title": "Return to the diary", "url": "https://sqlserverfast.com/blog/hugo/2026/03/return-to-the-diary/", "published_at": "2026-03-05T17:50:46+00:00" }, { "id": "01a0d1d3-3177-704d-bb9a-2fd76f657a03", "title": "Optimized Locking part 2: Lock After Qualification", "url": "https://sqlserverfast.com/blog/hugo/2026/02/optimized-locking-part-2-lock-after-qualification/", "published_at": "2026-02-26T15:52:32+00:00" }, { "id": "01a0d1d3-3177-704d-bb9a-2fd7704a4fd1", "title": "Video training update", "url": "https://sqlserverfast.com/blog/hugo/2026/02/video-training-update/", "published_at": "2026-02-22T15:05:23+00:00" }, { "id": "01a0d1d3-3177-704d-bb9a-2fd770fc5052", "title": "Precon, precon, precon", "url": "https://sqlserverfast.com/blog/hugo/2026/02/precon-precon-precon/", "published_at": "2026-02-15T13:00:16+00:00" }, { "id": "01a0d1d3-3177-704d-bb9a-2fd7717c39c0", "title": "Storage structures 3 – Memory-optimized", "url": "https://sqlserverfast.com/blog/hugo/2026/02/storage-structures-3-memory-optimized/", "published_at": "2026-02-13T17:35:28+00:00" }, { "id": "01a0d1d3-3177-704d-bb9a-2fd771c32d8b", "title": "Optimized Locking part 1: Transaction ID Locking", "url": "https://sqlserverfast.com/blog/hugo/2026/02/optimized-locking-part-1-transaction-id-locking/", "published_at": "2026-02-12T15:56:32+00:00" }, { "id": "01a0d1d3-3177-704d-bb9a-2fd77250be16", "title": "T-SQL Tuesday 195 – Code that aged well", "url": "https://sqlserverfast.com/blog/hugo/2026/02/t-sql-tuesday-195-code-that-aged-well/", "published_at": "2026-02-10T13:16:56+00:00" }, { "id": "01a0d1d3-763e-7306-a648-030d1b828537", "title": "Rowgoals, part 3: When rowgoals backfire", "url": "https://sqlserverfast.com/blog/hugo/2026/02/rowgoals-part-3-when-rowgoals-backfire/", "published_at": "2026-02-02T11:14:53+00:00" }, { "id": "01a0d1d3-763e-7306-a648-030d1b883183", "title": "Storage structures 2 – Columnstore", "url": "https://sqlserverfast.com/blog/hugo/2026/01/storage-structures-2-columnstore/", "published_at": "2026-01-30T16:07:14+00:00" }, { "id": "01a0d1d3-763e-7306-a648-030d1c5f8478", "title": "Rowgoals, part 2: Rowgoals in unexpected places", "url": "https://sqlserverfast.com/blog/hugo/2026/01/rowgoals-part-2-rowgoals-in-unexpected-places/", "published_at": "2026-01-25T12:56:47+00:00" }, { "id": "01a0d1d3-763e-7306-a648-030d1c885b5c", "title": "Rowgoals, part 1: How do rowgoals work?", "url": "https://sqlserverfast.com/blog/hugo/2026/01/rowgoals-part-1-how-do-rowgoals-work/", "published_at": "2026-01-17T13:38:40+00:00" }, { "id": "01a0d1d3-763e-7306-a648-030d1d2f72ac", "title": "Storage structures 1 – On-disk rowstore", "url": "https://sqlserverfast.com/blog/hugo/2026/01/storage-structures-1-on-disk-rowstore/", "published_at": "2026-01-15T15:00:12+00:00" }, { "id": "01a0d1d3-763e-7306-a648-030d1de4db0a", "title": "Self-promo: Precon opportunities", "url": "https://sqlserverfast.com/blog/hugo/2026/01/self-promo-precon-opportunities/", "published_at": "2026-01-14T11:49:34+00:00" }, { "id": "01a0d1d3-763e-7306-a648-030d1ec0fd35", "title": "Problems purchasing videos?", "url": "https://sqlserverfast.com/blog/hugo/2026/01/problems-purchasing-videos/", "published_at": "2026-01-10T13:18:42+00:00" }, { "id": "01a0d1d3-763e-7306-a648-030d1ec5ca17", "title": "A new experiment for 2026", "url": "https://sqlserverfast.com/blog/hugo/2026/01/a-new-experiment-for-2026/", "published_at": "2026-01-01T12:18:31+00:00" }, { "id": "01a0d1d3-763e-7306-a648-030d1f45753f", "title": "A deep dive into hash tables, part 4", "url": "https://sqlserverfast.com/blog/hugo/2025/12/a-deep-dive-into-hash-tables-part-4/", "published_at": "2025-12-23T14:50:20+00:00" }, { "id": "01a0d1d3-763e-7306-a648-030d2040a19d", "title": "T-SQL Tuesday 191 – String parsing (and why I hate intelligent keys)", "url": "https://sqlserverfast.com/blog/hugo/2025/10/t-sql-tuesday-191-string-parsing-and-why-i-hate-intelligent-keys/", "published_at": "2025-10-21T14:00:36+00:00" }, { "id": "01a0d1d3-bb3f-727c-b84d-f6f10a27a176", "title": "Black Friday 2025", "url": "https://sqlserverfast.com/blog/hugo/2025/10/black-friday-2025/", "published_at": "2025-10-11T13:23:11+00:00" }, { "id": "01a0d1d3-bb3f-727c-b84d-f6f10b20996e", "title": "A deep dive into hash tables, part 3", "url": "https://sqlserverfast.com/blog/hugo/2025/09/a-deep-dive-into-hash-tables-part-3/", "published_at": "2025-09-27T15:45:53+00:00" }, { "id": "01a0d1d3-bb3f-727c-b84d-f6f10b24a4bd", "title": "T-SQL Tuesday 190 – Mastering a technical skill", "url": "https://sqlserverfast.com/blog/hugo/2025/09/t-sql-tuesday-190-mastering-a-technical-skill/", "published_at": "2025-09-09T14:00:51+00:00" }, { "id": "01a0d1d3-bb3f-727c-b84d-f6f10b67e015", "title": "Video training update 2025", "url": "https://sqlserverfast.com/blog/hugo/2025/09/video-training-update-2025/", "published_at": "2025-09-06T15:07:37+00:00" }, { "id": "01a0d1d3-bb3f-727c-b84d-f6f10c59e6dc", "title": "A deep dive into hash tables, part 2", "url": "https://sqlserverfast.com/blog/hugo/2025/08/a-deep-dive-into-hash-tables-part-2/", "published_at": "2025-08-30T13:15:25+00:00" }, { "id": "01a0d1d3-bb3f-727c-b84d-f6f10cc58533", "title": "A deep dive into hash tables, part 1", "url": "https://sqlserverfast.com/blog/hugo/2025/08/a-deep-dive-into-hash-tables-part-1/", "published_at": "2025-08-14T11:11:28+00:00" }, { "id": "01a0d1d3-bb3f-727c-b84d-f6f10cf203e5", "title": "T-SQL Tuesday 183 – Permission hell", "url": "https://sqlserverfast.com/blog/hugo/2025/02/t-sql-tuesday-183-permission-hell/", "published_at": "2025-02-11T15:00:56+00:00" }, { "id": "01a0d1d3-bb3f-727c-b84d-f6f10d496cd7", "title": "T-SQL Tuesday 182 – Integrity", "url": "https://sqlserverfast.com/blog/hugo/2025/01/t-sql-tuesday-182-integrity/", "published_at": "2025-01-15T14:23:00+00:00" }, { "id": "01a0d1d3-bb3f-727c-b84d-f6f10d60437c", "title": "T-SQL Tuesday 181 – Amazing announcements", "url": "https://sqlserverfast.com/blog/hugo/2024/12/t-sql-tuesday-181-amazing-announcements/", "published_at": "2024-12-10T15:00:49+00:00" }, { "id": "01a0d1d3-bb3f-727c-b84d-f6f10d679a24", "title": "T-SQL Tuesday 180 – The enemy of good?", "url": "https://sqlserverfast.com/blog/hugo/2024/11/t-sql-tuesday-180-the-enemy-of-good/", "published_at": "2024-11-12T15:00:51+00:00" }, { "id": "01a0d1d3-f98a-71ff-8258-8d9904cf2e3a", "title": "Black Friday again", "url": "https://sqlserverfast.com/blog/hugo/2024/10/black-friday-again/", "published_at": "2024-10-13T10:43:08+00:00" }, { "id": "01a0d1d3-f98a-71ff-8258-8d9905473496", "title": "T-SQL Tuesday 178 – Misleading data in Query Store", "url": "https://sqlserverfast.com/blog/hugo/2024/09/t-sql-tuesday-178-misleading-data-in-query-store/", "published_at": "2024-09-10T14:00:22+00:00" }, { "id": "01a0d1d3-f98a-71ff-8258-8d99062cef41", "title": "Plansplaining part 33 – Fast forward cursors", "url": "https://sqlserverfast.com/blog/hugo/2024/08/plansplaining-part-33-fast-forward-cursors/", "published_at": "2024-08-30T11:32:27+00:00" }, { "id": "01a0d1d3-f98a-71ff-8258-8d99070756e4", "title": "Plansplaining part 32 – Keyset cursors", "url": "https://sqlserverfast.com/blog/hugo/2024/06/plansplaining-part-32-keyset-cursors/", "published_at": "2024-06-21T15:43:03+00:00" }, { "id": "01a0d1d3-f98a-71ff-8258-8d9907159684", "title": "Execution plan training around the world", "url": "https://sqlserverfast.com/blog/hugo/2024/06/execution-plan-training-around-the-world/", "published_at": "2024-06-16T12:39:22+00:00" }, { "id": "01a0d1d3-f98a-71ff-8258-8d9907fb497e", "title": "Plansplaining part 31 – Dynamic cursors", "url": "https://sqlserverfast.com/blog/hugo/2024/06/plansplaining-part-31-dynamic-cursors/", "published_at": "2024-06-03T14:41:49+00:00" }, { "id": "01a0d1d3-f98a-71ff-8258-8d9908051bea", "title": "Plansplaining part 30 – Static cursors", "url": "https://sqlserverfast.com/blog/hugo/2024/05/plansplaining-part-30-static-cursors/", "published_at": "2024-05-16T18:54:19+00:00" }, { "id": "01a0d1d3-f98a-71ff-8258-8d9908d6dd21", "title": "T-SQL Tuesday 174 – Job interview questions", "url": "https://sqlserverfast.com/blog/hugo/2024/05/t-sql-tuesday-174-job-interview-questions/", "published_at": "2024-05-14T14:00:02+00:00" }, { "id": "01a0d1d3-f98a-71ff-8258-8d9909b1f2dd", "title": "Plansplaining part 29 – Introduction to cursor processing", "url": "https://sqlserverfast.com/blog/hugo/2024/04/plansplaining-part-29-introduction-to-cursor-processing/", "published_at": "2024-04-30T16:04:31+00:00" }, { "id": "01a0d1d3-f98a-71ff-8258-8d990a0a83da", "title": "Lots of events", "url": "https://sqlserverfast.com/blog/hugo/2024/02/lots-of-events/", "published_at": "2024-02-24T18:36:21+00:00" }, { "id": "01a0d1d4-3064-731f-aa61-55e14cbad3a2", "title": "T-SQL Tuesday 171 – The end of a diary?", "url": "https://sqlserverfast.com/blog/hugo/2024/02/t-sql-tuesday-171-the-end-of-a-diary/", "published_at": "2024-02-13T15:00:44+00:00" }, { "id": "01a0d1d4-3064-731f-aa61-55e14db8b388", "title": "Plansplaining part 28 – The curious case of the missing FIRST_VALUE function", "url": "https://sqlserverfast.com/blog/hugo/2024/01/plansplaining-part-28-the-curious-case-of-the-missing-first_value-function/", "published_at": "2024-01-19T14:42:59+00:00" }, { "id": "01a0d1d4-3064-731f-aa61-55e14e78b342", "title": "T-SQL Tuesday 170 – Abandoned projects", "url": "https://sqlserverfast.com/blog/hugo/2024/01/t-sql-tuesday-170-abandoned-projects/", "published_at": "2024-01-09T19:00:39+00:00" }, { "id": "01a0d1d4-3064-731f-aa61-55e14ea463e1", "title": "Plansplaining part 27 – LAG and LEAD", "url": "https://sqlserverfast.com/blog/hugo/2024/01/plansplaining-part-27-lag-and-lead/", "published_at": "2024-01-05T15:03:56+00:00" }, { "id": "01a0d1d4-3064-731f-aa61-55e14f777489", "title": "Plansplaining part 26 – Windows with a ranged frame", "url": "https://sqlserverfast.com/blog/hugo/2023/12/plansplaining-part-26-windows-with-a-ranged-frame/", "published_at": "2023-12-18T14:46:00+00:00" }, { "id": "01a0d1d4-3064-731f-aa61-55e1503f2398", "title": "T-SQL Tuesday 169 – Thank you, community!", "url": "https://sqlserverfast.com/blog/hugo/2023/12/t-sql-tuesday-169-thank-you-community/", "published_at": "2023-12-12T15:00:36+00:00" }, { "id": "01a0d1d4-3064-731f-aa61-55e1504cf574", "title": "Plansplaining part 25 – Windows without upper bound", "url": "https://sqlserverfast.com/blog/hugo/2023/12/plansplaining-part-25-windows-without-upper-bound/", "published_at": "2023-12-07T12:00:04+00:00" }, { "id": "01a0d1d4-3064-731f-aa61-55e1512d2f24", "title": "Execution Plan Video Training – pre-orders open", "url": "https://sqlserverfast.com/blog/hugo/2023/12/execution-plan-video-training-pre-orders-open/", "published_at": "2023-12-02T13:33:31+00:00" }, { "id": "01a0d1d4-3064-731f-aa61-55e1515ca3ed", "title": "Plansplaining part 24 – Windows on the fast track", "url": "https://sqlserverfast.com/blog/hugo/2023/11/plansplaining-part-24-windows-on-the-fast-track/", "published_at": "2023-11-21T12:03:51+00:00" }, { "id": "01a0d1d4-3064-731f-aa61-55e151daedab", "title": "Plansplaining part 23 / T-SQL Tuesday 168 – Window functions", "url": "https://sqlserverfast.com/blog/hugo/2023/11/plansplaining-part-23-t-sql-tuesday-168-window-functions/", "published_at": "2023-11-14T15:00:27+00:00" }, { "id": "01a0d1d4-63c3-72ef-9251-e8e8de42624a", "title": "Black Friday returns!", "url": "https://sqlserverfast.com/blog/hugo/2023/10/black-friday-returns/", "published_at": "2023-10-17T14:00:18+00:00" }, { "id": "01a0d1d4-63c3-72ef-9251-e8e8de66ca03", "title": "An update on MERGE", "url": "https://sqlserverfast.com/blog/hugo/2023/09/an-update-on-merge/", "published_at": "2023-09-29T13:57:13+00:00" }, { "id": "01a0d1d4-63c3-72ef-9251-e8e8defdea27", "title": "T-SQL Tuesday 165 – Job titles vs actual work", "url": "https://sqlserverfast.com/blog/hugo/2023/08/t-sql-tuesday-165-job-titles-vs-actual-work/", "published_at": "2023-08-08T14:00:42+00:00" }, { "id": "01a0d1d4-63c3-72ef-9251-e8e8df1991b5", "title": "Plansplaining, part 22. SQL Graph (part 3)", "url": "https://sqlserverfast.com/blog/hugo/2023/07/plansplaining-part-22-sql-graph-part-3/", "published_at": "2023-07-20T14:00:23+00:00" }, { "id": "01a0d1d4-63c3-72ef-9251-e8e8dfb7ca6c", "title": "T-SQL Tuesday 164 – Optimizing for readability or for performance", "url": "https://sqlserverfast.com/blog/hugo/2023/07/t-sql-tuesday-164-optimizing-for-readability-or-for-performance/", "published_at": "2023-07-11T14:00:55+00:00" }, { "id": "01a0d1d4-63c3-72ef-9251-e8e8e02ac3c6", "title": "SQL Graph indexing – I stand corrected", "url": "https://sqlserverfast.com/blog/hugo/2023/07/sql-graph-indexing-i-stand-corrected/", "published_at": "2023-07-07T10:46:43+00:00" }, { "id": "01a0d1d4-63c3-72ef-9251-e8e8e047347a", "title": "Plansplaining, part 21. SQL Graph (part 2)", "url": "https://sqlserverfast.com/blog/hugo/2023/06/plansplaining-part-21-sql-graph-part-2/", "published_at": "2023-06-22T15:00:07+00:00" }, { "id": "01a0d1d4-63c3-72ef-9251-e8e8e12a101e", "title": "T-SQL Tuesday 163 – Career advice", "url": "https://sqlserverfast.com/blog/hugo/2023/06/t-sql-tuesday-163-career-advice/", "published_at": "2023-06-20T15:00:15+00:00" }, { "id": "01a0d1d4-63c3-72ef-9251-e8e8e19538c2", "title": "Out with the old, in with the new", "url": "https://sqlserverfast.com/blog/hugo/2023/06/out-with-the-old-in-with-the-new/", "published_at": "2023-06-12T14:57:48+00:00" }, { "id": "01a0d1d4-63c3-72ef-9251-e8e8e1cf6347", "title": "Donor lymphocyte infusion", "url": "https://sqlserverfast.com/blog/hugo/2023/06/donor-lymphocyte-infusion/", "published_at": "2023-06-11T10:42:09+00:00" }, { "id": "01a0d1d4-a5e9-7201-add2-bafe9784dc91", "title": "New videos ready!", "url": "https://sqlserverfast.com/blog/hugo/2023/05/new-videos-ready/", "published_at": "2023-05-29T14:00:25+00:00" }, { "id": "01a0d1d4-a5e9-7201-add2-bafe98360718", "title": "Plansplaining, part 20. SQL Graph (part 1)", "url": "https://sqlserverfast.com/blog/hugo/2023/05/plansplaining-part-20-sql-graph-part-1/", "published_at": "2023-05-26T13:28:44+00:00" }, { "id": "01a0d1d4-a5e9-7201-add2-bafe9842dc33", "title": "New trailers and an updated chapter", "url": "https://sqlserverfast.com/blog/hugo/2023/05/new-trailers-and-an-updated-chapter/", "published_at": "2023-05-10T14:59:10+00:00" }, { "id": "01a0d1d4-a5e9-7201-add2-bafe98fd5929", "title": "T-SQL Tuesday 162 – Execution plans according to ChatGPT", "url": "https://sqlserverfast.com/blog/hugo/2023/05/t-sql-tuesday-162-execution-plans-according-to-chatgpt/", "published_at": "2023-05-09T15:00:19+00:00" }, { "id": "01a0d1d4-a5e9-7201-add2-bafe997dd456", "title": "Which execution plan icons are relevant today?", "url": "https://sqlserverfast.com/blog/hugo/2023/04/which-execution-plan-icons-are-relevant-today/", "published_at": "2023-04-17T10:30:55+00:00" }, { "id": "01a0d1d4-a5e9-7201-add2-bafe9998993c", "title": "Back home, but still a long way to go", "url": "https://sqlserverfast.com/blog/hugo/2023/04/back-home-but-still-a-long-way-to-go/", "published_at": "2023-04-05T13:28:37+00:00" }, { "id": "01a0d1d4-a5e9-7201-add2-bafe99e4caa1", "title": "Relational database design", "url": "https://sqlserverfast.com/blog/hugo/2023/03/relational-database-design/", "published_at": "2023-03-31T09:12:57+00:00" }, { "id": "01a0d1d4-a5e9-7201-add2-bafe99e6d42f", "title": "The final lap", "url": "https://sqlserverfast.com/blog/hugo/2023/02/the-final-lap/", "published_at": "2023-02-10T16:29:05+00:00" }, { "id": "01a0d1d4-a5e9-7201-add2-bafe9aa3d604", "title": "Good news, bad news", "url": "https://sqlserverfast.com/blog/hugo/2023/01/good-news-bad-news/", "published_at": "2023-01-19T12:33:29+00:00" }, { "id": "01a0d1d4-a5e9-7201-add2-bafe9b2305a6", "title": "A quiet period", "url": "https://sqlserverfast.com/blog/hugo/2022/12/a-quiet-period/", "published_at": "2022-12-20T15:50:30+00:00" }, { "id": "01a0d1d4-cd25-7010-9358-22dae75ac9b6", "title": "Black Friday Charity summary", "url": "https://sqlserverfast.com/blog/hugo/2022/12/black-friday-charity-summary/", "published_at": "2022-12-02T14:13:51+00:00" }, { "id": "01a0d1d4-cd25-7010-9358-22dae8059463", "title": "When it rains, it pours", "url": "https://sqlserverfast.com/blog/hugo/2022/11/when-it-rains-it-pours/", "published_at": "2022-11-25T19:09:43+00:00" }, { "id": "01a0d1d4-cd25-7010-9358-22dae8606a65", "title": "A long overdue update", "url": "https://sqlserverfast.com/blog/hugo/2022/10/a-long-overdue-update/", "published_at": "2022-10-19T11:26:44+00:00" }, { "id": "01a0d1d4-cd25-7010-9358-22dae8b80a61", "title": "Black Friday Charity", "url": "https://sqlserverfast.com/blog/hugo/2022/10/black-friday-charity/", "published_at": "2022-10-09T16:16:45+00:00" }, { "id": "01a0d1d4-cd25-7010-9358-22dae9b44a4c", "title": "The calm before the storm", "url": "https://sqlserverfast.com/blog/hugo/2022/09/the-calm-before-the-storm/", "published_at": "2022-09-27T13:23:06+00:00" }, { "id": "01a0d1d4-cd25-7010-9358-22dae9e0a710", "title": "First day in the hospital", "url": "https://sqlserverfast.com/blog/hugo/2022/09/first-day-in-the-hospital/", "published_at": "2022-09-21T17:27:56+00:00" }, { "id": "01a0d1d4-cd25-7010-9358-22daea1a48bc", "title": "Last day at home", "url": "https://sqlserverfast.com/blog/hugo/2022/09/last-day-at-home/", "published_at": "2022-09-18T17:13:21+00:00" }, { "id": "01a0d1d4-cd25-7010-9358-22daea376993", "title": "A badly timed toothache", "url": "https://sqlserverfast.com/blog/hugo/2022/09/a-badly-timed-toothache/", "published_at": "2022-09-17T12:58:30+00:00" }, { "id": "01a0d1d4-cd25-7010-9358-22daeafe3a9b", "title": "Involuntary break from speaking", "url": "https://sqlserverfast.com/blog/hugo/2022/09/involuntary-break-from-speaking/", "published_at": "2022-09-13T18:03:04+00:00" }, { "id": "01a0d1d4-cd25-7010-9358-22daeb94855d", "title": "T-SQL Tuesday #151 – Coding standards", "url": "https://sqlserverfast.com/blog/hugo/2022/06/t-sql-tuesday-151-coding-standards/", "published_at": "2022-06-14T14:00:58+00:00" } ] posts Claim your blog

Back to sqlserverfast.com

Blog · corpus.blog/blogs/sqlserverfast.com/posts

sqlserverfast.com

sqlserverfast.com

2026

Plansplaining part 35. A bug in Table Spool and an invisible property on Stream Aggregate original ↗

16 Sept 2026

A new treatment starts original ↗

1 Sept 2026

Storage structures 6 – JSON indexes original ↗

17 Jul 2026

Slow progress is better than no progress original ↗

16 Jul 2026

Vimeo messed up, and you and I get the consequences original ↗

11 Jul 2026

T-SQL Tuesday 200 – Query red flags original ↗

7 Jul 2026

Plansplaining part 34 – XML indexes revisited original ↗

30 Jun 2026

Change is the only constant original ↗

27 Jun 2026

Another crazy week original ↗

19 Jun 2026

Storage structures 5 – XML indexes original ↗

16 Jun 2026

Video training update 2026 original ↗

13 Jun 2026

Optional Parameter Plan Optimization original ↗

6 Jun 2026

Storage structures 4 – Memory-optimized columnstore original ↗

27 May 2026

Parameter Sensitive Plan Optimization original ↗

23 May 2026

Back on track original ↗

19 May 2026

Between despair and hope original ↗

9 May 2026

Request for help – video hosting original ↗

21 Apr 2026

Bad parameter sniffing, what is it and what can you do about it original ↗

13 Apr 2026

Home for now original ↗

9 Apr 2026

Ups and downs original ↗

31 Mar 2026

To be where I need to be original ↗

23 Mar 2026

SQL injection, and how to prevent it original ↗

16 Mar 2026

Back in hospital original ↗

15 Mar 2026

Return to the diary original ↗

5 Mar 2026

Optimized Locking part 2: Lock After Qualification original ↗

26 Feb 2026

Video training update original ↗

22 Feb 2026

Precon, precon, precon original ↗

15 Feb 2026

Storage structures 3 – Memory-optimized original ↗

13 Feb 2026

Optimized Locking part 1: Transaction ID Locking original ↗

12 Feb 2026

T-SQL Tuesday 195 – Code that aged well original ↗

10 Feb 2026

Rowgoals, part 3: When rowgoals backfire original ↗

2 Feb 2026

Storage structures 2 – Columnstore original ↗

30 Jan 2026

Rowgoals, part 2: Rowgoals in unexpected places original ↗

25 Jan 2026

Rowgoals, part 1: How do rowgoals work?original ↗

17 Jan 2026

Storage structures 1 – On-disk rowstore original ↗

15 Jan 2026

Self-promo: Precon opportunities original ↗

14 Jan 2026

Problems purchasing videos?original ↗

10 Jan 2026

A new experiment for 2026 original ↗

1 Jan 2026

2025

A deep dive into hash tables, part 4 original ↗

23 Dec 2025

T-SQL Tuesday 191 – String parsing (and why I hate intelligent keys)original ↗

21 Oct 2025

Black Friday 2025 original ↗

11 Oct 2025

A deep dive into hash tables, part 3 original ↗

27 Sept 2025

T-SQL Tuesday 190 – Mastering a technical skill original ↗

9 Sept 2025

Video training update 2025 original ↗

6 Sept 2025

A deep dive into hash tables, part 2 original ↗

30 Aug 2025

A deep dive into hash tables, part 1 original ↗

14 Aug 2025

T-SQL Tuesday 183 – Permission hell original ↗

11 Feb 2025

T-SQL Tuesday 182 – Integrity original ↗

15 Jan 2025

2024

T-SQL Tuesday 181 – Amazing announcements original ↗

10 Dec 2024

T-SQL Tuesday 180 – The enemy of good?original ↗

12 Nov 2024

Black Friday again original ↗

13 Oct 2024

T-SQL Tuesday 178 – Misleading data in Query Store original ↗

10 Sept 2024

Plansplaining part 33 – Fast forward cursors original ↗

30 Aug 2024

Plansplaining part 32 – Keyset cursors original ↗

21 Jun 2024

Execution plan training around the world original ↗

16 Jun 2024

Plansplaining part 31 – Dynamic cursors original ↗

3 Jun 2024

Plansplaining part 30 – Static cursors original ↗

16 May 2024

T-SQL Tuesday 174 – Job interview questions original ↗

14 May 2024

Plansplaining part 29 – Introduction to cursor processing original ↗

30 Apr 2024

Lots of events original ↗

24 Feb 2024

T-SQL Tuesday 171 – The end of a diary?original ↗

13 Feb 2024

Plansplaining part 28 – The curious case of the missing FIRST_VALUE function original ↗

19 Jan 2024

T-SQL Tuesday 170 – Abandoned projects original ↗

9 Jan 2024

Plansplaining part 27 – LAG and LEAD original ↗

5 Jan 2024

2023

Plansplaining part 26 – Windows with a ranged frame original ↗

18 Dec 2023

T-SQL Tuesday 169 – Thank you, community!original ↗

12 Dec 2023

Plansplaining part 25 – Windows without upper bound original ↗

7 Dec 2023

Execution Plan Video Training – pre-orders open original ↗

2 Dec 2023

Plansplaining part 24 – Windows on the fast track original ↗

21 Nov 2023

Plansplaining part 23 / T-SQL Tuesday 168 – Window functions original ↗

14 Nov 2023

Black Friday returns!original ↗

17 Oct 2023

An update on MERGE original ↗

29 Sept 2023

T-SQL Tuesday 165 – Job titles vs actual work original ↗

8 Aug 2023

Plansplaining, part 22. SQL Graph (part 3)original ↗

20 Jul 2023

T-SQL Tuesday 164 – Optimizing for readability or for performance original ↗

11 Jul 2023

SQL Graph indexing – I stand corrected original ↗

7 Jul 2023

Plansplaining, part 21. SQL Graph (part 2)original ↗

22 Jun 2023

T-SQL Tuesday 163 – Career advice original ↗

20 Jun 2023

Out with the old, in with the new original ↗

12 Jun 2023

Donor lymphocyte infusion original ↗

11 Jun 2023

New videos ready!original ↗

29 May 2023

Plansplaining, part 20. SQL Graph (part 1)original ↗

26 May 2023

New trailers and an updated chapter original ↗

10 May 2023

T-SQL Tuesday 162 – Execution plans according to ChatGPT original ↗

9 May 2023

Which execution plan icons are relevant today?original ↗

17 Apr 2023

Back home, but still a long way to go original ↗

5 Apr 2023

Relational database design original ↗

31 Mar 2023

The final lap original ↗

10 Feb 2023

Good news, bad news original ↗

19 Jan 2023

2022

A quiet period original ↗

20 Dec 2022

Black Friday Charity summary original ↗

2 Dec 2022

When it rains, it pours original ↗

25 Nov 2022

A long overdue update original ↗

19 Oct 2022

Black Friday Charity original ↗

9 Oct 2022

The calm before the storm original ↗

27 Sept 2022

First day in the hospital original ↗

21 Sept 2022

Last day at home original ↗

18 Sept 2022

A badly timed toothache original ↗

17 Sept 2022

Involuntary break from speaking original ↗

13 Sept 2022

T-SQL Tuesday #151 – Coding standards original ↗

14 Jun 2022