41554 blogs · [ { "id": "01a087e4-be94-7112-a708-aed58f6a97f4", "title": "The illogical longing for scarcity", "url": "https://sqlsunday.com/2025/08/04/the-illogical-longing-for-scarcity/", "published_at": "2025-08-04T19:25:11+00:00" }, { "id": "01a087e4-be95-7295-8def-1c0a06491e8c", "title": "Off topic: My thoughts on value-based pricing", "url": "https://sqlsunday.com/2025/06/04/on-value-based-pricing/", "published_at": "2025-06-04T20:20:20+00:00" }, { "id": "01a087e4-be95-7295-8def-1c0a0693c950", "title": "JSON indexes in SQL Server: First impressions", "url": "https://sqlsunday.com/2025/05/19/json-indexes-first-impressions/", "published_at": "2025-05-19T16:54:12+00:00" }, { "id": "01a087e4-be95-7295-8def-1c0a07662a24", "title": "The best ten years for movies were 1994-2003, and I have proof", "url": "https://sqlsunday.com/2024/05/05/imdb-on-sql-server/", "published_at": "2024-05-05T17:15:10+00:00" }, { "id": "01a087e4-be95-7295-8def-1c0a07d98afb", "title": "Collect and report session feedback for your Data/SQL Saturday event!", "url": "https://sqlsunday.com/2024/04/18/collect-and-report-session-feedback-for-your-data-sql-saturday-event/", "published_at": "2024-04-18T06:42:16+00:00" }, { "id": "01a087e4-be95-7295-8def-1c0a080e4d4f", "title": "Dynamically updating Azure Network Security Groups", "url": "https://sqlsunday.com/2024/04/01/dynamically-updating-azure-network-security-groups/", "published_at": "2024-04-01T17:56:31+00:00" }, { "id": "01a087e4-be95-7295-8def-1c0a08aedc5e", "title": "How to use Cloudflare R2 for SQL Server backups", "url": "https://sqlsunday.com/2024/01/18/use-cloudflare-r2-for-sql-server-backups/", "published_at": "2024-01-18T18:40:37+00:00" }, { "id": "01a087e4-be95-7295-8def-1c0a0938f4e4", "title": "T-SQL math patterns", "url": "https://sqlsunday.com/2024/01/03/sql-math/", "published_at": "2024-01-03T18:05:59+00:00" }, { "id": "01a087e4-be95-7295-8def-1c0a09a20d52", "title": "How to join overlapping date ranges", "url": "https://sqlsunday.com/2023/12/05/join-overlapping-date-ranges/", "published_at": "2023-12-05T21:56:25+00:00" }, { "id": "01a087e4-be95-7295-8def-1c0a0a12ea69", "title": "Indexing for substring search", "url": "https://sqlsunday.com/2023/11/27/indexing-for-substring-search/", "published_at": "2023-11-27T22:27:53+00:00" }, { "id": "01a0d1d2-dcdf-703b-9382-61e07cea20b2", "title": "The quirky and wonderful self-join optimization", "url": "https://sqlsunday.com/2023/11/23/quirky-and-wonderful-self-join/", "published_at": "2023-11-23T08:07:39+00:00" }, { "id": "01a0d1d2-dcdf-703b-9382-61e07cfec7fe", "title": "A quick look at SQL Server UTF-8 collations", "url": "https://sqlsunday.com/2023/11/08/sql-server-utf8-collations/", "published_at": "2023-11-08T20:23:30+00:00" }, { "id": "01a0d1d2-dcdf-703b-9382-61e07ddfc689", "title": "I ❤️ QUOTENAME()", "url": "https://sqlsunday.com/2023/10/18/i-love-quotename/", "published_at": "2023-10-18T11:04:19+00:00" }, { "id": "01a0d1d2-dcdf-703b-9382-61e07eac9d02", "title": "How to put tempdb on your Azure VM temp disk", "url": "https://sqlsunday.com/2023/04/10/set-up-tempdb-on-vm-temporary-disk/", "published_at": "2023-04-10T09:00:00+00:00" }, { "id": "01a0d1d2-dcdf-703b-9382-61e07f2f32cd", "title": "Secure your temporal table history", "url": "https://sqlsunday.com/2023/01/19/secure-temporal-table-history/", "published_at": "2023-01-19T08:23:48+00:00" }, { "id": "01a0d1d2-dcdf-703b-9382-61e0801717c8", "title": "I made a new demo/workshop database", "url": "https://sqlsunday.com/2022/12/05/new-demo-database/", "published_at": "2022-12-05T09:00:00+00:00" }, { "id": "01a0d1d2-dcdf-703b-9382-61e0809d1ae0", "title": "Querying a single table can use multiple indexes", "url": "https://sqlsunday.com/2022/11/08/using-multiple-indexes-on-a-single-table-query/", "published_at": "2022-11-08T10:50:56+00:00" }, { "id": "01a0d1d2-dcdf-703b-9382-61e080b0842e", "title": "Watch out for Merge Interval with date range Index Seeks", "url": "https://sqlsunday.com/2022/10/13/merge-interval-with-date-range-index-seek/", "published_at": "2022-10-13T14:55:54+00:00" }, { "id": "01a0d1d2-dcdf-703b-9382-61e080e171ae", "title": "DATEDIFF performs implicit conversions", "url": "https://sqlsunday.com/2022/10/10/datediff-performs-implicit-conversions/", "published_at": "2022-10-10T08:10:00+00:00" }, { "id": "01a0d1d2-dcdf-703b-9382-61e08131929d", "title": "Computing the modulus from very large numbers", "url": "https://sqlsunday.com/2022/09/26/computing-the-modulus-from-very-large-numbers/", "published_at": "2022-09-26T08:06:16+00:00" }, { "id": "01a0d1d3-4339-72c7-815c-408c2aa99ded", "title": "T-SQL template parser", "url": "https://sqlsunday.com/2022/07/26/t-sql-template-parser/", "published_at": "2022-07-26T19:28:50+00:00" }, { "id": "01a0d1d3-4339-72c7-815c-408c2af42126", "title": "Turn your list into human-readable intervals", "url": "https://sqlsunday.com/2022/07/18/turn-your-list-into-human-readable-intervals/", "published_at": "2022-07-18T07:00:00+00:00" }, { "id": "01a0d1d3-4339-72c7-815c-408c2b273164", "title": "Use Ctrl+F1 as a “preview” button in SSMS", "url": "https://sqlsunday.com/2022/04/28/use-ctrlf1-as-preview-in-ssms/", "published_at": "2022-04-28T07:00:00+00:00" }, { "id": "01a0d1d3-4339-72c7-815c-408c2bdc4aa7", "title": "STRING_SPLIT(), but for quoted names", "url": "https://sqlsunday.com/2022/04/22/string_split-for-quoted-names/", "published_at": "2022-04-22T07:00:00+00:00" }, { "id": "01a0d1d3-4339-72c7-815c-408c2bead1a1", "title": "About wildcards and data type precedence", "url": "https://sqlsunday.com/2021/11/03/wildcards-and-data-type-precedence/", "published_at": "2021-11-03T10:00:00+00:00" }, { "id": "01a0d1d3-4339-72c7-815c-408c2bf13009", "title": "A simple database deploy pipeline using sqlpackage", "url": "https://sqlsunday.com/2021/09/09/a-simple-database-deploy-pipeline-using-sqlpackage/", "published_at": "2021-09-09T19:11:34+00:00" }, { "id": "01a0d1d3-4339-72c7-815c-408c2cc50d90", "title": "Set up access to network shares from SQL Server", "url": "https://sqlsunday.com/2021/09/02/set-up-access-to-network-shares/", "published_at": "2021-09-02T06:25:16+00:00" }, { "id": "01a0d1d3-4339-72c7-815c-408c2d6cb595", "title": "Optimizing a string split and search", "url": "https://sqlsunday.com/2021/08/26/optimizing-string-split-search/", "published_at": "2021-08-26T06:31:57+00:00" }, { "id": "01a0d1d3-4339-72c7-815c-408c2d71d541", "title": "How to add “created” and “updated” timestamps without triggers", "url": "https://sqlsunday.com/2021/08/09/add-created-and-updated-timestamps/", "published_at": "2021-08-09T07:00:00+00:00" }, { "id": "01a0d1d3-4339-72c7-815c-408c2e294c0e", "title": "A “shock absorber” pattern for high-performance data ingestion", "url": "https://sqlsunday.com/2021/07/15/a-shock-absorber-pattern-for-high-performance-data-ingest/", "published_at": "2021-07-15T06:00:00+00:00" }, { "id": "01a0d1d3-8846-719b-9a98-6a5de5b17575", "title": "How MERGE on two different rows can still deadlock you", "url": "https://sqlsunday.com/2021/05/04/how-merge-can-deadlock-you/", "published_at": "2021-05-04T06:30:00+00:00" }, { "id": "01a0d1d3-8846-719b-9a98-6a5de664cf81", "title": "Connecting a SQL Server client on Linux using Active Directory authentication", "url": "https://sqlsunday.com/2021/04/15/connecting-linux-using-ad-authentication/", "published_at": "2021-04-15T16:20:33+00:00" }, { "id": "01a0d1d3-8846-719b-9a98-6a5de6cccddb", "title": "Is a sort faster when the data is already sorted?", "url": "https://sqlsunday.com/2021/02/15/is-a-sort-faster-when-data-already-sorted/", "published_at": "2021-02-15T08:00:00+00:00" }, { "id": "01a0d1d3-8846-719b-9a98-6a5de75903eb", "title": "Connect using Windows authentication across domains", "url": "https://sqlsunday.com/2021/02/05/connect-using-windows-authentication-across-domains/", "published_at": "2021-02-05T09:27:14+00:00" }, { "id": "01a0d1d3-8846-719b-9a98-6a5de7f0f22e", "title": "The uncorrelated correlated subquery", "url": "https://sqlsunday.com/2020/12/21/the-uncorrelated-correlated-subquery/", "published_at": "2020-12-21T09:00:00+00:00" }, { "id": "01a0d1d3-8846-719b-9a98-6a5de86f0cd1", "title": "How to fix rounding errors", "url": "https://sqlsunday.com/2020/12/15/how-to-fix-rounding-errors/", "published_at": "2020-12-15T09:00:00+00:00" }, { "id": "01a0d1d3-8846-719b-9a98-6a5de8721c80", "title": "The curious case of the Top N Sort", "url": "https://sqlsunday.com/2020/12/08/the-curious-case-of-the-top-n-sort/", "published_at": "2020-12-08T09:00:00+00:00" }, { "id": "01a0d1d3-8846-719b-9a98-6a5de8a8e256", "title": "How to run your CTE just once, and re-use the output", "url": "https://sqlsunday.com/2020/12/01/run-your-cte-just-once-and-reuse-output/", "published_at": "2020-12-01T09:00:00+00:00" }, { "id": "01a0d1d3-8846-719b-9a98-6a5de9230a2a", "title": "Optimizing for something else", "url": "https://sqlsunday.com/2020/08/26/optimizing-for-something-else/", "published_at": "2020-08-26T06:46:27+00:00" }, { "id": "01a0d1d3-8846-719b-9a98-6a5de995caab", "title": "Set your Azure VM to auto-shutdown and have it notify you on Slack", "url": "https://sqlsunday.com/2020/07/20/auto-shutdown-on-azure-vm-notify-on-slack/", "published_at": "2020-07-20T08:30:00+00:00" }, { "id": "01a0d1d3-cc11-7152-9629-cde56985c104", "title": "Consolidating grouped transactions into evenly sized batches", "url": "https://sqlsunday.com/2020/07/13/grouping-into-evenly-sized-batches/", "published_at": "2020-07-13T08:30:00+00:00" }, { "id": "01a0d1d3-cc11-7152-9629-cde56a0a68c2", "title": "Fun with VALUES", "url": "https://sqlsunday.com/2020/07/06/fun-with-values/", "published_at": "2020-07-06T08:30:00+00:00" }, { "id": "01a0d1d3-cc11-7152-9629-cde56a521d5a", "title": "SSMS: Search and replace across multiple objects in a database", "url": "https://sqlsunday.com/2020/04/15/search-and-replace-across-multiple-objects/", "published_at": "2020-04-15T08:30:00+00:00" }, { "id": "01a0d1d3-cc11-7152-9629-cde56b2d943a", "title": "Break out of your comfort zone in 2020.", "url": "https://sqlsunday.com/2019/12/31/break-out-of-your-comfort-zone-in-2020/", "published_at": "2019-12-31T08:00:00+00:00" }, { "id": "01a0d1d3-cc11-7152-9629-cde56bf4bce9", "title": "Do something else, become better at what you love", "url": "https://sqlsunday.com/2019/11/29/do-something-else/", "published_at": "2019-11-29T09:00:00+00:00" }, { "id": "01a0d1d3-cc11-7152-9629-cde56c7d89d5", "title": "How to use switching to make metadata changes online", "url": "https://sqlsunday.com/2019/11/25/use-switching-to-make-metadata-changes-online/", "published_at": "2019-11-25T09:24:52+00:00" }, { "id": "01a0d1d3-cc11-7152-9629-cde56ca16e4a", "title": "Aggregating date and time values", "url": "https://sqlsunday.com/2019/10/10/aggregating-date-and-time-values/", "published_at": "2019-10-10T08:00:00+00:00" }, { "id": "01a0d1d3-cc11-7152-9629-cde56d4cfcdc", "title": "Anonymize your dev databases!", "url": "https://sqlsunday.com/2019/10/03/anonymize-your-dev-databases/", "published_at": "2019-10-03T06:13:00+00:00" }, { "id": "01a0d1d3-cc11-7152-9629-cde56d6e2e1a", "title": "Scan hundreds of SQL Saturday raffle tickets. Fast.", "url": "https://sqlsunday.com/2019/09/24/scan-raffle-tickets-fast/", "published_at": "2019-09-24T07:00:00+00:00" }, { "id": "01a0d1d3-cc11-7152-9629-cde56e226bf8", "title": "Calculating invoice settlements with window functions", "url": "https://sqlsunday.com/2019/09/16/calculating-invoice-settlements/", "published_at": "2019-09-16T07:00:00+00:00" }, { "id": "01a0d1d4-09d3-7218-9510-b097869b8a3d", "title": "How to get an automated alert when your Azure cost takes off", "url": "https://sqlsunday.com/2019/06/19/how-to-get-an-automated-alert-when-your-azure-cost-takes-off/", "published_at": "2019-06-19T08:05:07+00:00" }, { "id": "01a0d1d4-09d3-7218-9510-b09786f618c5", "title": "CAST/CONVERT makes expressions nullable", "url": "https://sqlsunday.com/2019/06/05/cast-convert-makes-expressions-nullable/", "published_at": "2019-06-05T11:31:18+00:00" }, { "id": "01a0d1d4-09d3-7218-9510-b0978705ddde", "title": "Scalar function inlining in SQL Server 2019", "url": "https://sqlsunday.com/2019/04/08/scalar-function-inlining-in-sql-server-2019/", "published_at": "2019-04-08T08:00:33+00:00" }, { "id": "01a0d1d4-09d3-7218-9510-b097873ae9c3", "title": "How to set up a beautiful Powershell Core terminal on Mac OS", "url": "https://sqlsunday.com/2019/03/04/how-to-set-up-a-beautiful-powershell-core-terminal-on-mac-os/", "published_at": "2019-03-04T09:00:19+00:00" }, { "id": "01a0d1d4-09d3-7218-9510-b09787e47d8d", "title": "Why and how you should speak at a conference", "url": "https://sqlsunday.com/2019/02/19/you-should-speak-at-a-conference/", "published_at": "2019-02-19T16:00:45+00:00" }, { "id": "01a0d1d4-09d3-7218-9510-b097884c3160", "title": "Changing the fill factor on multiple tables/indexes", "url": "https://sqlsunday.com/2019/01/09/changing-fill-factor-on-multiple-indexes/", "published_at": "2019-01-09T09:00:51+00:00" }, { "id": "01a0d1d4-09d3-7218-9510-b09788b3e188", "title": "Nullable columns and performance", "url": "https://sqlsunday.com/2019/01/03/nullable-columns-and-performance/", "published_at": "2019-01-03T09:00:29+00:00" }, { "id": "01a0d1d4-09d3-7218-9510-b097891ea2cb", "title": "sqlsunday.com downloads are now on GitHub!", "url": "https://sqlsunday.com/2018/11/15/sqlsunday-com-downloads-are-now-on-github/", "published_at": "2018-11-15T20:16:36+00:00" }, { "id": "01a0d1d4-09d3-7218-9510-b097895d9ae9", "title": "Conference hack: how to get great screenshots from demos", "url": "https://sqlsunday.com/2018/11/09/get-pretty-screenshots-from-demos-and-presentation/", "published_at": "2018-11-09T18:50:20+00:00" }, { "id": "01a0d1d4-09d3-7218-9510-b0978a0116f4", "title": "What’s in my backpack", "url": "https://sqlsunday.com/2018/10/18/whats-in-my-backpack/", "published_at": "2018-10-18T09:00:30+00:00" }, { "id": "01a0d1d4-44e0-70cd-9b84-9ebffbc25b20", "title": "Make a Windows shortcut to compare files in Visual Studio", "url": "https://sqlsunday.com/2018/10/16/shortcut-for-visual-studio-compare/", "published_at": "2018-10-16T08:00:48+00:00" }, { "id": "01a0d1d4-44e0-70cd-9b84-9ebffc51b488", "title": "Operations that need a serial plan", "url": "https://sqlsunday.com/2018/08/09/parallel-and-serial-operators/", "published_at": "2018-08-09T08:00:40+00:00" }, { "id": "01a0d1d4-44e0-70cd-9b84-9ebffca93be7", "title": "The SQL Server Calendar project", "url": "https://sqlsunday.com/2018/07/16/sql-server-calendar/", "published_at": "2018-07-16T08:00:19+00:00" }, { "id": "01a0d1d4-44e0-70cd-9b84-9ebffd4407e2", "title": "T-SQL Tuesday #104: Code you would hate to live without", "url": "https://sqlsunday.com/2018/07/10/t-sql-tuesday-104-code-you-would-hate-to-live-without/", "published_at": "2018-07-10T08:30:21+00:00" }, { "id": "01a0d1d4-44e0-70cd-9b84-9ebffe2e6bf1", "title": "Quick and dirty: How to right-align numeric columns in SSMS", "url": "https://sqlsunday.com/2018/06/12/right-align-columns-in-ssms/", "published_at": "2018-06-12T07:50:10+00:00" }, { "id": "01a0d1d4-44e0-70cd-9b84-9ebfff0aafc6", "title": "Grouping dates without blocking operators", "url": "https://sqlsunday.com/2018/05/14/grouping-dates-without-blocking-operators/", "published_at": "2018-05-14T08:30:00+00:00" }, { "id": "01a0d1d4-44e0-70cd-9b84-9ebfff71b036", "title": "Quiz: What’s going on here, then?", "url": "https://sqlsunday.com/2018/04/05/quiz-whats-going-on-here-then/", "published_at": "2018-04-05T08:00:17+00:00" }, { "id": "01a0d1d4-44e0-70cd-9b84-9ec000254f80", "title": "Get the join cheat sheet!", "url": "https://sqlsunday.com/2018/02/19/join-cheat-sheet/", "published_at": "2018-02-19T08:00:03+00:00" }, { "id": "01a0d1d4-44e0-70cd-9b84-9ec000dede68", "title": "An alternative to data masking", "url": "https://sqlsunday.com/2018/02/05/an-alternative-to-data-masking/", "published_at": "2018-02-05T08:30:59+00:00" }, { "id": "01a0d1d4-44e0-70cd-9b84-9ec0015e82eb", "title": "Computed columns with scalar functions", "url": "https://sqlsunday.com/2018/01/26/computed-cols-with-scalar-functions/", "published_at": "2018-01-26T08:59:38+00:00" }, { "id": "01a0d1d4-7ad2-72ce-8932-12c160849dee", "title": "Encrypting SQL Server connections with Let’s Encrypt certificates", "url": "https://sqlsunday.com/2017/11/22/encrypting-tds-with-letsencrypt/", "published_at": "2017-11-22T12:03:11+00:00" }, { "id": "01a0d1d4-7ad2-72ce-8932-12c1613e54f3", "title": "Can your client or employer read your HTTPS traffic?", "url": "https://sqlsunday.com/2017/10/23/can-your-client-read-your-https-traffic/", "published_at": "2017-10-23T07:00:28+00:00" }, { "id": "01a0d1d4-7ad2-72ce-8932-12c16145c1ae", "title": "Legacy apps that don’t believe in schemas", "url": "https://sqlsunday.com/2017/10/13/legacy-apps-that-dont-believe-in-schemas/", "published_at": "2017-10-13T06:00:31+00:00" }, { "id": "01a0d1d4-7ad2-72ce-8932-12c16184329c", "title": "Effective permissions on SQL Server", "url": "https://sqlsunday.com/2017/09/27/effective-permissions/", "published_at": "2017-09-27T08:00:41+00:00" }, { "id": "01a0d1d4-7ad2-72ce-8932-12c161aea890", "title": "Fun with random names", "url": "https://sqlsunday.com/2017/09/18/fun-with-random-names/", "published_at": "2017-09-18T07:00:40+00:00" }, { "id": "01a0d1d4-7ad2-72ce-8932-12c161d87e70", "title": "How good are best practices?", "url": "https://sqlsunday.com/2017/08/16/how-good-are-best-practices/", "published_at": "2017-08-16T08:00:13+00:00" }, { "id": "01a0d1d4-7ad2-72ce-8932-12c162ae8388", "title": "Prioritizing rows in a union", "url": "https://sqlsunday.com/2017/07/26/prioritizing-rows-in-a-union/", "published_at": "2017-07-26T07:00:43+00:00" }, { "id": "01a0d1d4-7ad2-72ce-8932-12c163a6f454", "title": "Accounting basics for tech people", "url": "https://sqlsunday.com/2017/05/16/accounting-basics/", "published_at": "2017-05-16T09:00:29+00:00" }, { "id": "01a0d1d4-7ad2-72ce-8932-12c1644aa2a6", "title": "Automatically guessing foreign key constraints", "url": "https://sqlsunday.com/2017/04/10/guessing-fk-constraints/", "published_at": "2017-04-10T08:30:34+00:00" }, { "id": "01a0d1d4-7ad2-72ce-8932-12c165061ac5", "title": "Finding primary key candidates", "url": "https://sqlsunday.com/2017/02/21/finding-primary-key-candidates/", "published_at": "2017-02-21T09:00:08+00:00" }, { "id": "01a0d1d4-bd6c-7101-8088-edbc3e72e804", "title": "Please don’t feed auditors and lawyers", "url": "https://sqlsunday.com/2017/02/17/dont-feed-auditors/", "published_at": "2017-02-17T09:55:03+00:00" }, { "id": "01a0d1d4-bd6c-7101-8088-edbc3eccbab7", "title": "Speaking at the Group By conference!", "url": "https://sqlsunday.com/2017/01/23/the-group-by-conference/", "published_at": "2017-01-23T09:00:20+00:00" }, { "id": "01a0d1d4-bd6c-7101-8088-edbc3fa83b33", "title": "Practical uses of binary types", "url": "https://sqlsunday.com/2017/01/09/binary-types/", "published_at": "2017-01-09T09:30:43+00:00" }, { "id": "01a0d1d4-bd6c-7101-8088-edbc403e8055", "title": "Have you tried sp_ctrl3?", "url": "https://sqlsunday.com/2016/11/28/sp_ctrl3/", "published_at": "2016-11-28T10:30:52+00:00" }, { "id": "01a0d1d4-bd6c-7101-8088-edbc411c2459", "title": "A visual representation of SQL Server Agent jobs", "url": "https://sqlsunday.com/2016/11/17/visual-representation-of-sql-server-agent-jobs/", "published_at": "2016-11-17T11:00:57+00:00" }, { "id": "01a0d1d4-bd6c-7101-8088-edbc4165971a", "title": "A week later: thoughts on the 2016 PASS Summit", "url": "https://sqlsunday.com/2016/11/06/thoughts-on-the-2016-pass-summit/", "published_at": "2016-11-06T21:58:47+00:00" }, { "id": "01a0d1d4-bd6c-7101-8088-edbc4177ec88", "title": "Availability Groups: How to sync logins between replicas", "url": "https://sqlsunday.com/2016/10/11/how-to-sync-logins-between-availability-group-replicas/", "published_at": "2016-10-11T09:30:49+00:00" }, { "id": "01a0d1d4-bd6c-7101-8088-edbc4232f2d5", "title": "The compelling case for using heaps", "url": "https://sqlsunday.com/2016/09/01/compelling-case-for-heaps/", "published_at": "2016-09-01T10:30:30+00:00" }, { "id": "01a0d1d4-bd6c-7101-8088-edbc4315d749", "title": "Not giving a shit about performance is tech-debt", "url": "https://sqlsunday.com/2016/08/11/not-giving-a-s-t-about-performance/", "published_at": "2016-08-11T10:00:42+00:00" }, { "id": "01a0d1d4-bd6c-7101-8088-edbc43f580df", "title": "Human-readable ranges of integers or dates", "url": "https://sqlsunday.com/2016/08/03/human-readable-ranges/", "published_at": "2016-08-03T11:00:37+00:00" }, { "id": "01a0d1d4-ec3f-700b-986f-de2bf919a1ce", "title": "Video: three SQL Server join operators in three minutes", "url": "https://sqlsunday.com/2016/08/01/3-sql-server-join-operators-in-3-minutes/", "published_at": "2016-08-01T11:00:15+00:00" }, { "id": "01a0d1d4-ec3f-700b-986f-de2bf9837d8a", "title": "My brand-new T-SQL reference app for Slack", "url": "https://sqlsunday.com/2016/07/20/t-sql-reference-app-for-slack/", "published_at": "2016-07-20T11:30:37+00:00" }, { "id": "01a0d1d4-ec3f-700b-986f-de2bfa0d7143", "title": "Comparing nullable columns", "url": "https://sqlsunday.com/2016/07/14/comparing-nullable-columns/", "published_at": "2016-07-14T05:30:30+00:00" }, { "id": "01a0d1d4-ec3f-700b-986f-de2bfa5918cd", "title": "Start Management Studio with alternate Windows credentials", "url": "https://sqlsunday.com/2016/06/27/start-ssms-with-alternate-credentials/", "published_at": "2016-06-27T05:30:06+00:00" }, { "id": "01a0d1d4-ec3f-700b-986f-de2bfa822210", "title": "Copying data with foreign keys and/or identity columns", "url": "https://sqlsunday.com/2016/06/16/copying-data-with-foreign-keys-and-identity-columns/", "published_at": "2016-06-16T06:00:28+00:00" }, { "id": "01a0d1d4-ec3f-700b-986f-de2bfb23d16b", "title": "Key Lookup without an output column?", "url": "https://sqlsunday.com/2016/06/02/key-lookup-without-output-column/", "published_at": "2016-06-02T06:00:48+00:00" }, { "id": "01a0d1d4-ec3f-700b-986f-de2bfb5bca8e", "title": "Selectively disable “Include actual execution plan”", "url": "https://sqlsunday.com/2016/05/22/disable-actual-execution-plan/", "published_at": "2016-05-22T06:00:22+00:00" }, { "id": "01a0d1d4-ec3f-700b-986f-de2bfc49958d", "title": "Calculating the number of weekdays between two dates", "url": "https://sqlsunday.com/2016/05/15/calculating-weekdays-between-dates/", "published_at": "2016-05-15T06:00:10+00:00" }, { "id": "01a0d1d4-ec3f-700b-986f-de2bfc73195a", "title": "Detaching a database also alters file permissions", "url": "https://sqlsunday.com/2016/05/11/detaching-a-database-alters-the-file-permissions/", "published_at": "2016-05-11T06:00:58+00:00" }, { "id": "01a0d1d4-ec3f-700b-986f-de2bfcb3cd93", "title": "A faster Fibonacci series in T-SQL", "url": "https://sqlsunday.com/2016/04/30/faster-fibonacci-series-in-t-sql/", "published_at": "2016-04-30T09:16:36+00:00" } ] posts Claim your blog

Back to sqlsunday.com

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

sqlsunday.com

sqlsunday.com

2025

The illogical longing for scarcity original ↗

4 Aug 2025

Off topic: My thoughts on value-based pricing original ↗

4 Jun 2025

JSON indexes in SQL Server: First impressions original ↗

19 May 2025

2024

The best ten years for movies were 1994-2003, and I have proof original ↗

5 May 2024

Collect and report session feedback for your Data/SQL Saturday event!original ↗

18 Apr 2024

Dynamically updating Azure Network Security Groups original ↗

1 Apr 2024

How to use Cloudflare R2 for SQL Server backups original ↗

18 Jan 2024

T-SQL math patterns original ↗

3 Jan 2024

2023

How to join overlapping date ranges original ↗

5 Dec 2023

Indexing for substring search original ↗

27 Nov 2023

The quirky and wonderful self-join optimization original ↗

23 Nov 2023

A quick look at SQL Server UTF-8 collations original ↗

8 Nov 2023

I ❤️ QUOTENAME()original ↗

18 Oct 2023

How to put tempdb on your Azure VM temp disk original ↗

10 Apr 2023

Secure your temporal table history original ↗

19 Jan 2023

2022

I made a new demo/workshop database original ↗

5 Dec 2022

Querying a single table can use multiple indexes original ↗

8 Nov 2022

Watch out for Merge Interval with date range Index Seeks original ↗

13 Oct 2022

DATEDIFF performs implicit conversions original ↗

10 Oct 2022

Computing the modulus from very large numbers original ↗

26 Sept 2022

T-SQL template parser original ↗

26 Jul 2022

Turn your list into human-readable intervals original ↗

18 Jul 2022

Use Ctrl+F1 as a “preview” button in SSMS original ↗

28 Apr 2022

STRING_SPLIT(), but for quoted names original ↗

22 Apr 2022

2021

About wildcards and data type precedence original ↗

3 Nov 2021

A simple database deploy pipeline using sqlpackage original ↗

9 Sept 2021

Set up access to network shares from SQL Server original ↗

2 Sept 2021

Optimizing a string split and search original ↗

26 Aug 2021

How to add “created” and “updated” timestamps without triggers original ↗

9 Aug 2021

A “shock absorber” pattern for high-performance data ingestion original ↗

15 Jul 2021

How MERGE on two different rows can still deadlock you original ↗

4 May 2021

Connecting a SQL Server client on Linux using Active Directory authentication original ↗

15 Apr 2021

Is a sort faster when the data is already sorted?original ↗

15 Feb 2021

Connect using Windows authentication across domains original ↗

5 Feb 2021

2020

The uncorrelated correlated subquery original ↗

21 Dec 2020

How to fix rounding errors original ↗

15 Dec 2020

The curious case of the Top N Sort original ↗

8 Dec 2020

How to run your CTE just once, and re-use the output original ↗

1 Dec 2020

Optimizing for something else original ↗

26 Aug 2020

Set your Azure VM to auto-shutdown and have it notify you on Slack original ↗

20 Jul 2020

Consolidating grouped transactions into evenly sized batches original ↗

13 Jul 2020

Fun with VALUES original ↗

6 Jul 2020

SSMS: Search and replace across multiple objects in a database original ↗

15 Apr 2020

2019

Break out of your comfort zone in 2020.original ↗

31 Dec 2019

Do something else, become better at what you love original ↗

29 Nov 2019

How to use switching to make metadata changes online original ↗

25 Nov 2019

Aggregating date and time values original ↗

10 Oct 2019

Anonymize your dev databases!original ↗

3 Oct 2019

Scan hundreds of SQL Saturday raffle tickets. Fast.original ↗

24 Sept 2019

Calculating invoice settlements with window functions original ↗

16 Sept 2019

How to get an automated alert when your Azure cost takes off original ↗

19 Jun 2019

CAST/CONVERT makes expressions nullable original ↗

5 Jun 2019

Scalar function inlining in SQL Server 2019 original ↗

8 Apr 2019

How to set up a beautiful Powershell Core terminal on Mac OS original ↗

4 Mar 2019

Why and how you should speak at a conference original ↗

19 Feb 2019

Changing the fill factor on multiple tables/indexes original ↗

9 Jan 2019

Nullable columns and performance original ↗

3 Jan 2019

2018

sqlsunday.com downloads are now on GitHub!original ↗

15 Nov 2018

Conference hack: how to get great screenshots from demos original ↗

9 Nov 2018

What’s in my backpack original ↗

18 Oct 2018

Make a Windows shortcut to compare files in Visual Studio original ↗

16 Oct 2018

Operations that need a serial plan original ↗

9 Aug 2018

The SQL Server Calendar project original ↗

16 Jul 2018

T-SQL Tuesday #104: Code you would hate to live without original ↗

10 Jul 2018

Quick and dirty: How to right-align numeric columns in SSMS original ↗

12 Jun 2018

Grouping dates without blocking operators original ↗

14 May 2018

Quiz: What’s going on here, then?original ↗

5 Apr 2018

Get the join cheat sheet!original ↗

19 Feb 2018

An alternative to data masking original ↗

5 Feb 2018

Computed columns with scalar functions original ↗

26 Jan 2018

2017

Encrypting SQL Server connections with Let’s Encrypt certificates original ↗

22 Nov 2017

Can your client or employer read your HTTPS traffic?original ↗

23 Oct 2017

Legacy apps that don’t believe in schemas original ↗

13 Oct 2017

Effective permissions on SQL Server original ↗

27 Sept 2017

Fun with random names original ↗

18 Sept 2017

How good are best practices?original ↗

16 Aug 2017

Prioritizing rows in a union original ↗

26 Jul 2017

Accounting basics for tech people original ↗

16 May 2017

Automatically guessing foreign key constraints original ↗

10 Apr 2017

Finding primary key candidates original ↗

21 Feb 2017

Please don’t feed auditors and lawyers original ↗

17 Feb 2017

Speaking at the Group By conference!original ↗

23 Jan 2017

Practical uses of binary types original ↗

9 Jan 2017

2016

Have you tried sp_ctrl3?original ↗

28 Nov 2016

A visual representation of SQL Server Agent jobs original ↗

17 Nov 2016

A week later: thoughts on the 2016 PASS Summit original ↗

6 Nov 2016

Availability Groups: How to sync logins between replicas original ↗

11 Oct 2016

The compelling case for using heaps original ↗

1 Sept 2016

Not giving a shit about performance is tech-debt original ↗

11 Aug 2016

Human-readable ranges of integers or dates original ↗

3 Aug 2016

Video: three SQL Server join operators in three minutes original ↗

1 Aug 2016

My brand-new T-SQL reference app for Slack original ↗

20 Jul 2016

Comparing nullable columns original ↗

14 Jul 2016

Start Management Studio with alternate Windows credentials original ↗

27 Jun 2016

Copying data with foreign keys and/or identity columns original ↗

16 Jun 2016

Key Lookup without an output column?original ↗

2 Jun 2016

Selectively disable “Include actual execution plan”original ↗

22 May 2016

Calculating the number of weekdays between two dates original ↗

15 May 2016

Detaching a database also alters file permissions original ↗

11 May 2016

A faster Fibonacci series in T-SQL original ↗

30 Apr 2016