Tag Archives: SQL Server 2008 R2

Is it a Mirror or an ODS?

You ever have one of those conversations that makes you say, huh thats a strange coincidence?  I figured I would blog this conversation I had about what the differences are between mirrored databases and an ODS.  This might seem like, … Continue reading

Posted in ODS | Tagged , , , , , , , , , , | Leave a comment

How Big Is Your Data Warehouse?

I ask this question at every client that hires me to enhance their Microsoft SQL Server Business Intelligence solution. It seems like a pretty easy and straight forward question right?  You would be surprised at how many companies or BI … Continue reading

Posted in SQL DB Engine | Tagged , , , , , , , | Leave a comment

SSIS Server Architecture Depends on Package Design

A common question that my clients ask when they purchase hardware for the ETL Layer of a Business Intelligence architecture using SQL Server Integration Services (SSIS) is usually, “does this server need to be attached to SAN disk or a … Continue reading

Posted in SSIS | Tagged , , , , , , , | 1 Comment