SSRS Map Layers Parameter
With the new Map control in SSRS 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If...
2013-11-15 (first published: 2013-11-11)
1,502 reads
SSIS Pivot on bad data
The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even...
2013-10-31 (first published: 2013-10-28)
1,793 reads
SSIS Records on the Same Row – kind of like pivot
If you have two or more records on the same row, and need to write each record on its own...
2013-10-11 (first published: 2013-10-07)
2,099 reads
MDX YTD Calculation Issus
If you are using the templates for MDX calculation built into SSAS 2008 you might run into some strange issues....
2013-09-30
1,253 reads
MDX Scope with an If Then statement
The scope statement in MDX is great for applying calculations to a certain area of a cube, also called a...
2013-09-23
1,229 reads
Loop Through Excel Files in SSIS
You can loop through excel files using SSIS. This will use the For Each Loop container and a data flow...
2013-09-16
1,918 reads
Junk Dimensions with no Loading Needed
When you are working with dimensional modeling there are some situations where several dimensional attributes don’t make since to be...
2013-09-09
1,770 reads
Handling Large Many to Many bridge tables
In some scenarios you will need to create a many to many relationship in your cube in SSAS. One of...
2013-09-02
3,361 reads
Execute SSIS Packages with a Macro in BIDS
When running SSIS packages in BIDS it is common to click on the green arrow at the top of BIDS...
2013-08-26 (first published: 2013-08-19)
2,057 reads
Environment Variables in SSIS Packages and Configuration Tables
Configuration tables are a best practice in just about any SSIS environment. They make it easy to update multiple packages...
2013-08-12
2,144 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers