Salvo(z) SQL

Adam and Jennifer Salvo are IT professionals with over 10 years of diverse experience. Jennifer is a Business Intelligence developer focusing on the Microsoft BI stack (SSIS, SSAS and SSRS). Her prior work experience includes software development, systems analysis, end-user support, training, and SharePoint administration. Adam is a .NET technical lead with a current emphasis on Dev Ops and Windows Azure. His prior work experience includes .NET development, SQL Server administration, and BizTalk development. They also maintain a personal blog at salvoz.com.

Archives: December 2012

Optimizing Your BI Semantic Model for Performance and Scale

Here’s my notes from the ‘Optimizing Your BI Semantic Model for Performance and Scale (BIA-402-M)’ session at PASS Summit, presented by Akshai Mirchandani and Allan Folting of Microsoft.

Tabular Design Principles

Speed and performance
Optimize query performance over processing performance, focus on end-user experience.
Accommodate changes without forcing reload, if…

0 comments, 369 reads

Posted in Salvo(z) SQL on 11 December 2012

SSIS: Character Replacement Using the Script Component

When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or replace characters. I recently used the Script Component in SSIS to cleanse some ticket tracking data and thought I’d write a blog post that outlines the implementation.

The data from… Read more

0 comments, 547 reads

Posted in Salvo(z) SQL on 8 December 2012

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog

Salvo(z) SQL

Archives: December 2012

Optimizing Your BI Semantic Model for Performance and Scale

SSIS: Character Replacement Using the Script Component