Distributed Tables in Azure Synapse SQL

Azure Synapse is the new Generation of SQL DW (Azure SQL Data Warehouse), that is launched in the past year In November 2019 the First announced for Azure SQL...

Daily Coping 21 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...

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

The Ironic DBA—My First Year as a DBA [Part 4]

My Favorite and Recommended Training Resources As I’ve been in intense, focused SQL Server training for the last year, I thought it would be a great time to share...

Azure SQL Database – Advanced Threat Detection

You should always seriously consider enabling this feature. This is part of the ADS suite – Advanced Data Security and I will show you how good this pro-active service...

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

Multi-subnet AlwaysON Failover Testing - Part 2

Multi-subnet AlwaysON Failover Testing - Part 2

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

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