corpus.blog
41554 blogs · [ { "id": "01a08794-be22-726d-aa92-b44f1b8c75bc", "title": "Your AI Doesn't Need to Dig Around in Production Databases. It Needs Better Briefings.", "url": "https://kendralittle.com/2026/06/29/ai-database-architecture-mcp-observability/", "published_at": "2026-06-29T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f1c63d8f2", "title": "Bad News, DBAs, We Are All Developers Now", "url": "https://kendralittle.com/2026/02/09/bad-news-dbas-we-are-all-developers-now/", "published_at": "2026-02-09T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f1cd0b9a6", "title": "Adaptive Joins and Memory Grants in SQL Server", "url": "https://kendralittle.com/2026/01/26/adaptive-joins-and-memory-grants-in-sql-server/", "published_at": "2026-01-26T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f1d9fc7b6", "title": "Carrying Baggage Through Query Plans: Why Wide Queries Get Heavy", "url": "https://kendralittle.com/2026/01/19/carrying-baggage-through-query-plans-why-wide-queries-get-heavy/", "published_at": "2026-01-19T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f1e1ef147", "title": "Testing SQL Server 2025 Resource Governor tempdb Limits with a Query that Spills a Terabyte", "url": "https://kendralittle.com/2026/01/12/testing-sql-server-2025-resource-governor-tempdb-limits/", "published_at": "2026-01-12T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f1f093331", "title": "How to Trace Trigger Executions with Query Store and Extended Events", "url": "https://kendralittle.com/2026/01/05/how-to-trace-trigger-executions-with-query-store-and-extended-events/", "published_at": "2026-01-05T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f1f9a6d55", "title": "Static Site Improvements: Scheduled Posts, Preview Builds, Robots Writing the CSS", "url": "https://kendralittle.com/2025/12/22/static-site-workflows-that-work-scheduled-posts-preview-builds-robots-writing-css/", "published_at": "2025-12-22T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f1ff015d9", "title": "How to Filter RPC_Completed Events in Extended Events: SQL Server Guide", "url": "https://kendralittle.com/2025/12/15/how-to-filter-rpc-completed-events-extended-events/", "published_at": "2025-12-15T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2088677e", "title": "Erik Darling and Kendra Little Talk AI, Databases, and SQL Server 2025", "url": "https://kendralittle.com/2025/12/09/erik-darling-kendra-little-talk-ai-databases-sql-server-2025-dear-sql-dba/", "published_at": "2025-12-09T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f21492754", "title": "Azure SQL Managed Instance Memory-to-Core Math Still Doesn't Work, Even in GPv2", "url": "https://kendralittle.com/2025/12/08/azure-sql-managed-instance-memory-to-core-math-still-doesnt-work-even-in-gpv2/", "published_at": "2025-12-08T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f21635e63", "title": "Index Bloat in Postgres: Why It Matters, How to Identify, How to Resolve", "url": "https://kendralittle.com/2025/12/01/index-bloat-postgres-why-it-matters-how-to-identify-and-resolve/", "published_at": "2025-12-01T10:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f21cdfd8b", "title": "How to See Rowcounts and Execution Time for In-Flight Queries in SQL Server", "url": "https://kendralittle.com/2025/11/24/how-to-see-rowcounts-execution-time-in-flight-queries-sql-server/", "published_at": "2025-11-24T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f21d02997", "title": "Three Reasons RDS SQL Server Is Better Than Azure SQL Managed Instance", "url": "https://kendralittle.com/2025/10/08/three-differentiators-rds-sql-server-managed-database-cloud/", "published_at": "2025-10-08T18:25:57+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f21fa9d5d", "title": "Why Won't PostgreSQL Use My Covering Index?", "url": "https://kendralittle.com/2025/06/26/why-wont-postgresql-use-covering-index/", "published_at": "2025-06-26T23:43:14+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f221ed4ef", "title": "Fixing OPTIMIZATION REPLAY FAILED in Query Store: When Plan Forcing Breaks in SQL Server 2022+", "url": "https://kendralittle.com/2025/04/30/fix_optimization_replay_failed_plan_forcing_sql_server_query_store/", "published_at": "2025-04-30T15:04:28+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f224089b3", "title": "Comparing Single Column, Multi-Column, and Filtered Statistics in SQL Server", "url": "https://kendralittle.com/2025/04/13/single-multi-column-filtered-statistics/", "published_at": "2025-04-13T18:04:35+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2290dff9", "title": "All Eyes on the Wrong Problem: How Mitigations Distract from Real Performance Pain", "url": "https://kendralittle.com/2025/04/06/acclimating-users-bad-makes-miss-truly-terrible/", "published_at": "2025-04-06T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f22a29c10", "title": "100 Things I Hate About Views: Undeclared Data Types in Columns", "url": "https://kendralittle.com/2025/03/14/views-data-type-undeclared-int-sql-server/", "published_at": "2025-03-14T21:44:51+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f22ac31c0", "title": "What the Decline of SQL Server Quality Means for Developers and DBAs", "url": "https://kendralittle.com/2025/03/10/what-the-decline-of-sql-server-quality-means-developers-dbas/", "published_at": "2025-03-10T12:55:51+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2346831d", "title": "AI Will Eliminate DBA Jobs Faster Than You Think", "url": "https://kendralittle.com/2025/03/02/ai-will-eliminate-dba-jobs-faster-than-you-think/", "published_at": "2025-03-02T15:18:54+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f237bc8b3", "title": "How to Stop SSDT / Database Projects / SQLPackage from Modifying Database Options", "url": "https://kendralittle.com/2025/02/13/sqlpackage-how-to-stop-deploy-changing-database-options/", "published_at": "2025-02-13T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f24601fed", "title": "Buyer Beware: Azure SQL Managed Instance Storage Is Regularly as Slow as 60 Seconds", "url": "https://kendralittle.com/2024/12/18/azure-sql-managed-instance-storage-regularly-slow-60-seconds/", "published_at": "2024-12-18T14:26:20+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f24e4a3f3", "title": "Query Hash Values Are Meaningless in SQL Server: They May Be Reset to Be the Same Value as the Query Plan Hash", "url": "https://kendralittle.com/2024/11/24/query-hash-values-meaningless-same-as-query-plan-hash-sql-server/", "published_at": "2024-11-24T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f24f25b60", "title": "What Is the CPU Wait in Datadog SQL Server Monitoring? How Does It Compare to Waiting on CPU?", "url": "https://kendralittle.com/2024/11/21/what-is-the-cpu-wait-datadog-sql-server/", "published_at": "2024-11-21T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f256181fc", "title": "How to Survive Opening a Microsoft Support Ticket for SQL Server or Azure SQL", "url": "https://kendralittle.com/2024/09/23/how-survive-microsoft-support-ticket-sql-server-azure-sql/", "published_at": "2024-09-23T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f25618208", "title": "SQL Server Page Compression: Should You Worry About CPU Usage Increasing on Inserts, Updates, and Deletes?", "url": "https://kendralittle.com/2024/09/08/sql-server-page-compression-cpu-on-insert-update-delete/", "published_at": "2024-09-08T16:48:50+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f26195cca", "title": "Script to Automate Unforcing Failed Forced Plans in Query Store (SQL Server)", "url": "https://kendralittle.com/2024/09/02/free-script-automate-unforcing-failed-forced-plans-query-store-sql-server/", "published_at": "2024-09-02T15:35:40+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f263c5265", "title": "Please Compress Your Indexes and Shrink Your Databases If You Use Azure SQL Managed Instance", "url": "https://kendralittle.com/2024/08/26/please-compress-indexes-and-shrink-your-database-azure-sql-managed-instance/", "published_at": "2024-08-26T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f26aa0a5f", "title": "Error 1119 When Shrinking Database: Removing IAM Page Failed", "url": "https://kendralittle.com/2024/08/20/error-1119-sql-server-shrinking-database-removing-iam-page-failed/", "published_at": "2024-08-20T23:32:07+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f27a95232", "title": "General Failure Failed Forced Plans in Query Store Cause Even Slower Compile Times", "url": "https://kendralittle.com/2024/08/12/query-store-failed-forced-plans-general-failure-even-slower-compile-time/", "published_at": "2024-08-12T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f280c1dc1", "title": "Slow Storage Can Cause Slow Compilation Time in SQL Server", "url": "https://kendralittle.com/2024/08/08/slow-storage-can-cause-slow-compilation-time-sql-server/", "published_at": "2024-08-08T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f28b159d9", "title": "The Restore-AzSqlInstanceDatabase Long Running Operation Failed Error on Azure SQL Managed Instance", "url": "https://kendralittle.com/2024/05/30/restore-azsqlinstancedatabase-long-running-operation-failed-an-unexpected-error-occured-azure-sql-managed-instance/", "published_at": "2024-05-30T11:56:08+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f29a67d9a", "title": "Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques", "url": "https://kendralittle.com/2024/05/20/erik-darling-and-kendra-little-rate-sql-server-performance-tuning-techniques/", "published_at": "2024-05-20T14:12:32+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2aa31359", "title": "Finally, a SQL Server Monitoring System That Leverages Query Store", "url": "https://kendralittle.com/2024/05/15/finally-a-sql-server-monitoring-system-query-store/", "published_at": "2024-05-15T23:14:39+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2b8cc2fa", "title": "Learn Perf Tuning in 2 Days at PASS Summit 2024 With Erik Darling and Kendra Little", "url": "https://kendralittle.com/2024/05/01/two-precons-performance-tuning-pass-summit-2024-erik-darling-kendra-little/", "published_at": "2024-05-01T12:15:30+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2be414cd", "title": "Query Store Size Based Cleanup Causes Performance Problems - How to Avoid It", "url": "https://kendralittle.com/2024/04/23/query-store-size-based-cleanup-performance-problems-avoid/", "published_at": "2024-04-23T11:47:55+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2ca4f2e0", "title": "Top 5 Toxic Flavors of Tech Execs", "url": "https://kendralittle.com/2024/04/11/top-5-toxic-flavors-of-tech-execs/", "published_at": "2024-04-11T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2cb58fab", "title": "Something Weird Happened: I Love My Job Again", "url": "https://kendralittle.com/2024/03/26/something-weird-happened-i-love-my-job-again/", "published_at": "2024-03-26T12:32:04+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2d609ed3", "title": "You Will Not Find Long Compilers Who Time Out in Query Store", "url": "https://kendralittle.com/2024/03/05/long-compilers-who-time-out-not-in-query-store/", "published_at": "2024-03-05T13:40:57+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2da03fa3", "title": "How to Start an XEvents Trace on a Read Scale-Out Azure SQL Managed Instance", "url": "https://kendralittle.com/2024/02/29/xevents-trace-azure-sql-managed-instance-read-scale-out/", "published_at": "2024-02-29T13:21:15+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2e0982ca", "title": "Should You Use SQL Server Readable Secondaries If Queries Can Fail Repeatedly at Any Time?", "url": "https://kendralittle.com/2024/02/21/queries-against-readable-availability-group-secondaries-may-fail-repeatedly-until-you-intervene/", "published_at": "2024-02-21T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2e771ad8", "title": "Ugly Bug: SQL Server Online Index Rebuild Sometimes Happens Offline Without Warning", "url": "https://kendralittle.com/2024/02/07/sql-server-online-index-rebuild-offline-blocking-outage/", "published_at": "2024-02-07T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2f1eabef", "title": "Is the Azure SQL Managed Instance Business Critical Service Tier Worth the Cost?", "url": "https://kendralittle.com/2024/01/29/is-azure-sql-managed-instance-business-critical-service-tier-worth-the-cost/", "published_at": "2024-01-29T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f2fb8a4f0", "title": "Azure SQL Managed Instance General Purpose Architecture and Performance/Cost Tradeoffs", "url": "https://kendralittle.com/2024/01/22/azure-sql-managed-instance-general-purpose-architecture/", "published_at": "2024-01-22T14:26:35+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f30778e55", "title": "Automatic Plan Correction Could Be a Great Auto Tuning Feature for SQL Server: Here Is What It Needs", "url": "https://kendralittle.com/2024/01/17/automatic-plan-forcing-could-be-great-but-isnt-sql-server/", "published_at": "2024-01-17T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3095d354", "title": "Power BI Performance Tuning with Eugene Meidinger", "url": "https://kendralittle.com/2024/01/16/power-bi-performance-tuning-eugene-meidinger/", "published_at": "2024-01-16T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f30edf212", "title": "Microsoft is Breaking Database Compatibility Levels for SQL Server", "url": "https://kendralittle.com/2023/12/18/how-microsoft-breaking-database-compatibility-level-sql-server/", "published_at": "2023-12-18T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f312a744d", "title": "Getting Around Error 40510 to Configure Resource Governor in Azure SQL Managed Instance", "url": "https://kendralittle.com/2023/12/15/error_40510_resource_governor_azure_sql_managed_instance/", "published_at": "2023-12-15T13:42:12+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3194fec8", "title": "How Many Features Are Missing from Azure SQL Managed Instance?", "url": "https://kendralittle.com/2023/12/08/what-features-are-missing-from-azure-sql-managed-instance/", "published_at": "2023-12-09T02:45:01+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f32403ce4", "title": "Lost Updates Under Read Committed Snapshot Isolation (RCSI)", "url": "https://kendralittle.com/2023/10/04/lost-updates-rcsi/", "published_at": "2023-10-04T12:28:49+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f32ad61dd", "title": "Automated Deployments and the Art of the Database with Database Michael J Swart", "url": "https://kendralittle.com/2023/09/26/automated-deployments-art-of-database-michael-j-swart/", "published_at": "2023-09-26T15:39:38+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f334acfb9", "title": "PAGELATCH, PAGEIOLATCH, and LATCH Waits in SQL Server", "url": "https://kendralittle.com/2023/09/12/sql-server-wait-stats-pagelatch-pageiolatch-latch/", "published_at": "2023-09-12T13:59:09+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f33c1d14e", "title": "Jer and Kendar Explore Optimized Locking", "url": "https://kendralittle.com/2023/09/04/jer-and-kendar-explore-optimized-locking/", "published_at": "2023-09-04T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f33df1d91", "title": "Dear SQL DBA - Advice for Technical Leaders with Alex Robson", "url": "https://kendralittle.com/2023/08/31/dear-sql-dba-advice-for-technical-leaders-alex-robson/", "published_at": "2023-08-31T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f345966cd", "title": "Msg 195: STRING_SPLIT Is Not a Recognized Built-In Function Name", "url": "https://kendralittle.com/2023/08/25/string_split-is-not-a-recognized-built-in-function-name/", "published_at": "2023-08-25T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f34f5b93e", "title": "Dear SQL DBA - Performance Tuning with Erik Darling", "url": "https://kendralittle.com/2023/08/18/dear-sql-dba-performance-tuning-erik-darling/", "published_at": "2023-08-18T20:37:14+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f35e35dbb", "title": "What To Do When They Are Sure It Was The Database... All The Time", "url": "https://kendralittle.com/2023/08/15/database-vibe-check/", "published_at": "2023-08-15T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f36765b62", "title": "Dear SQL DBA: Tech Interviews in 2023 With Jeremiah Peschka", "url": "https://kendralittle.com/2023/08/11/dear-sql-dba-tech-interviews-jeremiah-peschka/", "published_at": "2023-08-11T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f37284b96", "title": "Database DevOps Core Concepts: Migration Scripts", "url": "https://kendralittle.com/2023/08/09/database-devops-core-concepts-migration-scripts/", "published_at": "2023-08-09T14:52:03+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3765ccb7", "title": "Dear SQL DBA - Data Roles: DBA, DBRE, and Data Engineer", "url": "https://kendralittle.com/2023/08/04/dear-sql-dba-data-roles-dba-dbre-de/", "published_at": "2023-08-04T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3783dfd9", "title": "Why Not Call Database DevOps Simply DevOps?", "url": "https://kendralittle.com/2023/07/28/what-is-database-devops/", "published_at": "2023-07-28T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f37e10f2c", "title": "The Difference Between DBAs, DBREs, and Data Engineers", "url": "https://kendralittle.com/2023/07/26/data-careers-dba-dbre-data-engineer/", "published_at": "2023-07-26T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f388cf740", "title": "Should We Do Index Maintenance on an Azure SQL Managed Instance or Azure SQL Database?", "url": "https://kendralittle.com/2023/07/17/should-i-do-index-maintenance-azure-sql-managed-instance/", "published_at": "2023-07-17T12:38:02+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f38a742ef", "title": "Even Smart People Make Terrible Data Modeling Decisions", "url": "https://kendralittle.com/2023/07/11/smart-people-make-bad-data-modeling-decisions/", "published_at": "2023-07-11T13:28:46+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f38cc485f", "title": "My Performance Tuning Precon and Git Session at PASS Data Community Summit 2023", "url": "https://kendralittle.com/2023/07/10/pass-data-community-summit-2023/", "published_at": "2023-07-10T14:11:37+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3952d6a1", "title": "Adding a Netlify Contact Form to a Hugo Static Site", "url": "https://kendralittle.com/2023/06/29/adding-netlify-contact-form-hugo-mainroad/", "published_at": "2023-06-29T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3a2b4edb", "title": "Is It OK to Show My Database Schema to ChatGPT and GitHub Copilot?", "url": "https://kendralittle.com/2023/06/23/chat-gpt-copilot-data-privacy-questions/", "published_at": "2023-06-23T14:12:56+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3aac937e", "title": "When NOT to Choose SQL Server to Store Your Data", "url": "https://kendralittle.com/2023/06/21/when-not-to-choose-sql-server/", "published_at": "2023-06-21T16:29:57+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3b82b9bc", "title": "Career Navigation in the Time of Tech Layoffs", "url": "https://kendralittle.com/2023/05/23/career-planning-styles-in-times-layoffs/", "published_at": "2023-05-23T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3c7744c8", "title": "ChatGPT Says SSMS Is the Best SQL Server Monitoring Tool", "url": "https://kendralittle.com/2023/05/03/ssms-is-the-best-sql-server-monitoring-tool-chatgpt/", "published_at": "2023-05-03T12:27:18+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3d29ad1b", "title": "Use ChatGPT to See Multiple Perspectives: An Example With ORMs and Database Code", "url": "https://kendralittle.com/2023/01/24/chat-gpt-discusses-orms-and-databases/", "published_at": "2023-01-24T00:00:00+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3dc46240", "title": "3 Lessons Learned About Azure SQL Database", "url": "https://kendralittle.com/2023/01/15/azure-sql-database-nuances-forget/", "published_at": "2023-01-15T18:02:14+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3e309a90", "title": "New Article on Performance Tuning with the Missing Indexes Feature in SQL Server", "url": "https://kendralittle.com/2022/03/18/missing-indexes-sql-server/", "published_at": "2022-03-18T12:06:28+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3e562096", "title": "Find Query Execution Timeouts with Query Store", "url": "https://kendralittle.com/2022/03/11/find-execution-timeouts-query-store/", "published_at": "2022-03-11T14:01:08+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3f47bb59", "title": "Index Design Guide Updated: Index Types, B+ Trees, and Row Locators, Oh My", "url": "https://kendralittle.com/2022/02/23/index-design-guide-updated-btrees-row-locators/", "published_at": "2022-02-23T13:38:18+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f3fcd94cc", "title": "Workers vs. Requests in Azure SQL Database", "url": "https://kendralittle.com/2022/01/18/workers-requests-azure-sql-database/", "published_at": "2022-01-18T22:36:30+00:00" }, { "id": "01a08794-be22-726d-aa92-b44f40acf59d", "title": "What I Learned Writing About How to Diagnose and Troubleshoot High CPU in Azure SQL Database", "url": "https://kendralittle.com/2022/01/05/what-i-learned-writing-diagnose-and-troubleshoot-high-cpu-azure-sql-database/", "published_at": "2022-01-05T15:56:52+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f95136340e2", "title": "Addressing the Rumors That I Have Been Removed from the MVP Program", "url": "https://kendralittle.com/2021/11/04/working-at-microsoft-senior-content-developer/", "published_at": "2021-11-04T20:24:12+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f95140a7223", "title": "Gotchas with Deferred Name Resolution in SQL Server: Stored Procedures, Synonyms, Views, and Functions", "url": "https://kendralittle.com/2021/10/18/deferred-name-resolution-in-sql-server-stored-procedures-views-functions/", "published_at": "2021-10-18T10:14:16+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f9514120b52", "title": "Learn Azure SQL with One Free Learning Path", "url": "https://kendralittle.com/2021/10/14/learn-azure-sql-free-learning-path/", "published_at": "2021-10-14T08:03:05+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f9514563a51", "title": "New Tricks I Learned from the Azure Data Studio Code Editor Tutorial", "url": "https://kendralittle.com/2021/10/07/trying-out-azure-data-studio-quickstart/", "published_at": "2021-10-07T14:00:03+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951538624a", "title": "Trying Out the Azure SQL Database Quickstart", "url": "https://kendralittle.com/2021/10/04/azure-sql-database-quickstart/", "published_at": "2021-10-04T10:19:52+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f9515efe2f6", "title": "Tutorial: Create a Disposable SQL Server Database Container in an Azure DevOps Pipeline With Spawn", "url": "https://kendralittle.com/2021/07/13/creating-a-disposable-sql-server-database-container-in-azure-devops-pipelines-with-spawn/", "published_at": "2021-07-13T10:13:31+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f95167be4f3", "title": "The HBO Max Integration Test Email Means You Should Make Automation Safer: For Everyone", "url": "https://kendralittle.com/2021/06/18/make-your-tech-safer-for-your-interns-and-everyone-else/", "published_at": "2021-06-18T15:15:47+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f9517347732", "title": "Managing Drift in Automated Deployments to SQL Server Databases", "url": "https://kendralittle.com/2021/06/04/managing-drift-automated-deployments-sql-server/", "published_at": "2021-06-04T11:17:48+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f9517bdca41", "title": "Why NoSQL Database Adoption Is Not a One Way Journey", "url": "https://kendralittle.com/2021/05/27/nosql-database-adoption-isnt-a-one-way-journey/", "published_at": "2021-05-27T07:34:12+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f95187ded80", "title": "My Sketchnotes from Redgate Level Up Week 2021", "url": "https://kendralittle.com/2021/05/24/sketchnotes-from-level-up-week-2021/", "published_at": "2021-05-24T16:39:17+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f95190e919c", "title": "Azure Static Web Apps Are Now Generally Available", "url": "https://kendralittle.com/2021/05/18/azure-static-sites-are-now-generally-available/", "published_at": "2021-05-18T06:31:05+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951968f667", "title": "Maintaining Balance While Retraining in a New Professional Area", "url": "https://kendralittle.com/2021/05/10/balance-while-retraining-new-professional-area/", "published_at": "2021-05-10T00:00:00+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951a2cd8e8", "title": "How I Got Twitter Cards Working in Hugo with the Mainroad Theme", "url": "https://kendralittle.com/2021/05/07/how-i-got-twitter-cards-working-hugo-mainroad/", "published_at": "2021-05-07T00:00:00+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951b06ce7a", "title": "How to Enable TCP/IP in SQL Server Developer Edition, Even If the Configuration Manager Is Missing", "url": "https://kendralittle.com/2021/05/05/how-to-enable-tcpip-in-sql-server-even-if-configuration-manager-is-missing/", "published_at": "2021-05-05T16:46:08+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951ba87d4d", "title": "Moving From WordPress to an Azure Static Site with Hugo", "url": "https://kendralittle.com/2021/05/03/moving-from-wordpress-to-an-azure-static-site-with-hugo/", "published_at": "2021-05-03T00:00:00+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951c0eaffa", "title": "Help Me Not Be Selected to Speak at the Dativerse Virtual Conference", "url": "https://kendralittle.com/2021/04/22/help-me-not-be-selected-to-speak-at-the-dativerse-virtual-conference/", "published_at": "2021-04-22T00:00:00+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951cefcc32", "title": "Free Virtual Event: Mental Health and Awareness Day on May 7th", "url": "https://kendralittle.com/2021/04/21/free-virtual-event-mental-health-and-awareness-day-on-may-7th/", "published_at": "2021-04-21T00:00:00+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951d37acfb", "title": "Ten Ideas to Improve Online Tech Conferences", "url": "https://kendralittle.com/2020/11/18/ten-ideas-to-improve-online-tech-conferences/", "published_at": "2020-11-18T00:00:00+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951dae2d14", "title": "Coping with the Pandemic (T-SQL Tuesday #132)", "url": "https://kendralittle.com/2020/11/10/coping-with-the-pandemic-t-sql-tuesday-132/", "published_at": "2020-11-10T00:00:00+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951ddf4f59", "title": "Down Tools Week 2020 (10 minute video/podcast episode)", "url": "https://kendralittle.com/2020/08/06/down-tools-week-2020-10-minute-video-podcast-episode/", "published_at": "2020-08-06T00:00:00+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951e6f6b9f", "title": "Common Antipatterns in Database Development (28 minute video/podcast episode)", "url": "https://kendralittle.com/2020/07/30/things-that-shouldnt-be-normal-in-database-development-28-minute-video-podcast-episode/", "published_at": "2020-07-30T00:00:00+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951edddfc9", "title": "Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)", "url": "https://kendralittle.com/2020/07/16/everything-i-never-wanted-to-know-about-collation-14-minute-video-podcast-episode/", "published_at": "2020-07-16T00:00:00+00:00" }, { "id": "01a08794-be23-71d2-a8b4-5f951fb06400", "title": "How to Spell and Capitalize tempdb for SQL Server", "url": "https://kendralittle.com/2020/07/15/how-to-spell-and-capitalize-tempdb-for-sql-server/", "published_at": "2020-07-15T00:00:00+00:00" } ] posts Claim your blog
Back to kendralittle.com
Blog · corpus.blog/blogs/kendralittle.com/posts

kendralittle.com

kendralittle.com

2026

Your AI Doesn't Need to Dig Around in Production Databases. It Needs Better Briefings.original ↗
29 Jun 2026
Bad News, DBAs, We Are All Developers Noworiginal ↗
9 Feb 2026
Adaptive Joins and Memory Grants in SQL Serveroriginal ↗
26 Jan 2026
Carrying Baggage Through Query Plans: Why Wide Queries Get Heavyoriginal ↗
19 Jan 2026
Testing SQL Server 2025 Resource Governor tempdb Limits with a Query that Spills a Terabyteoriginal ↗
12 Jan 2026
How to Trace Trigger Executions with Query Store and Extended Eventsoriginal ↗
5 Jan 2026

2025

Static Site Improvements: Scheduled Posts, Preview Builds, Robots Writing the CSSoriginal ↗
22 Dec 2025
How to Filter RPC_Completed Events in Extended Events: SQL Server Guideoriginal ↗
15 Dec 2025
Erik Darling and Kendra Little Talk AI, Databases, and SQL Server 2025original ↗
9 Dec 2025
Azure SQL Managed Instance Memory-to-Core Math Still Doesn't Work, Even in GPv2original ↗
8 Dec 2025
Index Bloat in Postgres: Why It Matters, How to Identify, How to Resolveoriginal ↗
1 Dec 2025
How to See Rowcounts and Execution Time for In-Flight Queries in SQL Serveroriginal ↗
24 Nov 2025
Three Reasons RDS SQL Server Is Better Than Azure SQL Managed Instanceoriginal ↗
8 Oct 2025
Why Won't PostgreSQL Use My Covering Index?original ↗
26 Jun 2025
Fixing OPTIMIZATION REPLAY FAILED in Query Store: When Plan Forcing Breaks in SQL Server 2022+original ↗
30 Apr 2025
Comparing Single Column, Multi-Column, and Filtered Statistics in SQL Serveroriginal ↗
13 Apr 2025
All Eyes on the Wrong Problem: How Mitigations Distract from Real Performance Painoriginal ↗
6 Apr 2025
100 Things I Hate About Views: Undeclared Data Types in Columnsoriginal ↗
14 Mar 2025
What the Decline of SQL Server Quality Means for Developers and DBAsoriginal ↗
10 Mar 2025
AI Will Eliminate DBA Jobs Faster Than You Thinkoriginal ↗
2 Mar 2025
How to Stop SSDT / Database Projects / SQLPackage from Modifying Database Optionsoriginal ↗
13 Feb 2025

2024

Buyer Beware: Azure SQL Managed Instance Storage Is Regularly as Slow as 60 Secondsoriginal ↗
18 Dec 2024
Query Hash Values Are Meaningless in SQL Server: They May Be Reset to Be the Same Value as the Query Plan Hashoriginal ↗
24 Nov 2024
What Is the CPU Wait in Datadog SQL Server Monitoring? How Does It Compare to Waiting on CPU?original ↗
21 Nov 2024
How to Survive Opening a Microsoft Support Ticket for SQL Server or Azure SQLoriginal ↗
23 Sept 2024
SQL Server Page Compression: Should You Worry About CPU Usage Increasing on Inserts, Updates, and Deletes?original ↗
8 Sept 2024
Script to Automate Unforcing Failed Forced Plans in Query Store (SQL Server)original ↗
2 Sept 2024
Please Compress Your Indexes and Shrink Your Databases If You Use Azure SQL Managed Instanceoriginal ↗
26 Aug 2024
Error 1119 When Shrinking Database: Removing IAM Page Failedoriginal ↗
20 Aug 2024
General Failure Failed Forced Plans in Query Store Cause Even Slower Compile Timesoriginal ↗
12 Aug 2024
Slow Storage Can Cause Slow Compilation Time in SQL Serveroriginal ↗
8 Aug 2024
The Restore-AzSqlInstanceDatabase Long Running Operation Failed Error on Azure SQL Managed Instanceoriginal ↗
30 May 2024
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniquesoriginal ↗
20 May 2024
Finally, a SQL Server Monitoring System That Leverages Query Storeoriginal ↗
15 May 2024
Learn Perf Tuning in 2 Days at PASS Summit 2024 With Erik Darling and Kendra Littleoriginal ↗
1 May 2024
Query Store Size Based Cleanup Causes Performance Problems - How to Avoid Itoriginal ↗
23 Apr 2024
Top 5 Toxic Flavors of Tech Execsoriginal ↗
11 Apr 2024
Something Weird Happened: I Love My Job Againoriginal ↗
26 Mar 2024
You Will Not Find Long Compilers Who Time Out in Query Storeoriginal ↗
5 Mar 2024
How to Start an XEvents Trace on a Read Scale-Out Azure SQL Managed Instanceoriginal ↗
29 Feb 2024
Should You Use SQL Server Readable Secondaries If Queries Can Fail Repeatedly at Any Time?original ↗
21 Feb 2024
Ugly Bug: SQL Server Online Index Rebuild Sometimes Happens Offline Without Warningoriginal ↗
7 Feb 2024
Is the Azure SQL Managed Instance Business Critical Service Tier Worth the Cost?original ↗
29 Jan 2024
Azure SQL Managed Instance General Purpose Architecture and Performance/Cost Tradeoffsoriginal ↗
22 Jan 2024
Automatic Plan Correction Could Be a Great Auto Tuning Feature for SQL Server: Here Is What It Needsoriginal ↗
17 Jan 2024
Power BI Performance Tuning with Eugene Meidingeroriginal ↗
16 Jan 2024

2023

Microsoft is Breaking Database Compatibility Levels for SQL Serveroriginal ↗
18 Dec 2023
Getting Around Error 40510 to Configure Resource Governor in Azure SQL Managed Instanceoriginal ↗
15 Dec 2023
How Many Features Are Missing from Azure SQL Managed Instance?original ↗
9 Dec 2023
Lost Updates Under Read Committed Snapshot Isolation (RCSI)original ↗
4 Oct 2023
Automated Deployments and the Art of the Database with Database Michael J Swartoriginal ↗
26 Sept 2023
PAGELATCH, PAGEIOLATCH, and LATCH Waits in SQL Serveroriginal ↗
12 Sept 2023
Jer and Kendar Explore Optimized Lockingoriginal ↗
4 Sept 2023
Dear SQL DBA - Advice for Technical Leaders with Alex Robsonoriginal ↗
31 Aug 2023
Msg 195: STRING_SPLIT Is Not a Recognized Built-In Function Nameoriginal ↗
25 Aug 2023
Dear SQL DBA - Performance Tuning with Erik Darlingoriginal ↗
18 Aug 2023
What To Do When They Are Sure It Was The Database... All The Timeoriginal ↗
15 Aug 2023
Dear SQL DBA: Tech Interviews in 2023 With Jeremiah Peschkaoriginal ↗
11 Aug 2023
Database DevOps Core Concepts: Migration Scriptsoriginal ↗
9 Aug 2023
Dear SQL DBA - Data Roles: DBA, DBRE, and Data Engineeroriginal ↗
4 Aug 2023
Why Not Call Database DevOps Simply DevOps?original ↗
28 Jul 2023
The Difference Between DBAs, DBREs, and Data Engineersoriginal ↗
26 Jul 2023
Should We Do Index Maintenance on an Azure SQL Managed Instance or Azure SQL Database?original ↗
17 Jul 2023
Even Smart People Make Terrible Data Modeling Decisionsoriginal ↗
11 Jul 2023
My Performance Tuning Precon and Git Session at PASS Data Community Summit 2023original ↗
10 Jul 2023
Adding a Netlify Contact Form to a Hugo Static Siteoriginal ↗
29 Jun 2023
Is It OK to Show My Database Schema to ChatGPT and GitHub Copilot?original ↗
23 Jun 2023
When NOT to Choose SQL Server to Store Your Dataoriginal ↗
21 Jun 2023
Career Navigation in the Time of Tech Layoffsoriginal ↗
23 May 2023
ChatGPT Says SSMS Is the Best SQL Server Monitoring Tooloriginal ↗
3 May 2023
Use ChatGPT to See Multiple Perspectives: An Example With ORMs and Database Codeoriginal ↗
24 Jan 2023
3 Lessons Learned About Azure SQL Databaseoriginal ↗
15 Jan 2023

2022

New Article on Performance Tuning with the Missing Indexes Feature in SQL Serveroriginal ↗
18 Mar 2022
Find Query Execution Timeouts with Query Storeoriginal ↗
11 Mar 2022
Index Design Guide Updated: Index Types, B+ Trees, and Row Locators, Oh Myoriginal ↗
23 Feb 2022
Workers vs. Requests in Azure SQL Databaseoriginal ↗
18 Jan 2022
What I Learned Writing About How to Diagnose and Troubleshoot High CPU in Azure SQL Databaseoriginal ↗
5 Jan 2022

2021

Addressing the Rumors That I Have Been Removed from the MVP Programoriginal ↗
4 Nov 2021
Gotchas with Deferred Name Resolution in SQL Server: Stored Procedures, Synonyms, Views, and Functionsoriginal ↗
18 Oct 2021
Learn Azure SQL with One Free Learning Pathoriginal ↗
14 Oct 2021
New Tricks I Learned from the Azure Data Studio Code Editor Tutorialoriginal ↗
7 Oct 2021
Trying Out the Azure SQL Database Quickstartoriginal ↗
4 Oct 2021
Tutorial: Create a Disposable SQL Server Database Container in an Azure DevOps Pipeline With Spawnoriginal ↗
13 Jul 2021
The HBO Max Integration Test Email Means You Should Make Automation Safer: For Everyoneoriginal ↗
18 Jun 2021
Managing Drift in Automated Deployments to SQL Server Databasesoriginal ↗
4 Jun 2021
Why NoSQL Database Adoption Is Not a One Way Journeyoriginal ↗
27 May 2021
My Sketchnotes from Redgate Level Up Week 2021original ↗
24 May 2021
Azure Static Web Apps Are Now Generally Availableoriginal ↗
18 May 2021
Maintaining Balance While Retraining in a New Professional Areaoriginal ↗
10 May 2021
How I Got Twitter Cards Working in Hugo with the Mainroad Themeoriginal ↗
7 May 2021
How to Enable TCP/IP in SQL Server Developer Edition, Even If the Configuration Manager Is Missingoriginal ↗
5 May 2021
Moving From WordPress to an Azure Static Site with Hugooriginal ↗
3 May 2021
Help Me Not Be Selected to Speak at the Dativerse Virtual Conferenceoriginal ↗
22 Apr 2021
Free Virtual Event: Mental Health and Awareness Day on May 7thoriginal ↗
21 Apr 2021

2020

Ten Ideas to Improve Online Tech Conferencesoriginal ↗
18 Nov 2020
Coping with the Pandemic (T-SQL Tuesday #132)original ↗
10 Nov 2020
Down Tools Week 2020 (10 minute video/podcast episode)original ↗
6 Aug 2020
Common Antipatterns in Database Development (28 minute video/podcast episode)original ↗
30 Jul 2020
Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)original ↗
16 Jul 2020
How to Spell and Capitalize tempdb for SQL Serveroriginal ↗
15 Jul 2020
Next