Certified Azure Administrator (AZ-104) – Passed!!!

Back in March I saw a Tweet about the beta Microsoft Certification Exam AZ-104 program was looking for 300 candidates to take the exam by May 31st.  Since moving...

Comparing SSIS and Azure Data Factory

For the better part of 15 years, SQL Server Integration Services (SSIS) has been the go-to enterprise extract-transform-load (ETL) tool for shops running on Microsoft SQL Server. More recently,...

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

Management Studio Find & Replace Using Regular Expressions

In my last Management Studio tip, I demonstrated how you can drag and drop column names to a query window. The only part I do not like about that...

Using LAST_QUERY_PLAN_STATS in SQL Server 2019

In my opinion, SQL Server 2019 is one of the greatest releases of the product that Microsoft has ever produced.  The amount of improvements across the platform really allows...

Azure Cosmos DB API Architecture

Again, still we have a lot of information we can spread our knowledge on it for Cosmos DB today I will talk about Cosmos DB API options and How...

Building an Azure Architecture Diagram

One of the challenges I have at times is illustrating how I’d set up a particular system. Not the technical details, the visual ones. I can use boxes and...

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

Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)

I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way.

In this episode I share...

SQL Server and Docker Compose

I used to think that Docker Compose was used solely to spin up multiple containers, in fact I blogged about doing just that here. That opinion changed when I...