The Importance of a Good Data Model in Power BI Desktop

A New Year, New Efforts

Happy New Year! You're going to be seeing a lot of summaries for 2022 and predictions for 2023 around this time of year. I'm not writing one of those. You'll also see people calling for new years resolutions and the like. I'm not going for that either. Nope, let's keep it simple. It is a […]

Secure File Transfer Protocol (SFTP) support for Azure Blob Storage

In this article, we walk through the steps and examples of how to use Secure File Transfer Protocol (SFTP) when working in Azure.

The New Year 2023

Looking Back at 2022

This is the last workday of 2022. Next week starts a new year, and as I've often done, I wanted to look back at the year. This time I decided to look back month by month, at some of the headlines and memorable data-related topics. I'm tackling things month-by-month. In January there was a set […]

Converting Data Across Time Zones: An In-Depth Primer

This article dives into all the math required to convert historical times between time zones.

The Invalid Synonym

The Lock Escalation Threshold – Part 3

The examples so far in this series have all used repeatable read isolation to acquire shared locks on qualifying rows and hold them to the end of the transaction. This was convenient for the demos but repeatable read isolation isn’t common in everyday use.

Building a SQL Computational Framework for MACD Indicators

This article looks at how to calculate MACD indicators using a set of T-SQL code and data stored in a SQL Server database.

The 12 days of Christmas