Extended Events: Embrace the XML

While XML is, without a doubt, a giant pain in the bottom, sometimes, the best way to deal with Extended Events is to simply embrace the XML. Now, I...

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

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

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

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

The production database just went down! What do I do?

A few of my colleagues can relate with the title of this article, they might have experienced an issue with the database in production. Dear colleague, you are not...

The SQL Saturday Foundation Board of Directors

I’m pleased to announce that I have selected an initial board of directors for the SQL Saturday Foundation. I’m honored to be a part of this group: Andy Warren ...

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

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