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

743 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

681 reads

Tired of inventory headaches? Stock shortages and gluts don't just cause stress; they cost...

So, you want to get your SQL skills razor-sharp without dropping any cash? You're...

Here are the slides from my talk today at the Redgate NYC Devour Hour:...

What’s the best way to find duplicate rows in a sql query? I heard...

Hello, Can you please clarify the following: In Azure SQL DB both ALLOW_SNAPSHOT_ISOLATION/READ_COMMITTED_SNAPSHOT are set...

Hi everyone I have a SP that just failed. Format of SP is: Select...

If I run "dab init" to create a new API over a database, what parameters are required?