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...

Privacy Policy

We value your privacy. This policy explains what personal data we collect and why.
What We Collect

Cookies (for analytics, only after consent)
IP addresses (stored anonymously by our hosting provider)
Contact form...

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’...

Advice I Like: Tipping

When in doubt, overtip – from Excellent Advice for Living This is close to my heart, since I spent a lot of time in college and after working as...

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...

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...

Query to Email….Well Formatted Email

When I get alerts from SQL Server I want it to do three things for me. Tell me what’s wrong, show me the data, then tell me how to...

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...

CHOOSE’ing a Beer: #SQLNewBlogger

We recently published an article on CHOOSE at SQL Server Central. I thought it was a good intro, but as someone noted in the comments, how do you use...

Why Your SQL Server Backups Aren’t Enough

SQL Server backups are database insurance – you don’t really appreciate them until disaster strikes. But here’s the kicker: having backups doesn’t mean your data is safe. If you’re...