IDERA

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

[IDERA @Idera_Software]

DBA experience has a way of turning into a list.

Things you would do again.

Things you would never do again.

Things you would rather someone else learn before production gets involved.

@pareshmotiwala joins us July 24 for Things to Avoid as a DBA.

▶️https://t.co/hqwfFMHKOy

#SQLServer #DBA

[IDERA @Idera_Software]

The Hitchhiker's Guide: know where your towel is.

SQL Server version: know where your instances are.

July 14 is six days away. If you're not sure what's still on 2016, that's the first project.

https://t.co/iGqmPOPMPW

#SQLServer #DBA #SQLServer2016

[IDERA @Idera_Software]

Waiting until the deadline is how migration projects become emergency projects.

Inventory the environment. Find the dependencies. Establish baselines. Build a timeline.

Boring now. Very appreciated later.
#SQLServer #DBA

[IDERA @Idera_Software]

SQL Server 2016 doesn't stop working on July 14.

The security patches do. The bug fixes do. The vendor support does.

Auditors don't get that memo.

Options before the deadline: https://t.co/sUSqPJkhpv

#SQLServer #DBA

[IDERA @Idera_Software]

Query slow.

Wait stats look normal.

Indexes look fine.

Users still unhappy.

Welcome to Tuesday.

On June 17, Pinal Dave is exploring where AI fits into SQL Server performance troubleshooting.

https://t.co/DMzCUih8uw

[IDERA @Idera_Software]

You've seen the AI hype.

The more interesting question:

Can it help you get from "something is slow" to an answer faster?

@pinaldave explores AI, vibe coding, and SQL Server performance tuning live on June 17.

https://t.co/DMzCUihGk4

#SQLServer #DBA

[IDERA @Idera_Software]

"The database is slow."

One sentence.

Roughly 437 possible causes.

Join Pinal Dave on June 17 for a look at how AI and vibe coding can help accelerate query analysis and performance troubleshooting without replacing DBA expertise.

https://t.co/Sbfc9xMMEz

#SQLServer #PerformanceTuning

[IDERA @Idera_Software]

SQL Server 2016 end of support hits July 14.

That doesn't mean "upgrade everything tomorrow."

Azure, on-prem, ESUs, the right path depends on your environment. The wrong move is not having one.

Tradeoffs of each: https://t.co/GwRDl5tsTv

#SQLServer #dba

[IDERA @Idera_Software]

A query is slow.

You have a theory.

Then another theory.

Then twenty browser tabs open and lunch starts looking unlikely.

@pinaldave is exploring how AI and vibe coding can help accelerate SQL Server performance troubleshooting on June 17.

Register here ▶️ https://t.co/N96fQqzYcQ

#SQLServer #DBA

[IDERA @Idera_Software]

"Pretty sure we've upgraded everything."

That sentence has sparked many interesting investigations.

The forgotten dev server. The test environment nobody owns. The dependency nobody documented.

If someone asked how many SQL Server 2016 instances are running in your environment right now, would you know?

#SQLServer #DBA

[IDERA @Idera_Software]

Some compliance gaps don’t look like gaps.

Audit logging silently truncates after storage fills up. Backup encryption exists in production but never made it to dev environments running production data.

Everything still looks configured.

That’s the dangerous part.

https://t.co/26YokSHMM1

#SQLServer #DatabaseSecurity

[IDERA @Idera_Software]

Permission debt accumulates quietly.

A role granted during a project. A service account never scoped back down. A troubleshooting login nobody removed.

Three years later, nobody remembers any of it.

A permissions snapshot is not the same thing as proving control.

#SQLServer #DBA #DatabaseSecurity

[IDERA @Idera_Software]

TDE and Always Encrypted solve different problems.

TDE protects data at rest.
Always Encrypted protects data from privileged users.
The important question isn’t which one is “better.”

It’s which risk you’re trying to reduce.

#SQLServer #DBA #DatabaseSecurity

[IDERA @Idera_Software]

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

[IDERA @Idera_Software]

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

[IDERA @Idera_Software]

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%

[IDERA @Idera_Software]

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 → https://t.co/mCzegvWCJb

#SQLServer #DBA

[IDERA @Idera_Software]

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

[IDERA @Idera_Software]

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 → https://t.co/LbUmbRhJRH

#SQLServer #DBA #IderaSQL

[IDERA @Idera_Software]

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.
→ https://t.co/d1CoZoOlMR

#SQLServer #DBA #TSQL