Category Archives: SQL Server
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
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
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
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