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

674 reads

I saw an article on this and realized I had no idea how to...

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

How do I add 0 in the beginning but the length of the value...

Comments posted to this topic are about the item GitHub Copilot - Our Best...

I hav a table that holds sports betting lines that i am using in...