Dear SQL DBA: How Do I Prepare for Certification Exams? (video)
Category:
dear-sql-dba
In this episode, I talk about how to strategize for and prepare for Microsoft Certification exams, using the Database Fundamentals exam as an example.
Query Store Cleanup Can be Part of a Blocking Chain
Category:
query-store
, sql-server
Forgetfulness can lead to learning something new. This is a bit of a nightmare when it happens in production, but a treat when it happens in an isolated test system– and that’s how I learned this.
I left a bit of blocking open on my test VM, and forgot about it.
Dear SQL DBA Q&A: A Poorly Indexed ISV Database
Category:
community
, dear-sql-dba
At a recent conference, two speakers reminded me of something important: when you put effort into learning something or helping folks, don’t simply put your words in private emails or post-it notes on your desk. Whenever possible, blog it as well. It can help other people, and it can also help you remember it in the future!
A Case of Inconsistent Wait Stats and Query Duration
Category:
execution-plans
, query-tuning
You know how they say “don’t sweat the small stuff”?
That’s good advice for lots of things, but when it comes to query tuning - I WANT TO KNOW MORE when something is inconsistent. I just can’t let it go. I go total X-Files: The Truth Is Out There.
Free Webcast: DBA vs Memory Settings
Category:
database-administration
Join me in two weeks for a really fun free webcast.
Register for My Free Session on Execution Plan Forcing
Category:
query-performance
I am excited to be giving a free online session as part of the Idera Live Virtual Conference, 2018!
Dear SQL DBA: I Want to Work for Myself (video with captions and transcript)
Category:
dear-sql-dba
Our question this week comes from an IT pro who would like to be self-employed. In this episode, I talk about three big things you need to think about to start working for yourself, and two possible paths to get there.