Indexes: When Column Selectivity Is Not Always A Requirement

While preparing for my SQL Saturday Salt Lake City presentation, Climbing the B-Tree, I ran into one of the “word of mouth” facts that the first column of an index should be highly selective, i.e., it should only point to one or a few rows. This is not always the case and I’ll show you […]

Should You Use SQL Server 2022’s STRING_SPLIT?

SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to be in order. However, that’s the only thing they improved – there’s still a critical performance problem with it.

The Importance of a Good Data Model in Power BI Desktop

T-SQL Language Changes in SQL Server 2022 Part 3

Learn about more of the T-SQL language changes in SQL Server 2022. This article is the third in a series and will cover the changes to the JSON functions.

Enabling digital transformation – and data modernization – with DevOp

Where does data fit into the digital transformation story? Discover how and why it deserves a place in this fascinating piece from Pramod Sadalage, principal consultant at Thought Works

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.

Converting Data Across Time Zones: An In-Depth Primer

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

Executing Optional Code in Flyway Callbacks

This article demonstrates how we can use a Flyway placeholder as a simple on/off switch for each task, during Flyway migrations.

Change the Instance Collation by Rebuilding Databases in SQL Server 2017

As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]

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.