Multiple Query Trace Flags

How Big Data Supports Gen AI

This article includes an overview of how big data and Artificial Intelligence (AI) models work together.

Combining Silver Tables into a Model – Data Engineering with Fabric

This next article in the series creates objects at the gold layer for consumption by combining tables from the silver layer of the lake house.

Using Machine Learning Pipeline Execution Activity in Azure Data Factory

This article shows how one can run a machine learning activity in an Azure Data Factory (ADF) pipeline.

Take Care

The world seems to be proceeding through some stuff at the moment. IT and our industry as a whole, equally seems to be going through some stuff. As such, allow this oldster to offer some advice: Take care of yourself. I know, I'm the same, you may have responsibilities for others. You need to take […]

One more reason to use foreign key constraints

Since the title might be considered a bit vague, I don’t want you to wade through the article to figure it out. I will spare you the typical clickbait introduction, with me telling you what a foreign key constraint is, and why it and all the other constraint types provided by relational engines are useful. […]

Using Table Hints in a Query

Disaster Recovery and High Availability Solutions in SQL Server

Learn about disaster recovery and high availability options in SQL Server with details on the tradeoffs you make when choosing from Availability Groups, Log Shipping, Database Mirroring, and Replication.

Default Objects in Clones

Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts

Learn how it works and how to use the DENSE_RANK() function in your code.