Good Citizen
When I have spare time, I answer questions over at the Database Administrators Stack Exchange site.
Here are some recent ones that I’ve found interesting:
- Cannot run query to get deadlock graph in a timely fashion
- Query plan not reused for identical queries sp_executesql vs adhoc
- Query store – bumping up max_storage_size_mb works for a short while then goes back to 250?
- Slow CTE update query
- AppDomain 2 SSISDB is Marked for Unload due to Memory Pressure
If you like this style of Q&A, I’d highly suggest signing up and contributing. It’s a great way to share and learn.
Thanks for reading!
Going Further
If this is the kind of SQL Server stuff you love learning about: these days I have AI do the annoying stuff for me. My new video course teaches you to work the same way, and I teach whole teams in a one-day workshop. Someone still has to know enough SQL Server to keep the robots in check, and that’s what my training is for.