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

A New Word: Immerensis

immerensis – n.  the maddening inability to understand the reasons why someone loves you – almost as if you’re selling them a used car that you know has a...

Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault

In this post, I will guide you on how to deploy a dockerized simple flask-based TODO application to Azure Container Apps using Pulumi. You will Dockerize the Python application,...

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:

The Book of Redgate–Being Reasonable

As a part of the Book of Redgate, we have a series of (red, of course) pages with the title “What we believe”. These are our values, as set...

Understanding Lakehouse Permissions in Microsoft Fabric

Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access to Lakehouses, SQL Endpoints, or Semantic Models.

Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric

Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data platform. This platform integrates various data sources into a single, cohesive system. This integration breaks...

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