Finding & Downloading Required SQL Server Updates

A little while back, I offered up a one-liner to scan your SQL Server instances and report which ones are out of date. But what if you need to...

Multi-subnet AlwaysON Failover Testing - Part 2

Let’s do Multi-subnet AlwaysON failover testing for different scenarios

Multi-subnet AlwaysON Failover Testing - Part 2

Multi-subnet AlwaysON Failover Testing - Part 2

Refreshing a Power BI Dataset in Azure Data Factory

I recently needed to ensure that a Power BI imported dataset would be refreshed after populating data in my data mart. I was already using Azure Data Factory to...

Snowflake – Understanding constraints

One of the concepts in Snowflake that I find many struggle with is how constraints are handled. If you come from a traditional database platform such as Microsoft SQL...

AWS Deployment Pipelines

I’m at the just barely scratching the surface level of getting started with AWS Deployment Pipelines. Of course, the first thing I want to do with them is get...

Checking Azure SQL DB service tier via T-SQL

If you have to manage or work with an Azure SQL database and want to know what service tier the database is currently operating, but you don't have access...

Checking Azure SQL DB service tier via T-SQL

If you have to manage or work with an Azure SQL database and want to know what service tier the database is currently operating, but you don't have access...

Consistency Architecture in Azure Cosmos DB

In my first article in Azure Cosmos DB, we talked about What is Cosmos DB and How to provisions it, then in the Second article we talked about Partitioning Architecture in Azure Cosmos...