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

InvalidAbfsRestOperationException in Azure Synapse notebook

Problem The first issue that developers in my team noticed was when they tried to create database with Spark: Error message: org.apache.spark.sql.AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(meesage: Got exception:  org.apache.hadoop.fs.azurebfs.contracts.exceptions.InvalidAbfsRestOperationException Status code:...

InvalidAbfsRestOperationException in Azure Synapse notebook

Problem The first issue that developers in my team noticed was when they tried to create database with Spark: Error message: org.apache.spark.sql.AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(meesage: Got exception:  org.apache.hadoop.fs.azurebfs.contracts.exceptions.InvalidAbfsRestOperationException Status code:...

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

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

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

On Hybrid Events

 In my blog post last night on Days 1 and 2 of the PASS Summit, I included the following comment:

(Along with that, I think having "hybrid" events like our...