What is TDE (Transparent Data Encryption)?

TDE is referred to as a “transparent” form of encryption. What that means is that the process of encrypting and decrypting data is fully performed in the background. The...

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 16 Dec 2022

Today’s coping tip is to send a gift to someone new. I have been sending gifts to my daughter at college every month or so, but I decided I...

My Office Setup

At the PASS Summit a few weeks ago, I had a great chat with some folks about our home office setups. More and more of us are working from...

Daily Coping 15 Dec 2022

Today’s coping tip is to support a charity or cause you care about. My big causes are food, housing, and education for those that are struggling.  I like to...

End of year planning: T-SQL Tuesday #157

It’s T-SQL Tuesday again! And Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the ... Continue reading

My presentation recordings of data architectures

Over the years I have presented a ton (see the list), and some of those presentations were recorded. I had put some of them on my YouTube channel, but...

Daily Coping 14 Dec 2022

Today’s coping tip is to offer to help someone who is facing difficulties now. I’ve been very lucky in life. I find that success often has me associating with...

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

Encrypting Your SQL Data Should be Your Default Option

Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we hear news of large companies that have had data stolen with both financial and reputational...