IDERA

⇢ Use it to comfort junior DBAs after their first encounter with TempDB ⇢ Throw it dramatically over a monitor displaying “disk space critically low” A good DBA remains calm in moments like these. Mostly because they brought a towel.

You can: ⇢ Wear it as a cape while carrying backups safely through production ⇢ Wrap it around yourself to stay warm during a 2 AM maintenance window ⇢ Wipe the cold sweat off your forehead while the restore percentage sits at 99%

A towel is about the most massively useful thing a DBA can have. Happy Towel Day to all the hoopy frood DBAs out there. 🦆 #SQLServer #DBA #TowelDay #HitchhikersGuideToTheGalaxy

Tomorrow at 10 AM CDT. @pinaldave on real world SQL Server tuning with AI. Execution plans, tuning patterns, and where AI gets it wrong. Register → attendee.gotowebinar.com/register/13329… #SQLServer #DBA

Two types of query tuning. The kind where you guess and hope. The kind where you see the recommendation, review it, and decide. SQL DM 14.0 is the second one. #SQLServer #DBA #IderaSQL

That slow query isn't going to fix itself. SQL DM 14.0. AI-powered optimization, walkthrough, Q&A. Thursday April 9, 10 AM CDT. Register → register.gotowebinar.com/register/63907… #SQLServer #DBA #IderaSQL

Your backup ran successfully. Green checkmark. Job complete. That's not the same as your backup working. Corrupt files, incomplete restorations, none of those show up until you need the restore. Test it before you need it. → idera.com/blogs/myths-ab… #SQLServer #DBA #TSQL

SQL Server builds your execution plan on statistics. If those stats haven't been updated since your last major data load, the optimizer is working with a map of a city that no longer exists. → idera.com/blogs/10-reaso… #SQL #DBA #SQLPerformance

Quacky ran one workload optimization in SQL DM 14.0 and now has strong opinions about every index he's ever trusted. 🦆 → idera.com/blogs/sql-diag… #SQLServer #DBA #QueryOptimization

SELECT * is not a query strategy. It's a way to pull every column in a table when you needed three of them. More data transfer, more I/O, more load on the system. Specify your columns. Your future self will thank you. → idera.com/blogs/myths-ab… #SQLServer #DBA #TSQL

The AI does the analysis. You make the call. Nothing in SQL DM 14.0 runs automatically. Every recommendation is yours to review before anything changes. → idera.com/products/sql-d… #SQLServer #DBA

Blocking chains in SQL Server are like rush hour traffic. Nobody's moving and everyone's late. The fix isn't always the query holding the lock. Sometimes it's the victim query doing a full scan that should have been a seek. Fix the plan, fix the block. idera.com/blogs/10-reaso…

SQL DM 14.0 shipped last week, and the thing worth knowing about it: AI-powered index optimization built into Query Monitor. One query or a whole workload. Nothing runs automatically. You make the call. → idera.com/blogs/sql-diag… #SQLServer #DBA #SQL

Your SQL Server is slow. Before you order new hardware, check the queries. Nine times out of ten the bottleneck is inefficient queries, poor indexing, or outdated statistics. Not the server. More RAM won't fix a table scan. → #SQLServer" target="_blank" rel="nofollow noopener">idera.com/blogs/myths-ab… #DBA #QueryOptimization

Quacky’s been staring at the same dashboard for a while now. Not worried. Just waiting for you to circle back.

That query you never fully fixed. The audit setup you meant to revisit. Still sitting there. You already did the hard part. You found the problem. It’s the “what do I actually do about it” that slows everything down. That’s exactly where SQL DM 14.0 changes things.

You find the slow query. You check the plan. And then what? SQL DM 14.0 answers that question. AI-powered index recommendations, built into Query Monitor. You stay in control. → idera.com/blogs/sql-diag… #SQLServer #DBA #SQLDiagnosticManager

Nothing is automatic No changes applied Everything is reviewable You decide what moves forward Details: idera.com/blogs/sql-diag… AI behavior and controls: idera.com/products/sql-d…

Find the query in Query Monitor Turn it into index + query recommendations Stay in the same workflow Also works across multiple queries So tuning reflects real workload behavior, not isolated fixes

You can usually tell when a query is going to be a problem SQL Diagnostic Manager 14.0 focuses on what happens next.