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,517 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,809 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,120 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,271 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,257 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
2,005 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,803 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,404 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,077 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,161 reads
Blogs
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
Forums
Alamat BCA KCP Muara Karang 2 (+62 838-4945-0961)
Wa:083849450961 Jl. Pluit Karang Blok D-7-U. 211A Kav.1 & No. 211, Kav 2, RT.10/RW.3,...
Alamat Telp BCA KCP Citra 2 Ext +62 838-4945-0961
Wa:083849450961 Ruko Citra Garden II, EXT Blok BE 01 A / 01 & 02,...
Alamat BCA KCP Duta Gardenia +62 838-4945-0961
Wa:083849450961 Ruko Duta Garden, Duta Gardenia I Blok B2-B3, RT.001/RW.008, Jurumudi Baru, Kec. Benda,...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers