Data Savvy My experiences and education in data modeling, integration, transformation, analysis, and visualization

Data Savvy My experiences and education in data modeling, integration, transformation, analysis, and visualization

Category: T-SQL

Azure SQL DB Data Warehousing Microsoft Technologies T-SQL

Common Issues When Using Change Tracking for Data Warehouse Incremental Loads

I have a few clients that...

Jan 30, 2025

Azure Azure SQL DB Microsoft Technologies T-SQL

Altering a Computed Column in a Temporal Table in Azure SQL

System-versioned temporal tables were introduced in...

Apr 22, 2021

Data Warehousing Microsoft Technologies SQL Server SSIS T-SQL

Why We Don’t Truncate Dimensions and Facts During a Data Load

Every once in a while, I...

Jul 25, 20194 Comments

Azure Azure SQL DW Data Warehousing Microsoft Technologies T-SQL

What You Need to Know About Data Classifications in Azure SQL Data Warehouse

Data classifications in Azure SQL DW...

May 30, 20192 Comments

Azure Data Warehousing Microsoft Technologies T-SQL

Create a Date Dimension in Azure SQL Data Warehouse

Most data warehouses and data marts...

Aug 6, 20164 Comments

Microsoft Technologies SQL Server T-SQL

Notes and Tips on SQL Server Spatial Data Types

I’ve been working on a project...

Jul 30, 2015

BIDS Helper Biml Data Warehousing Microsoft Technologies SSIS T-SQL

Biml for a Type 1 Slowly Changing Dimension

I’ve been working on building my...

Jul 22, 201512 Comments

Excel Microsoft Technologies Power BI Power Pivot Power View SSAS T-SQL

Fun With OPENROWSET

I’ve had several occasions to use...

Nov 12, 20132 Comments