corpus.blog
56,966 blogs · [ { "id": "01a087e4-b03f-706d-b529-41af6aa696c7", "title": "#tsql2sday #202 : The Outage(s) I Won't Forget", "url": "https://sqlblog.org/2026/09/08/tsql2sday-202-memorable-outages", "published_at": "2026-09-08T09:01:56+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957edcea4fd", "title": "Dirty Reads, Permanent Damage", "url": "https://sqlblog.org/2026/08/24/dirty-reads-permanent-damage", "published_at": "2026-08-24T15:51:51+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957eebb9414", "title": "A script to script a script that scripts jobs", "url": "https://sqlblog.org/2026/08/18/job-script-cubed", "published_at": "2026-08-18T09:30:07+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957ef4fcab9", "title": "It's Time to Break Up with Archive Tables", "url": "https://sqlblog.org/2026/07/27/break-up-archive-tables", "published_at": "2026-07-27T13:33:11+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957efa851a3", "title": "#tsql2sday #200 : The WRONG JOIN", "url": "https://sqlblog.org/2026/07/14/tsql2sday-200-the-wrong-join", "published_at": "2026-07-14T14:05:45+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957eff1d0b7", "title": "Dealing With Explosive sysjobhistory Growth", "url": "https://sqlblog.org/2026/06/24/explosive-sysjobhistory-growth", "published_at": "2026-06-24T19:05:01+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f038b42c", "title": "Faster planned availability group failovers", "url": "https://sqlblog.org/2026/02/23/faster-ag-failovers", "published_at": "2026-02-23T11:22:13+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f0959e3b", "title": "Common SQL Server Issues: \"An invalid length was passed…\"", "url": "https://sqlblog.org/2026/01/16/invalid-length", "published_at": "2026-01-16T15:43:19+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f0d352fb", "title": "Upgrading to SQL Server 2025: Three Lessons Learned", "url": "https://sqlblog.org/2026/01/15/upgrade-2025-lessons-learned", "published_at": "2026-01-15T13:35:05+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f17ce5f5", "title": "Maximize pagination performance even with filters", "url": "https://sqlblog.org/2025/12/23/filters-and-pagination", "published_at": "2025-12-23T16:37:37+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f243f407", "title": "Achieving constant pagination performance", "url": "https://sqlblog.org/2025/12/18/constant-pagination-performance", "published_at": "2025-12-18T20:00:27+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f29d40df", "title": "Common SQL Server Issues: \"Invalid object name…\"", "url": "https://sqlblog.org/2025/12/18/invalid-object-name", "published_at": "2025-12-18T18:00:51+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f2f68df6", "title": "Sending Slack messages directly from SQL Server 2025", "url": "https://sqlblog.org/2025/12/18/slack-messages-from-sql-2025", "published_at": "2025-12-18T13:13:34+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f3af4ea2", "title": "Hitting APIs and web pages from SQL Server: A brief history", "url": "https://sqlblog.org/2025/12/10/web-page-from-sql-server", "published_at": "2025-12-10T14:54:12+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f42d5ff4", "title": "Managing Underused Indexes in Availability Groups – Part 2", "url": "https://sqlblog.org/2025/10/08/underused-indexes-2", "published_at": "2025-10-08T13:16:21+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f46b850b", "title": "Managing Underused Indexes in Availability Groups – Part 1", "url": "https://sqlblog.org/2025/10/03/underused-indexes-1", "published_at": "2025-10-03T13:18:30+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f531f4a3", "title": "A Rolling Filtered Index for Relative Date Range Queries", "url": "https://sqlblog.org/2025/08/18/rolling-filtered-index", "published_at": "2025-08-18T12:49:33+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f6185625", "title": "RegEx in SQL Server 2025", "url": "https://sqlblog.org/2025/08/04/regex-in-sql-server-2025", "published_at": "2025-08-04T14:44:22+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f70b7545", "title": "Backing Up Hundreds of Databases – Part 2", "url": "https://sqlblog.org/2025/07/24/backing-up-hundreds-of-databases-part-2", "published_at": "2025-07-24T15:27:29+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f74b94e0", "title": "Backing Up Hundreds of Databases – Part 1", "url": "https://sqlblog.org/2025/07/08/backing-up-hundreds-of-databases-part-1", "published_at": "2025-07-08T12:03:38+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f7c43cdc", "title": "Common SQL Server Issues: \"A network-related or instance-specific error…\"", "url": "https://sqlblog.org/2025/07/07/network-related-instance-specific", "published_at": "2025-07-07T16:00:51+00:00" }, { "id": "01a087e4-b040-70cb-9155-2957f8b68ec7", "title": "SQL Server 2025 : ZSTD Compression", "url": "https://sqlblog.org/2025/06/11/sql-server-2025-zstd-compression", "published_at": "2025-06-11T05:09:19+00:00" }, { "id": "01a087e4-b041-72df-b0d8-771d274b612a", "title": "Five changes to SQL Server I’d love to see", "url": "https://sqlblog.org/2025/01/01/five-changes-to-sql-server", "published_at": "2025-01-01T09:00:00+00:00" }, { "id": "01a087e4-b041-72df-b0d8-771d27ea8acc", "title": "Coffee chat with Louis Davidson", "url": "https://sqlblog.org/2024/11/07/coffee-chat-with-louis-davidson", "published_at": "2024-11-07T15:26:43+00:00" }, { "id": "01a087e4-b041-72df-b0d8-771d28a8b70a", "title": "Days of the Week, Bitwise Edition", "url": "https://sqlblog.org/2024/08/02/days-of-the-week-bitwise-edition", "published_at": "2024-08-02T15:00:20+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a47877af", "title": "Index cleanup: Harder than you think", "url": "https://sqlblog.org/2024/07/22/index-cleanup", "published_at": "2024-07-22T17:00:12+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a547b31d", "title": "SQL Server Development on a Mac in 2024", "url": "https://sqlblog.org/2024/07/12/sql-server-mac-2024", "published_at": "2024-07-12T12:43:12+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a63a207e", "title": "It's a recovery strategy, not a backup strategy", "url": "https://sqlblog.org/2024/07/08/recovery-strategy", "published_at": "2024-07-08T09:00:47+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a7149300", "title": "Snake draft sorting, part 4", "url": "https://sqlblog.org/2024/05/27/snake-draft-sorting-part-4", "published_at": "2024-05-27T19:30:18+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a79e7209", "title": "Snake draft sorting, part 3", "url": "https://sqlblog.org/2024/05/15/snake-draft-sorting-part-3", "published_at": "2024-05-15T14:35:54+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a84efe87", "title": "Snake draft sorting, part 2", "url": "https://sqlblog.org/2024/04/15/snake-draft-sorting-part-2", "published_at": "2024-04-15T13:16:54+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a861d86e", "title": "Snake draft sorting, part 1", "url": "https://sqlblog.org/2024/04/12/snake-draft-sorting-part-1", "published_at": "2024-04-12T16:07:36+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a8c0abac", "title": "Pagination and ordering by large string values", "url": "https://sqlblog.org/2024/03/25/pagination-by-large-strings", "published_at": "2024-03-25T15:07:45+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a8dea094", "title": "Get the most out of SQL Server Agent logs", "url": "https://sqlblog.org/2024/03/11/most-sql-agent-logs", "published_at": "2024-03-11T22:29:08+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a93debd0", "title": "Upgrade your workstation to SQL Server 2022", "url": "https://sqlblog.org/2024/02/26/upgrade-your-workstation-to-sql-2022", "published_at": "2024-02-26T12:00:25+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a948b23c", "title": "T-SQL Tuesday #171: A recent issue I sort of closed", "url": "https://sqlblog.org/2024/02/13/t-sql-tuesday-171", "published_at": "2024-02-13T04:00:19+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a94edf70", "title": "Leave it better than you found it", "url": "https://sqlblog.org/2024/02/12/leave-it-better-than-you-found-it", "published_at": "2024-02-12T12:00:03+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21a9c7fa30", "title": "Clean up your setup config file", "url": "https://sqlblog.org/2024/02/01/clean-up-your-setup-config-file", "published_at": "2024-02-01T16:16:42+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21aa755690", "title": "Optimized Locking in Azure SQL Database", "url": "https://sqlblog.org/2024/01/08/optimized-locking-in-azure-sql-db", "published_at": "2024-01-08T01:00:44+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21aadebf38", "title": "2023 : A year in review", "url": "https://sqlblog.org/2024/01/01/2023-a-year-in-review", "published_at": "2024-01-01T23:00:31+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21aafbd35e", "title": "Counting more efficiently", "url": "https://sqlblog.org/2023/12/20/counting-more-efficiently", "published_at": "2023-12-20T09:45:50+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21ab2bc953", "title": "T-SQL Tuesday #169: Thanks!", "url": "https://sqlblog.org/2023/12/12/t-sql-tuesday-169-thanks", "published_at": "2023-12-12T19:40:49+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21ac230d3d", "title": "Just WAITFOR it: Tips for testing in SSMS", "url": "https://sqlblog.org/2023/12/11/just-waitfor-it", "published_at": "2023-12-11T13:56:27+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21acc0e1e8", "title": "An Oracle feature I want in SQL Server", "url": "https://sqlblog.org/2023/12/01/group-by-alias", "published_at": "2023-12-01T13:50:59+00:00" }, { "id": "01a0d1d2-cbe7-73c6-90a4-6c21ad3d5d42", "title": "When an update doesn't update", "url": "https://sqlblog.org/2023/11/27/update-vs-update", "published_at": "2023-11-27T14:00:58+00:00" }, { "id": "01a0d1d2-cbe8-7071-9892-8b5edb7f0a17", "title": "Anatomy of a featured image", "url": "https://sqlblog.org/2023/11/21/the-anatomy-of-a-featured-image", "published_at": "2023-11-21T12:20:39+00:00" }, { "id": "01a0d1d2-cbe8-7071-9892-8b5edc5fdca7", "title": "Strategies for queries against bit columns", "url": "https://sqlblog.org/2023/11/20/strategies-for-bit-columns", "published_at": "2023-11-20T12:20:36+00:00" }, { "id": "01a0d1d2-cbe8-7071-9892-8b5edc617113", "title": "T-SQL Tuesday #168: Window functions", "url": "https://sqlblog.org/2023/11/14/t-sql-tuesday-168-window-functions", "published_at": "2023-11-14T12:00:45+00:00" }, { "id": "01a0d1d2-cbe8-7071-9892-8b5edc6f6bb0", "title": "Unpivoting multiple sets of columns", "url": "https://sqlblog.org/2023/11/08/unpivoting-multiple-sets-of-columns", "published_at": "2023-11-08T13:46:47+00:00" }, { "id": "01a0d1d2-cbe8-7071-9892-8b5edc9a296a", "title": "Modernizing Stack Overflow for Teams", "url": "https://sqlblog.org/2023/11/06/modernizing-stack-overflow-for-teams", "published_at": "2023-11-06T14:00:05+00:00" }, { "id": "01a0d1d3-45c4-73ba-b588-e47f9ccc21f0", "title": "2023 : Community Influencer of the Year", "url": "https://sqlblog.org/2023/11/03/2023-community-influencer", "published_at": "2023-11-03T12:39:16+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047b500094b", "title": "Deployment checklists", "url": "https://sqlblog.org/2023/11/01/deployment-checklists", "published_at": "2023-11-01T12:33:19+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047b5ad871e", "title": "Don’t use DISTINCT as a “join-fixer”", "url": "https://sqlblog.org/2023/10/16/dont-use-distinct-as-a-join-fixer", "published_at": "2023-10-16T12:00:41+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047b66b2302", "title": "Bad Habits and Best Practices", "url": "https://sqlblog.org/2023/10/16/bad-habits-and-best-practices", "published_at": "2023-10-16T00:01:52+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047b6a67a6c", "title": "Oct. '23 security fixes", "url": "https://sqlblog.org/2023/10/12/october-2023-security-fixes-for-sql-server", "published_at": "2023-10-12T12:40:31+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047b70bd115", "title": "SQL Server query performance decay", "url": "https://sqlblog.org/2023/10/10/sql-server-query-performance-decay", "published_at": "2023-10-10T13:19:55+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047b774fbc1", "title": "Normalize strings to optimize space and searches", "url": "https://sqlblog.org/2023/10/02/normalize-strings", "published_at": "2023-10-02T16:00:07+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047b825cbd5", "title": "Manage schema drift", "url": "https://sqlblog.org/2023/08/14/dealing-with-schema-drift", "published_at": "2023-08-14T12:43:09+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047b830c87e", "title": "Changing log growth strategy in SQL Server 2022", "url": "https://sqlblog.org/2023/05/15/log-growth-sql-server-2022", "published_at": "2023-05-15T11:00:01+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047b8a043db", "title": "Always Encrypted: Enhancements since SQL Server 2016", "url": "https://sqlblog.org/2023/05/09/always-encrypted-since-2016", "published_at": "2023-05-09T16:03:14+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047b98eb4fd", "title": "One use case for NOT using schema prefixes", "url": "https://sqlblog.org/2023/04/20/use-case-for-no-schema-prefix", "published_at": "2023-04-20T16:30:35+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047ba6faeee", "title": "GENERATE_SERIES: My new go-to for building sets", "url": "https://sqlblog.org/2023/03/31/generate-series-my-new-go-to", "published_at": "2023-03-31T00:00:34+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047bb234a6e", "title": "Refresh views automatically after schema changes", "url": "https://sqlblog.org/2023/03/22/auto-refresh-views-after-schema-changes", "published_at": "2023-03-22T15:27:23+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047bb246eba", "title": "Build visual calendars with SQL and CSS – Part 3", "url": "https://sqlblog.org/2023/03/10/calendars-sql-css-3", "published_at": "2023-03-10T12:00:19+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047bc1c5544", "title": "Simulate TRY_PARSE in SQL Server 2008", "url": "https://sqlblog.org/2023/03/09/try-parse-sql-server-2008", "published_at": "2023-03-09T15:26:45+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047bce817a2", "title": "Regular SQL Server on Apple Silicon? Yes you can!", "url": "https://sqlblog.org/2023/03/03/sql-server-apple-silicon", "published_at": "2023-03-03T20:28:22+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047bd1696ae", "title": "Find 40 Problems in this Stored Procedure", "url": "https://sqlblog.org/2023/02/23/40-problems-stored-procedure", "published_at": "2023-02-23T23:59:34+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047bd485288", "title": "Build visual calendars with SQL and CSS – Part 2", "url": "https://sqlblog.org/2023/02/22/calendars-sql-css-2", "published_at": "2023-02-22T12:11:03+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047be22b26e", "title": "A minor bandwidth upgrade", "url": "https://sqlblog.org/2023/02/20/a-minor-bandwidth-upgrade", "published_at": "2023-02-20T19:50:39+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047bea78c96", "title": "February 2023: Many updates for SQL Server", "url": "https://sqlblog.org/2023/02/18/february-2023-many-updates-for-sql-server", "published_at": "2023-02-18T20:16:53+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047bf344a15", "title": "Build visual calendars with SQL and CSS – Part 1", "url": "https://sqlblog.org/2023/02/07/calendars-sql-css-1", "published_at": "2023-02-07T19:45:46+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047c0065990", "title": "Protecting personal data in the GDPR era", "url": "https://sqlblog.org/2023/01/13/protecting-pii-gdpr", "published_at": "2023-01-13T09:00:36+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047c007b4e3", "title": "T-SQL Tuesday #158: Worst practices", "url": "https://sqlblog.org/2023/01/10/t-sql-tuesday-158-worst-practices", "published_at": "2023-01-10T15:12:10+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047c0701e8c", "title": "And then there were shirts…", "url": "https://sqlblog.org/2023/01/06/and-then-there-were-shirts", "published_at": "2023-01-06T22:48:32+00:00" }, { "id": "01a0d1d3-45c5-7341-8c30-c047c08290e1", "title": "Stack Overflow's path to the cloud", "url": "https://sqlblog.org/2022/12/22/stack-overflow-path-to-cloud", "published_at": "2022-12-22T19:48:31+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabe9c9d9bf7", "title": "2022 : Community Influencer of the Year", "url": "https://sqlblog.org/2022/12/15/2022-community-influencer", "published_at": "2022-12-15T11:49:27+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabe9cf3db79", "title": "Being a technical mentor for a career, not a role", "url": "https://sqlblog.org/2022/11/24/technical-mentor-career-vs-role", "published_at": "2022-11-24T13:00:06+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabe9d829acb", "title": "SQL Server at Scale – Using an archive table, Part 3", "url": "https://sqlblog.org/2022/11/21/scale-archive-3", "published_at": "2022-11-21T15:21:20+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabe9dab2f05", "title": "SQL Server at Scale – Using an archive table, Part 2", "url": "https://sqlblog.org/2022/11/16/scale-archive-2", "published_at": "2022-11-16T09:00:48+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabe9df9504b", "title": "T-SQL Tuesday #156: Production code", "url": "https://sqlblog.org/2022/11/08/t-sql-tuesday-156-production-code", "published_at": "2022-11-08T09:00:42+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabe9ef329b0", "title": "SQL Server at Scale – Using an archive table, Part 1", "url": "https://sqlblog.org/2022/11/02/scale-archive-1", "published_at": "2022-11-02T13:42:44+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabe9f0577b2", "title": "T-SQL Tuesday #155: Do X to all the databases", "url": "https://sqlblog.org/2022/10/11/t-sql-tuesday-155-do-x-to-all-the-dbs", "published_at": "2022-10-11T01:00:33+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabe9f3fbbae", "title": "Find the 3rd Tuesday or last non-weekday in a month", "url": "https://sqlblog.org/2022/09/13/weekday-calculations", "published_at": "2022-09-13T12:55:48+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabe9fcde7a6", "title": "T-SQL Tuesday #154: SQL Server 2022", "url": "https://sqlblog.org/2022/09/13/t-sql-tuesday-154-sql-server-2022", "published_at": "2022-09-13T09:00:19+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea093ca97", "title": "Comparing DBA / DBRE / SRE roles", "url": "https://sqlblog.org/2022/08/11/comparing-dba-dbre-sre-roles", "published_at": "2022-08-11T14:07:04+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea149202a", "title": "Overcome challenges with GENERATE_SERIES", "url": "https://sqlblog.org/2022/08/09/challenges-generate-series", "published_at": "2022-08-09T13:18:14+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea1e8f5cf", "title": "T-SQL Tuesday #153: A life-changing community event", "url": "https://sqlblog.org/2022/08/09/t-sql-tuesday-153", "published_at": "2022-08-09T00:01:12+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea25cad6e", "title": "My 10 favorite SQLPerformance posts over a decade", "url": "https://sqlblog.org/2022/07/24/sqlperf-10-for-10", "published_at": "2022-07-24T09:00:51+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea348e909", "title": "T-SQL Tuesday #152: Soapboxing", "url": "https://sqlblog.org/2022/07/12/t-sql-tuesday-152-soapboxing", "published_at": "2022-07-12T09:00:07+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea3a415bd", "title": "Using goal posts to reduce scan impact", "url": "https://sqlblog.org/2022/07/07/goal-posts-reduce-scan-impact", "published_at": "2022-07-07T13:03:23+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea3c6eea1", "title": "On Cumulative Updates and GDRs", "url": "https://sqlblog.org/2022/06/24/cu-vs-gdr", "published_at": "2022-06-24T11:00:10+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea462269f", "title": "Who benefits from your technical blog? You do!", "url": "https://sqlblog.org/2022/06/23/who-benefits-technical-blog", "published_at": "2022-06-23T11:00:06+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea55203f5", "title": "What I did in my first month at Stack Overflow", "url": "https://sqlblog.org/2022/06/23/first-month-stack-overflow", "published_at": "2022-06-23T09:00:48+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea5b7926e", "title": "Why shouldn't I create 15,000 partitions in advance?", "url": "https://sqlblog.org/2022/06/21/15k-partitions", "published_at": "2022-06-21T13:35:30+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea5e2a2e3", "title": "T-SQL Tuesday #151: Controversial coding conventions", "url": "https://sqlblog.org/2022/06/14/why-i-use-convert-not-cast", "published_at": "2022-06-14T22:30:16+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea642131d", "title": "T-SQL can be expressive without sacrificing performance", "url": "https://sqlblog.org/2022/06/02/t-sql-expressive", "published_at": "2022-06-02T09:01:43+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea70f90f0", "title": "Why is SQL Server's internal database version important?", "url": "https://sqlblog.org/2022/06/01/internal-database-version", "published_at": "2022-06-01T17:15:40+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea7d480c9", "title": "Obscure changes in SQL Server 2022: ShowPlan", "url": "https://sqlblog.org/2022/05/27/obscure-changes-in-sql-server-2022-part-3-showplan", "published_at": "2022-05-27T12:08:17+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea867fc58", "title": "How to be a more productive DBA / DBRE", "url": "https://sqlblog.org/2022/05/27/more-productive-dba-dbre", "published_at": "2022-05-27T00:02:04+00:00" }, { "id": "01a0d1d3-a0f0-733a-b75a-dabea93908a6", "title": "Obscure changes in SQL Server 2022: Setup", "url": "https://sqlblog.org/2022/05/25/obscure-changes-in-sql-server-2022-part-2-setup", "published_at": "2022-05-25T19:16:49+00:00" } ] posts Claim your blog
Back to sqlblog.org
Blog · corpus.blog/blogs/sqlblog.org/posts

sqlblog.org

sqlblog.org

2026

#tsql2sday #202 : The Outage(s) I Won't Forgetoriginal ↗
8 Sept 2026
Dirty Reads, Permanent Damageoriginal ↗
24 Aug 2026
A script to script a script that scripts jobsoriginal ↗
18 Aug 2026
It's Time to Break Up with Archive Tablesoriginal ↗
27 Jul 2026
#tsql2sday #200 : The WRONG JOINoriginal ↗
14 Jul 2026
Dealing With Explosive sysjobhistory Growthoriginal ↗
24 Jun 2026
Faster planned availability group failoversoriginal ↗
23 Feb 2026
Common SQL Server Issues: "An invalid length was passed…"original ↗
16 Jan 2026
Upgrading to SQL Server 2025: Three Lessons Learnedoriginal ↗
15 Jan 2026

2025

Maximize pagination performance even with filtersoriginal ↗
23 Dec 2025
Achieving constant pagination performanceoriginal ↗
18 Dec 2025
Common SQL Server Issues: "Invalid object name…"original ↗
18 Dec 2025
Sending Slack messages directly from SQL Server 2025original ↗
18 Dec 2025
Hitting APIs and web pages from SQL Server: A brief historyoriginal ↗
10 Dec 2025
Managing Underused Indexes in Availability Groups – Part 2original ↗
8 Oct 2025
Managing Underused Indexes in Availability Groups – Part 1original ↗
3 Oct 2025
A Rolling Filtered Index for Relative Date Range Queriesoriginal ↗
18 Aug 2025
RegEx in SQL Server 2025original ↗
4 Aug 2025
Backing Up Hundreds of Databases – Part 2original ↗
24 Jul 2025
Backing Up Hundreds of Databases – Part 1original ↗
8 Jul 2025
Common SQL Server Issues: "A network-related or instance-specific error…"original ↗
7 Jul 2025
SQL Server 2025 : ZSTD Compressionoriginal ↗
11 Jun 2025
Five changes to SQL Server I’d love to seeoriginal ↗
1 Jan 2025

2024

Coffee chat with Louis Davidsonoriginal ↗
7 Nov 2024
Days of the Week, Bitwise Editionoriginal ↗
2 Aug 2024
Index cleanup: Harder than you thinkoriginal ↗
22 Jul 2024
SQL Server Development on a Mac in 2024original ↗
12 Jul 2024
It's a recovery strategy, not a backup strategyoriginal ↗
8 Jul 2024
Snake draft sorting, part 4original ↗
27 May 2024
Snake draft sorting, part 3original ↗
15 May 2024
Snake draft sorting, part 2original ↗
15 Apr 2024
Snake draft sorting, part 1original ↗
12 Apr 2024
Pagination and ordering by large string valuesoriginal ↗
25 Mar 2024
Get the most out of SQL Server Agent logsoriginal ↗
11 Mar 2024
Upgrade your workstation to SQL Server 2022original ↗
26 Feb 2024
T-SQL Tuesday #171: A recent issue I sort of closedoriginal ↗
13 Feb 2024
Leave it better than you found itoriginal ↗
12 Feb 2024
Clean up your setup config fileoriginal ↗
1 Feb 2024
Optimized Locking in Azure SQL Databaseoriginal ↗
8 Jan 2024
2023 : A year in revieworiginal ↗
1 Jan 2024

2023

Counting more efficientlyoriginal ↗
20 Dec 2023
T-SQL Tuesday #169: Thanks!original ↗
12 Dec 2023
Just WAITFOR it: Tips for testing in SSMSoriginal ↗
11 Dec 2023
An Oracle feature I want in SQL Serveroriginal ↗
1 Dec 2023
When an update doesn't updateoriginal ↗
27 Nov 2023
Anatomy of a featured imageoriginal ↗
21 Nov 2023
Strategies for queries against bit columnsoriginal ↗
20 Nov 2023
T-SQL Tuesday #168: Window functionsoriginal ↗
14 Nov 2023
Unpivoting multiple sets of columnsoriginal ↗
8 Nov 2023
Modernizing Stack Overflow for Teamsoriginal ↗
6 Nov 2023
2023 : Community Influencer of the Yearoriginal ↗
3 Nov 2023
Deployment checklistsoriginal ↗
1 Nov 2023
Don’t use DISTINCT as a “join-fixer”original ↗
16 Oct 2023
Bad Habits and Best Practicesoriginal ↗
16 Oct 2023
Oct. '23 security fixesoriginal ↗
12 Oct 2023
SQL Server query performance decayoriginal ↗
10 Oct 2023
Normalize strings to optimize space and searchesoriginal ↗
2 Oct 2023
Manage schema driftoriginal ↗
14 Aug 2023
Changing log growth strategy in SQL Server 2022original ↗
15 May 2023
Always Encrypted: Enhancements since SQL Server 2016original ↗
9 May 2023
One use case for NOT using schema prefixesoriginal ↗
20 Apr 2023
GENERATE_SERIES: My new go-to for building setsoriginal ↗
31 Mar 2023
Refresh views automatically after schema changesoriginal ↗
22 Mar 2023
Build visual calendars with SQL and CSS – Part 3original ↗
10 Mar 2023
Simulate TRY_PARSE in SQL Server 2008original ↗
9 Mar 2023
Regular SQL Server on Apple Silicon? Yes you can!original ↗
3 Mar 2023
Find 40 Problems in this Stored Procedureoriginal ↗
23 Feb 2023
Build visual calendars with SQL and CSS – Part 2original ↗
22 Feb 2023
A minor bandwidth upgradeoriginal ↗
20 Feb 2023
February 2023: Many updates for SQL Serveroriginal ↗
18 Feb 2023
Build visual calendars with SQL and CSS – Part 1original ↗
7 Feb 2023
Protecting personal data in the GDPR eraoriginal ↗
13 Jan 2023
T-SQL Tuesday #158: Worst practicesoriginal ↗
10 Jan 2023
And then there were shirts…original ↗
6 Jan 2023

2022

Stack Overflow's path to the cloudoriginal ↗
22 Dec 2022
2022 : Community Influencer of the Yearoriginal ↗
15 Dec 2022
Being a technical mentor for a career, not a roleoriginal ↗
24 Nov 2022
SQL Server at Scale – Using an archive table, Part 3original ↗
21 Nov 2022
SQL Server at Scale – Using an archive table, Part 2original ↗
16 Nov 2022
T-SQL Tuesday #156: Production codeoriginal ↗
8 Nov 2022
SQL Server at Scale – Using an archive table, Part 1original ↗
2 Nov 2022
T-SQL Tuesday #155: Do X to all the databasesoriginal ↗
11 Oct 2022
Find the 3rd Tuesday or last non-weekday in a monthoriginal ↗
13 Sept 2022
T-SQL Tuesday #154: SQL Server 2022original ↗
13 Sept 2022
Comparing DBA / DBRE / SRE rolesoriginal ↗
11 Aug 2022
Overcome challenges with GENERATE_SERIESoriginal ↗
9 Aug 2022
T-SQL Tuesday #153: A life-changing community eventoriginal ↗
9 Aug 2022
My 10 favorite SQLPerformance posts over a decadeoriginal ↗
24 Jul 2022
T-SQL Tuesday #152: Soapboxingoriginal ↗
12 Jul 2022
Using goal posts to reduce scan impactoriginal ↗
7 Jul 2022
On Cumulative Updates and GDRsoriginal ↗
24 Jun 2022
Who benefits from your technical blog? You do!original ↗
23 Jun 2022
What I did in my first month at Stack Overfloworiginal ↗
23 Jun 2022
Why shouldn't I create 15,000 partitions in advance?original ↗
21 Jun 2022
T-SQL Tuesday #151: Controversial coding conventionsoriginal ↗
14 Jun 2022
T-SQL can be expressive without sacrificing performanceoriginal ↗
2 Jun 2022
Why is SQL Server's internal database version important?original ↗
1 Jun 2022
Obscure changes in SQL Server 2022: ShowPlanoriginal ↗
27 May 2022
How to be a more productive DBA / DBREoriginal ↗
27 May 2022
Obscure changes in SQL Server 2022: Setuporiginal ↗
25 May 2022
Next