For a while, I have been working on figuring out a “better” way to get data from DB2 to Microsoft SQL Server. There are many different options and approaches and environments, and this one is mine, your mileage may vary.
Usually, when pulling data from DB2 to any Windows box, the first thing [...]
Comments | 3,120 views
Most ETL systems (at least that I have seen/studied/worked on) that populate data warehouses run something like
1) Load Dims
a) populate an unknown
b) populate dim data
2) Load Facts
a) join/lookup to dim’s, and if no match, set as “unknown” dimension record
3) Process Cube
This type of system works in many cases, but there are some flaws that bubble [...]
Comments | 1,358 views
Since I make a living and love working on Windows, SQL, Windows Server, Office, Exchange, etc, it is kind of weird I am a Mac guy. Never thought it would happen. iPhone, Mac, Macbook Pro, Apple TV, Time Capsule, accessories…
Anyways, since Ella was born, I have TONS of pics and videos of her, on [...]
Comments | 764 views
Throughout all my years in different places, I have seen SQL, Oracle, Firebird, MySQL, DB2, Zortec, Access, and probably a few other crazy databases set up and run, and administered. Of course most of them along the way have been Microsoft SQL Server, (6.5, 7, 2000, 2005, 2008). I’ve worked with some knowledgeable DBA’s, and [...]
Comments | 2,083 views
Windows 7 RC1 just came out. I am a TechNet subscriber, so I wanted to try it out. I have an old (2005) Dell desktop, 2.8 GHz, 2 GB ram, 160 GB drive box. 3.7 rating for Vista (because of the Graphics card mostly, would be 4.4 otherwise – not too bad, even for being [...]
Comments | 1,168 views
So last night I decided it was time. Time to put and end to the madness, the quizzes, the nonsense, the “friends on my list that aren’t really my friends” game. What I decided to do was just… delete them all. Everyone. Then see how my “friend” list grows from there.
[...]
Comments | 892 views
