
The query's fast again. Great. Now write down what changed. Capture the symptom, evidence, exact adjustment, and how you verified the result. Next month's investigation shouldn't depend on reconstructing six screenshots and a chat thread. #DBA

Helping IT professionals efficiently manage their databases. Manage your IT with confidence. Manage your IT with IDERA.

The query's fast again. Great. Now write down what changed. Capture the symptom, evidence, exact adjustment, and how you verified the result. Next month's investigation shouldn't depend on reconstructing six screenshots and a chat thread. #DBA

The query is optimized. The query is not optimized. Please run the test before opening the box. This week: a free AI SQL Query Optimizer, Brent Ozar on parameter sniffing, SQL DM Custom Counters, and query hints. 🦆 Read this week’s SQL newsletter: linkedin.com/pulse/week-sql-… #SQLServer #DBA

An alert threshold is somebody's definition of normal. That definition might predate the last migration, the new ETL schedule, or your busiest season. Revisit baselines when workloads change. Healthy today may look different from healthy last year. #DBA

An execution plan has opinions. Start with actual vs. estimated rows, operators in context, and whether an index suggestion helps the whole workload. A scan isn't automatically guilty. The query and data shape get a say too. #SQLServer

A quiet weekend notification panel is a lovely sight. Especially when someone already checked alert routing, backup monitoring, on-call ownership, and escalation paths. A little credit for the DBA work nobody notices because everything's working. 🦆

Friday's green SQL Agent jobs deserve a small round of applause. Before signing off, check whether runtimes have drifted, the next scheduled run looks right, and dependencies are healthy. Here's to making Monday a little less interesting. #DBA

RPO: How much data can you afford to lose? RTO: How long can the service be unavailable? Those numbers mean more after a restore test. Quacky asked whether “as fast as possible” counts as an RTO. The runbook said no. #SQLServer

Query rewrite, new index, or both? 👀 Justin Wilkes is showing AI query and index tuning on real workloads at #PASSDataSummit. “AI in the Real World: Smarter SQL Server Performance Tuning with SQL Diagnostic Manager” 2:30 PM PT | Room 304 Calawah passdatacommunitysummit.com/…

Excited for our @wherescape teammates' session at #PASSDataSummit! 🙌 Alexander Perry presents “SQL Server Isn’t Holding Back Your AI, But Your Process Might Be,” exploring AI and governed data development. 🕙 10 AM PT | Room 302 Beckler passdatacommunitysummit.com/…

Good morning, #PASSDataSummit! 🎉 We're excited to see everyone in Seattle! Come find Idera SQL and @wherescape at Booth 115. We'd love to talk SQL Server performance, data automation, and hear what you've been working on. And yes, there will be ducks. 🦆 passdatacommunitysummit.com/…

We're very excited to be exhibiting at the #PASSDataSummit West in Seattle until Wednesday, along with fellow brand @Idera_Software - come say hi at Kiosk 115 if you want to talk AI in data warehousing ... or even if you just want a free rubber duck: wherescape.com/events/pass-w…

“The app is slow.” You have waits, active sessions, CPU, query history, and a change log. A useful first question: when did it start, and what changed around then? A time window makes the rest of the evidence much easier to use. #DBA

There's always that SQL Server login nobody wants to touch because nobody remembers why it exists. Before changing it, find the owner, purpose, last observed use, and effective permissions. Quacky has labeled the investigation “WHO OWNS THIS?” #DBA

Some SQL Server mysteries have a perfectly good explanation. It just lives in a former teammate's memory. One useful fix: document what that old job does, why it exists, and who owns it now. Future-you deserves searchable answers. #DBA

Somewhere there's a SQL Agent job called FINAL_FINAL_v3. It still runs. The author moved teams in 2019. Nobody's brave enough to rename it. A useful habit: document the owner, purpose, dependencies, and what to do when it fails. #SQLServer

Your upgrade plan has enough moving parts. Your backup tool can be one less thing to think about. 📖 See everything Brandon covered in the 9.7 release: idera.com/blogs/sql-safe-bac… 🚀 Try SQL Safe Backup: idera.com/products/sql-safe-… #SQLServer #DatabaseBackup