Why We Don’t Truncate Dimensions and Facts During a Data Load
Every once in a while, I...
Insufficient Disk Space (T-SQL Tuesday #88)
This month’s T-SQL Tuesday – hosted...
PolyBase Is A Picky Eater – Remove Carriage Returns Before Ingesting Text
Update: As Gerhard points out in...
Type 6 or Hybrid Type 2 Slowly Changing Dimension with Biml
In my previous post, I provided...
Datazen Lives On in SQL Server 2016
Microsoft acquired Datazen back in April...
Notes and Tips on SQL Server Spatial Data Types
I’ve been working on a project...