Right-Click File Options in SSMS and SSDT

Ordinarily I wouldn’t blog solely about a set of right-click options in an application, but in this Eleven Days of Festivus series I’m sharing some quick tips that have...

SQL Homework – December 2019 – The default trace and the system health session.

I know this is the holiday season for many of us (which ones depend on your religion and nationality of ... Continue reading

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