Snowflake Architecture – The Basics

At the most basic level, Snowflake has 3 important components. The Cloud services layer, centralised storage layer and the compute layer. Cloud services – they call this the “brains”...

SSRS Subscription E-Mail Error

It is that time again.  This time coming to you from a Mcdonald’s so my son can get out some energy, and it is 105 degrees outside. This will...

Thank You Wendy!

I honestly don’t know when or how I met Wendy Pastrick, but I’m so happy I did. Wendy and I have been friends for a very long time. Thank...

Daily Coping 18 Jul 2022

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

Database Search in SQL Monitor

I learned something new recently. I can search in SQL Monitor for a database name, not just a server or instance name. I tested this over at monitor.red-gate.com recently...

Generating Unicode Characters in Power Query

You may have used the UNICHAR() function in DAX to return Unicode characters in DAX measures. If you haven’t yet read Chris Webb’s blog post on the topic, I...

Mounting ADLS point using Spark in Azure Synapse

Last weekend, I played a bit with Azure Synapse from a way of mounting Azure Data Lake Storage (ADLS) Gen2 in Synapse notebook within API in the Microsoft Spark...

Mounting ADLS point using Spark in Azure Synapse

Last weekend, I played a bit with Azure Synapse from a way of mounting Azure Data Lake Storage (ADLS) Gen2 in Synapse notebook within API in the Microsoft Spark...

Sabbatical!

Redgate Software has a policy wherein every 5 years, employees receive a 6-week paid sabbatical. Well, I’m up to year 11 (I skipped a year my first time), so...

Scary Scalar Functions - Part Two: Performance

Scary Scalar Functions series overview

Part One: Parallelism
Part Two: Performance

Foreword
In the second part of this series, we’ll look at how Scalar functions (or UDFs) affect performance.
If you want to follow...