Operations | Monitoring | ITSM | DevOps | Cloud

The standard fix for an N+1 query in SQLAlchemy is to eager load the relationship with selectinload(). On SQLAlchemy 2.1.0 and 2.1.1, that fix can change your results. A regression in those two releases makes selectinload() ignore part of the join condition on some many-to-many relationships. The query gets faster, and it also returns related rows that the relationship was defined to exclude. It’s fixed in 2.1.2, released October 2.

ilert AI SRE is now generally available. Alongside it, this quarter brings Compass, a lifecycle assistant that surfaces the next move during an incident, a dedicated space for postmortems, rich incident cards in Microsoft Teams and Google Chat, on-call schedules that follow support hours and holidays, a new CLI, and dark mode. Here's everything that shipped.

Shadow AI on company computers often starts with an AI agent that an employee installed on their own, signed in with a personal subscription and connected to internal systems through a Model Context Protocol (MCP) server. Shadow AI is one branch of shadow IT, with a shorter path from install to impact: these tools set up quickly, act on files and systems, and work under whatever account the employee chose. This guide skips the long definitions and goes to the practical part.

ClickHouse monitoring guide: the Prometheus endpoint, the system tables that explain slow queries, the Too many parts limits, replication lag and alerts. Sejal Pandey works on content and growth at Last9, writing about observability, reliability, and SRE practices.

GKE monitoring guide: what Google Kubernetes Engine collects by default, which metric packages to turn on, Autopilot limits, and the alerts to set. Sejal Pandey works on content and growth at Last9, writing about observability, reliability, and SRE practices.