Ziek's SQL Home

In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type...

2012-05-04

740 reads

Slowing Changing Dimension (SCD) demystified – Part 1

SCD is a basically a concept that explains how historical data/values are stored within a data in a database.

There are...

2012-05-03

677 reads

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

I am off to Live 360 today, on my last trip of the year....

I have an application team that is insisting on daily (and for some, weekly)...

i see this in the definition of a linked server on our wh sql...

Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';