Daily Coping 5 Dec 2022

Today’s coping tip is to look for new reasons to be hopeful, even in tough times. My life is pretty amazing most of the time. There are some stressful...

How to Store Normalized SQL Server Data into Azure Cosmos DB

Recently I got a hold of my Untappd data. For those who don’t know the app, it’s a rating app for beers. You can check-in a beer each time...

My SQL Server Encryption book has just been published!

It’s been a long journey, but I got the email from Apress yesterday to say that my book “Pro Encryption is SQL Server 2022” has now been published. You...

What do we want to achieve by encrypting our data?

On the face of it, this is a very obvious question with a very obvious answer. We want to prevent data from falling into the wrong hands. In practice,...

Speaking at SQLSaturday MN 2022

Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for great feedback and questions. I'm always a big supporter of SQLSaturday events whenever I can...

Book Review – SQL Server Query Tuning and Optimization (2nd Edition)

The nice people from Packt Publishing sent me a digital copy of Benjamin Nevarez new book to review: SQL Server Query Tuning and Optimization – Optimize Microsoft SQL Server...

Creating a user for a STONITH resource in vSphere

I previously blogged about how to create a STONITH resource for a pacemaker cluster in VMWare virtual machines. Ok, I have a confession…you need to specify credentials when creating...

Daily Coping 2 Dec 2022

Today’s coping tip is to enjoy new music today: play, sing, dance, or listen. I’m on the road this week, so it’s music for me. Not a lot of...

Default event_file path for Extended Events

Foreword
Have you ever wondered where the .xel file is saved when you create a new Extended Event session and don’t specify the full path (just the file name)?
Like so:

Well,...

Goal Progress for Nov 2022

I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. Another month of busy stuff. A long trip for the...