The Cost of Not Having a DBA
Does skipping a DBA save money? Wait until your system grinds to a halt, your backups fail, or your cloud bill skyrockets. The “DBA? We Don’t Need No Stinkin’...
2025-04-14 (first published: 2025-04-02)
606 reads
Who are you? Building an identity map.
I admit that until I read the article, Who are you as a Leader?, I had never heard of an identity map. It's a pretty simply thing: mapping all...
2025-04-11 (first published: 2025-04-01)
570 reads
Call a Fabric REST API from Azure Data Factory
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure Data Factory (or Synapse Pipelines). This can be done using a Web Activity, and most...
2025-04-09 (first published: 2025-04-01)
403 reads
Distributed Availability Group Dashboard
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This comes off of the back of my last post looking at using a distributed availability...
2025-04-14 (first published: 2025-04-01)
402 reads
Comparing My Current Schema with a Backup with SQL Compare
A customer asked if they needed to restore a database from backup to compare the schema in a database. They don’t and this post shows that. This is part...
2025-04-21 (first published: 2025-03-31)
286 reads
Improving Our Conversations
If we aren't having the same conversation, we aren't going to be heard. That's what Charles Duhigg, author of The Power of Habit, covered in the following TED talk:
2025-04-18 (first published: 2025-03-31)
366 reads
How Do You Pick Events in Extended Events?
A while back I wrote about using AI to explore why people are not using Extended Events. You can read all about it here, but a short summary of...
2025-04-11 (first published: 2025-03-31)
307 reads
Focus on Core Skills
Core skills depends on the position, but the point is that ensuring you have a strong foundational base for your chosen area is better than reaching for emerging skills.
2025-03-28
114 reads
A New Word: Zverism
zverism – n. the wish that people could suspend their civility and indulge in the physical side of each other first, sniffing each other’s hair like dogs, staring unabashedly...
2025-03-28
87 reads
SQL Server Source Control on a $0 Budget
The Source Control Dilemma Every DBA has been there. Trying to keep track of database schema changes while developers have their fancy Git repositories and version control workflows. Meanwhile,...
2025-03-27
152 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers