SQL Server Converts Numbers to Asterisks

Watch this week’s episode on YouTube. Pop quiz: What will be the output of the below three statements? As you might have guessed, the first conversion truncates the value,...

SQL Server Converts Numbers to Asterisks

Watch this week's video on YouTube
Pop quiz: What will be the output of the below three statements?
DECLARE @val_varchar varchar(3) = '100';
DECLARE @val_bigint bigint = 100;
DECLARE @val_tinyint tinyint = 100;

PRINT('varchar...

SQL Undercover TV Christmas Special – David's Top 5 Azure Data Studio Features

In our Christmas Special, David picks his top 5 features of Azure Data Studio.

Unprepared for Travel

I’ve had a month off from travel, which has been nice. It’s been an interesting time catching up on things at home, and a nice break from the disruption...

A Smooth Laptop Setup

A little over a week ago, I got a new laptop. This was late on a Sunday afternoon, and I went home to spend time with me wife. After...

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

This is the fourth and final post in a series about modern Data Lake
Architecture where I cover how we can build high quality data lakes using
Delta Lake,...

SSMS Tip: Regular Expressions in SSMS

Regular expressions (or simply regex for short) have long been used by system administrators and data professionals for searching and manipulating text. Regular expressions allow the user to find,...

Tracking CPU Use Over Time

A question that I’ve seen come up frequently just recently is, how to track CPU use over time. Further, like a disk filling up, people want to know how...

Schema evolution solved using Delta Lake & Databricks

Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...

Schema evolution solved using Delta Lake & Databricks

Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...