Cosmos DB for the SQL Professional – Referencing Tables

I had a previous blog comparing Cosmos DB to a relational database (see Understanding Cosmos DB coming from a relational world) and one topic that it did not address...

Extended Events: Filter on Stored Procedure Name

I just received a question about Extended Events: What about filtering on the stored procedure name. You know I love writing and talking about Extended Events. The answer is,...

Multi-Subnet AlwaysOn - Scripts & Downloads - Part 3

Multi-Subnet AlwaysOn - Scripts & Downloads - Part 3

Multi-Subnet AlwaysOn - Scripts & Downloads - Part 3

Let’s see how to get access to scripts for this tutorial series

Azure DP-900 (Data Fundamental) Certification perpetration

Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got...

Azure DP-900 (Data Fundamental) Certification perpetration

Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got...

Daily Coping 21 Aug 2020

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

Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools

Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case. After creating Azure SQL Databases...

Certified Azure Database Administrator (DP-300) – Passed!!!

Deja Vu, back in March I saw a Tweet about the beta Microsoft Certification Exam DP-300. I work with Azure and Databases, so I thought to myself why not...