A database consultancy in TX, serving clients all over the USA.
DFW, TX
- Tweets 248
- Following 85
- Followers 151
- Likes 162
4 hours of SQL Server help, $500 for first time clients.
No contracts, no muss, no fuss.
dallasdbas.com/ad-hoc-sql-se…
26
Happy Hoplidayts!
Yes, All of Them.
Yes...you too. You deserve to be happy.
accidentaldba.co/p/happy-hol…
1
35
SQL Server changed something and nobody knows who did it? Default Trace still tracks:
• Login changes
• Auto-growth
• Config changes (MAXDOP, CTFP)
It’s old, but it works
This week’s newsletter breaks it down.
accidentaldba.co/
50
SQL Server terms get fuzzy:
Replication ≠ DR, Log Shipping ≠ HA, AGs ≠ backups.
Learn what actually protects your data:
accidentaldba.co/
44
This annoying nonsense at the top of my @QuickBooks screen that won't go away is beyond unhelpful. Its almost as rage-worthy as QB AI telling me I'm stupid every day.
1
199
Slides fade. Conversations last.
See you at PASS Summit (Seattle) & SQLBits (Wales).
Why conferences still matter:
accidentaldba.co/
1
59
Not a SQL Server newsletter this week:
accidentaldba.co/p/not-a-sql…
26
Your “stable” SQL Server 2016 isn’t stable - it’s unsupported in a year.
2019/2022 bring smarter query tuning and faster recovery.
Stay safe. Start your upgrade planning NOW
accidentaldba.co/
#SQLServer #DatabaseAdmin
50
SQL Server migration ≠ backup/restore.
It’s about:
✅ Right-sizing the new server
✅ Tuning the source
✅ Testing before cutover
With planning, “move day” is boring (the good kind).
👉 accidentaldba.co/
30
SQL Server won’t warn you unless you tell it how.
Built-in alerts are free, Microsoft-supported, & effective if you set them up right.
Corruption
Job Failures
Replication Issues
And More!
This week’s guide: Setting up SQL Server Alerts the right way.
accidentaldba.co/
39
Thoroughly disappointed in @Microsoft Support.
Opened a Sev A Pro level case 30 HOURS ago. Have not heard back yet.
Finally got it resolved without them, but will let the clock run out of pure curiosity.
I responded to my client on this in 7 minutes.
1
39
Slow SQL Server isn’t mysterious - it’s measurable.
Rank the pain, fix the biggest offender or the pattern behind it, then verify with before/after metrics.
Read the wrap-up (part 4 of 4):
accidentaldba.co/p/sql-serve…
#SQLServer #DBA #PerformanceTuning
17
“SQL Server is slow"
Before you dive into SSMS, run a 10-minute triage.
Prove, (or eliminate) the usual suspects (host, storage, network, jobs) first.
Skip this step and you’ll waste hours chasing the wrong problem.
Part 2 of 4
accidentaldba.co/
44
SQL Server Failover Cluster Instances (FCIs) may be old school, but they’re still solid.
accidentaldba.co/subscribe
52
SQL Server Log Shipping isn’t fancy, but it’s rock solid.
✅ Simple to set up
✅ Works in Standard Edition
✅ Great low-cost DR
Part 2 of our HADR series:
Log Shipping – The Old Reliable of DR
Sign up here:
accidentaldba.co/subscribe
40
SQL Server DBCC CHECKDB found corruption?
Don’t panic. Read this first (tomorrow)
This week’s Accidental DBA newsletter covers:
✔ What corruption really is
✔ What CHECKDB does
✔ Safer ways to confirm and fix it
Read it here: accidentaldba.co/subscribe
39
"SQL Server is slow."
We've all heard it, but that doesn’t mean SQL Server is the problem.
In this Friday's newsletter, I dig into the real-world causes of SQL Server I/O bottlenecks.
Sign up:
lnkd.in/epPUPtaM
47