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 SQL Server Binaries. Which led to this error: Symptom: Certain operations from Business Intelligence Development… Continue reading Fixing "Unexpected error occurred. Attempted to read or write protected memory. This is often an indication that other memory is corrupt."

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. I find these invaluable: MDXStudio – the brilliant Mosha Pasumansky‘s take on how MDX development should… Continue reading Add-ons no MS Business Intelligence Developer should be without

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 is what I generally use to accomplish this: SELECT DISTINCT ‘EXEC sp_helptext [‘ + OBJECT_NAME(id)… Continue reading Quick SQL Server tip : Find references to table or column names

Published
Categorized as SQL Server

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 relational operations Most clients I deal with have some form of Header/Details modeled in some… Continue reading Do as I say, not as I do

The unlikely entrepreneur

Have you ever found yourself doing something and suddenly realized, “Now I am a grown-up”? Like when you closed on your first home, bought something like a sump pump . . . I had the “Now I am an entrepreneur.” moment yesterday when I was ordering a toll-free number for my office line and had… Continue reading The unlikely entrepreneur

Welcome! – and what this Blog is about

I chose “Information in Context” as the name of this blog for two primary reasons: It’s a central concept behind Business Intelligence, which is one of my main passions and endeavors. This is the idea that information really only becomes “Business Intelligence” when it has been imbued with the appropriate context. One might say that… Continue reading Welcome! – and what this Blog is about