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

751 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

692 reads

When mirroring was first released for Azure SQL Database, it used Change Data Capture...

One of the things I’ve tried hard to do in database development situations if...

The T-SQL Tuesday topic this month comes James Serra. What career risks have you...

We have two "identical" instances of an ASP.NET web service (or so I have...

Comments posted to this topic are about the item OPENQUERY Flexibility

Comments posted to this topic are about the item A Full Shutdown

Which of these are valid OPENQUERY() uses?