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

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

Daily Coping 20 Jul 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Database Fundamentals #27: Creating a Primary Key in the Table Designer

Defining primary keys is the hardest part of the operation. You will need to work very closely with the business in order to define exactly what column or columns...