Data Savvy

In my previous post, I provided the design pattern and Biml for a pure Type 2 Slowly Changing Dimension (SCD). When...

2015-12-27

605 reads

Demystifying the Type 2 Slowly Changing Dimension with Biml

Most data warehouses have at least a couple of Type 2 Slowly Changing Dimensions. We use them to keep history...

2015-12-21

878 reads

I haven’t posted in a while (well, not here at least since I’ve been...

One of the things that I like about the SQL Server docs (MS Learn...

For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...

is there a no code way to limit an ssis extract from excel to...

Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...

hi we have to replace talend which generally was used to move files. talend's...

In SQL Server 2025, what does this return?

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers