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,497 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,786 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,094 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,249 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,220 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,884 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,764 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,350 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,053 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,141 reads
Blogs
Back in the EU
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Setting up SQL Server S3 Object Storage Integration using MinIO with Docker Compose (Updated for SQL Server 2025)
Update for SQL Server 2025: This post and the GitHub repo have been updated for...
Forums
Flexible Laptop on Rent in Noida for Students & Businesses
Looking for laptops without heavy investment? Laptop on rent in Noida is ideal for...
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers