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,494 reads
Mike Davis SQL
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,785 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,093 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,248 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,205 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,823 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,759 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,341 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,139 reads
Blogs
The Third Sabbatical
By Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
Advice I Like: Focus on what’s important
By Steve Jones
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...
Is Air Travel Still Safe? | Ahmedabad Plane Crash 2025 Explained | Aviation Safety & AI Solutions
By Rohit Garg
Is Air Travel Safe? Yes, air travel remains statistically the safest mode of transportation. In...
Forums
200 hours YTT in Rishikesh
Embarking on a 200 hours YTT in Rishikesh is a transformative journey that goes...
Azure Database Watcher Monitoring
Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...
Can You Ask for a Raise?
Comments posted to this topic are about the item Can You Ask for a...
Question of the Day
Generating a Series I
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers