←
IDERA11,104 posts
IDERA avatar

IDERA

@Idera_Software

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

◷ Joined February 2009▧ 4,757 Photos and videos
IDERA avatar
IDERA@Idera_Software·22h

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

IDERA avatar
IDERA@Idera_Software·Nov 17

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

Post attachment
IDERA avatar
IDERA@Idera_Software·Nov 16

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

IDERA avatar
IDERA@Idera_Software·Nov 15

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

IDERA avatar
IDERA@Idera_Software·Nov 14

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. 🦆

IDERA avatar
IDERA@Idera_Software·Nov 13

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

IDERA avatar
IDERA@Idera_Software·Nov 11

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

IDERA avatar
IDERA@Idera_Software·Nov 10

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/…

WhereScape avatar
⟳ IDERA retweeted
WhereScape@wherescape·Nov 9

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…

IDERA avatar
IDERA@Idera_Software·Nov 9

“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

IDERA avatar
IDERA@Idera_Software·Nov 8

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

IDERA avatar
IDERA@Idera_Software·Nov 8

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

IDERA avatar
IDERA@Idera_Software·Nov 7

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

IDERA avatar
IDERA@Idera_Software·Nov 6

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