Modern Data Warehouse & Reverse ETL

An extension to the Modern Data Warehouse (MDW) that I have heard a bit about lately is called “Reverse ETL”. Before I describe what that is, first I wanted...

Daily Coping 12 Apr 2021

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

Setting up Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data at rest. In my prevous post we looked at what TDE is and how it...

Snowflake in Azure

Being aligned to a global cloud like Microsoft Azure you have choices. Whether that is Azure SQL Database or Azure Database for MySQL for your relational database, it does not matter...

Regression Testing SQL Saturday Naming

I started a poll today on the naming for future SQL Saturdays. You can answer here: https://twitter.com/way0utwest/status/1380524526455390209 The current votes (51 votes) look like this: That’s interesting, as I...

Daily Coping 9 Apr 2021

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

Error creating Azure SQL Database

A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”,  “message”: “Operation on server x and database y is in progress.  Please wait a few minutes before trying again.” What is going on here? Well for this example (and maybe yours) I created a database...

"Think Like a Certification Exam" at Certification Saturday 2021

I'll be presenting at Certification Saturday 2021 this weekend! I'll be contributing my talk on How to "Think Like a Certification Exam" at 3pmGMT/8amPT.

Microsoft is offering any one certification exam for...

Daily Coping 8 Apr 2021

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

"Ethics in Modern Data" at the Inland Northwest Data Professionals Association

Looking forward to speaking to one of our new home turf's data organizations, the Inland Northwest Data Professionals Association. My spouse Christine and I will be presenting a talk we're...