Author Archives: Anthony Sammartino

My Blog Has Moved

This site will no longer be updated and my blog has been redirected to http://www.anthonysammartino.com Thanks and Happy New Year! Advertisements

Posted in Replication | Leave a comment

That Creepy Little Scope

I wanted to write this around Halloween as the title would have been more fitting, also thought about changing it to the “Grinch Who Stole the BI Project Delivery Date”, but didn’t really like it even though it is funny, … Continue reading

Posted in BI Project Management | Tagged , , , , , , , , | Leave a comment

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

Divide and Conquer Reporting (Architecturally Speaking)

This is my first blog post and surely won’t be my last. I have talked about creating a SQL BI blog for a few years and over the last few weekends I finally gathered my thoughts and documents I wrote … Continue reading

Posted in Replication | Tagged , , , , , , , | 2 Comments