Joined February 2009
- Tweets 11,045
- Following 9,419
- Followers 11,406
- Likes 3,193
4,739 Photos and videos
Jun 12
"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.
attendee.gotowebinar.com/reg…
#SQLServer #PerformanceTuning
49
Jun 12
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: idera.com/blogs/sql-server-2…
#SQLServer #dba
67
Jun 10
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 ▶️ attendee.gotowebinar.com/reg…
#SQLServer #DBA
484
Jun 10
"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
78
Jun 1
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.
idera.com/blogs/database-sec…
#SQLServer #DatabaseSecurity
1
87
May 31
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
1
106
May 28
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
62
May 25
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
1
137
May 25
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%
1
119
May 25
⇢ 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.
76
May 5
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/reg…
#SQLServer #DBA
1
2
450
Apr 7
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
127
Apr 7
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/reg…
#SQLServer #DBA #IderaSQL
99
Apr 4
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-about-…
#SQLServer #DBA #TSQL
99
Apr 4
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-reasons-b…
#SQL #DBA #SQLPerformance
87
Apr 3
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-diagnost…
#SQLServer #DBA #QueryOptimization
97
Apr 3
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-about-…
#SQLServer #DBA #TSQL
62
Apr 2
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-diagn…
#SQLServer #DBA
59
Apr 2
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-reasons-b…
59
Apr 1
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-diagnost…
#SQLServer #DBA #SQL
1
65