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 you might [...]
View Comments | 4,598 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 [...]
View Comments | 2,008 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 [...]
View Comments | 1,005 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 [...]
View Comments | 2,373 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 [...]
View Comments | 1,566 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. I think one thing [...]
View Comments | 1,222 views
