Category Archives: Software

Adventures with Virtualization

Those of us needing to run BI software in virtual environments are well familiar with the challenges of getting things running smoothly, especially if you are using a laptop as your lab or demo environment. We have a new set … Continue reading

Posted in Operating Systems, Virtualization | Leave a comment

Brilliantly stupid MDX debugging technique

Whenever I do something really stupid, rather than keep it to myself, I prefer to blog about it for the entire world to see. Even better – I came up with a debugging technique to save myself from my own, … Continue reading

Posted in Analysis Services, MDX, OLAP, SQL Server | Leave a comment

Devils and Angels of BI Architecture

Devil: You don’t need to set up a separate star schema databaseAngel: Yes you do. We don’t want to  interfere with the operational systemsDevil: It’s sooo much workAngel: We want to create a simplified schema to benefit our end usersDevil: … Continue reading

Posted in Business Intelligence, Modeling/Architecture, SQL Server | Leave a comment

The “Million Dollar” BI Architecture Diagram

Anyone who has worked with me or taken training from me has seen some variant of this diagram. It’s not an original concept, although this version has been refined to include my personal experience with many Business Intelligence implementations, as … Continue reading

Posted in Business Intelligence, Modeling/Architecture, SQL Server | Leave a comment

Windows 7’s ‘GodMode’

Weird but cool – nice way to shortcut steps in W7: http://news.cnet.com/8301-13860_3-10423985-56.html?tag=rtcol;pop  or video   http://cnettv.cnet.com/enable-godmode-windows-7/9742-1_53-50081662.html?tag=mncol

Posted in Operating Systems | Leave a comment

Dec 8th, 2009 ITA BI Roundtable Presentation

On Dec 8th, I was fortunate to present an overview of SQL Server 2008 Integration Services to the Illinois Technology Association’s Business Intelligence Roundtable. The actively-involved participants had many questions. Here are links to all of the prerequisite, supplemental, and … Continue reading

Posted in Community, Integration Services | Leave a comment

Fixing "Unexpected error occurred. Attempted to read or write protected memory. This is often an indication that other memory is corrupt."

( If you don’t do hard-core Analysis Services, Reporting Services, or Integration Services development work with Microsoft Business Intelligence Development Studio, you can safely ignore this blog. ) On my workstation there was an incompatibility between Visual Studio and the … Continue reading

Posted in Analysis Services, Microsoft | Leave a comment

Add-ons no MS Business Intelligence Developer should be without

The main two applications that are used for Microsoft-centric development are Business Intelligence Development Studio (BIDS) and SQL Server Management Studio (SSMS). There are a few add-on utilities that increase the power and usefulness of the out of the box applications. … Continue reading

Posted in Analysis Services, Business Intelligence, Software, SQL Server | Leave a comment

Quick SQL Server tip : Find references to table or column names

Many times I have to look within a database and find all the programmable objects that refer to a particular column or table name (any string really). There’s probably a slicker, more “politically correct” way to do this, but this … Continue reading

Posted in SQL Server | 2 Comments

Do as I say, not as I do

Perhaps that should be – Do as I say, not as Adventure Works and Project Real do SSAS modeling question: What’s the best approach to handling header/detail records? Approach #1) Use Measure Groups Approach #2) Consolidate via either ETL or … Continue reading

Posted in Analysis Services, Business Intelligence, MDX, Modeling/Architecture, OLAP, Star Schema | Leave a comment