Tod means Fox

Business Intelligence, Data Warehousing, SQL, Visual FoxPro.

All TmF Articles

 

DataBased Advisor 2008 week 17
Auditing Your Warehouse for Sarbanes-Oxley Compliance

DataBased Advisor 2007 week 40
Cleanse and Conform Data to Prepare it for a Microsoft Visual FoxPro Data Warehouse

DataBased Advisor 2007 week 27
From Source to Warehouse: A Microsoft Visual FoxPro Data Integration Strategy

DataBased Advisor 2007 week 18
Warehouse Data with Microsoft Visual FoxPro

Blog Postings

ETL Subsystem 12: Special Dimensions Manager
…and in this corner…
34 Subsystems of ETL Data Integration
5 Ways to Automate Development in FoxPro
7 Productivity Tips for Better Software Development
A Data Warehouser’s Vocabulary (Part 1)
A Datawarehouser’s Vocabulary (Part 2)
An Improved Median Function
An Introduction to the Coverage Profiler Application
An SSIS Custom Transformation Success Story
Analyze Apache Raw Access Logs in FoxPro
Another article published online regarding MasFoxPro Effort
Book Review: Blink
Book Review: SOA Approach to Integration
Book Review: SQL Server Integration Services Using Visual Studio 2005
Boundary Testing — CASE: Get Median function
Boundary Testing Parameters
Broken Promises of Drag-and-Drop Programming in SSIS
Business Intelligence Through Web Analysis
Business Processes and the Integrated Enterprise
Cast(), Str(), or Transform() — Choose wisely!
Central Kentucky Computer Society offers VFP class
Certification revamp at MS does not inlude VFP
CoDe’s Sedna Issue
Compare a String to a List of Formats
Conforming Temperature in FoxPro (some conversions)
Cooling Down
Data Profiling
Data Warehouse Lifecycle in Depth
Database Design: 4th and 5th Normal Forms
Dave Aring’s Lazarus
David Fulton
David Woods Learns FoxPro
Debug Environment
Defining Business Intelligence and Data Warehousing
Delete Duplicates from a Table
Dimension Tables
Dimensional Modeling: Loading The Slowly Changing Dimension
Errors Eating My TEXTMERGE
ETL Subsystem 10: Surrogate Key Generator
ETL Subsystem 11: Hierarchy Manager
ETL Subsystem 13: Fact Table Builders
ETL Subsystem 14: Surrogate Key Manager
ETL Subsystem 15: Bridge Table Builder
ETL Subsystem 1: Data Profiling
ETL Subsystem 2: Changed Data Capture
ETL Subsystem 3: Data Extraction
ETL Subsystem 4: Data Cleansing
ETL Subsystem 5: Error Event Management
ETL Subsystem 6: Auditing
ETL Subsystem 7: Removing Duplicates
ETL Subsystem 8: Data Conformance
ETL Subsystem 9: Slowly Changing Dimensions (SCD)
Ezelsbruggen
Fact Tables
Finally… Sedna
Find Unmatched Keys from Two Data Sets
First FoxPro, now Jericho
First test case using get_median
Formula 409: Private Companies Must Comply with SOX
Fox Houses
FoxForward is Only a Few Weeks Away
FoxForward Session Material Posted
FoxPro a Big Hit in China
FoxPro ActiveX (FPOLE.OCX) Security Bug Fix
FoxPro is sort of alive and well
FoxPro One of Three Development Languages Supported on Vista
FoxPro’s Sometimes-Mysterious Replace
FoxPro: A tool for developing countries
FoxShow 41 FoxForward (and beyond)!
Full Eclipse of the moon
Fun with Serial Dates
Future of FoxPro
Gary Gygax, Co-creator of D&D, Has Died
Geek Love
Getting Busy with MSBuild :: Deploying Heavy Projects
Getting Started with Data Profiling
Graphical Execution Plan Notes for SQL Server 2005
Guineu means Fox
Hand Coding the Data Warehouse with VFP
Handling Errors in Visual FoxPro
HIPAA, PHI and the Patriot Act
HTML Standards? Anyone? Anyone?
I am King
ID Lookup Custom Transform (Part 1 of 3)
ID Lookup Custom Transform (Part 2 of 3)
ID Lookup Custom Transform (Part 3 of 3)
Interpolation
Introducing the New Whitepaper Section
Jericho Update!
Just a Cool Day
Let Visual FoxPro Check File Permissions
Life in Redmond
Live from FoxForward: Day 2 (Maps, Services, and Tiers…oh my)
Live from FoxForward: In Alpharetta with My Mustang
Live from FoxForward: The Last Day
Live from Kimball University: Day 1 (planning, requirements, dimensional models)
Live from Kimball University: Day 2 (SCDs, the Mini, Modeling Process)
Live from Kimball University: Day 3 (Architecture, Metadata, Real Time BI)
Live from Kimball University: Day 4 (ETL, Addresses, Applications, BI Toolkit?)
Log4Fox Revival: Instrumenting VFP Applications
MapPoint, GDIPlusX, and EXIF Metadata
Marketing for FoxPro
Metadata, Pattern Implementation, and Customization
Microsoft and Open Source
Milind Lele’s April 2007 - Letter from the Editor
Missing Him Already…
More Reviews on the Way
Mums the word: KU Alumni Group in the works for LinkedIn
News from the Kimball Group
Newton’s Method for Approximating the Zeros of a Real-valued Function
Not So Big Anymore
Parsing City/State/Zip
Parsing firstname / middlename / lastname
Ragged Hierarchy Alert
Sample Standard Deviation (and SQL)
Save Jericho!
Site Update: Resource Page Additions
Some Time Off with Sara
Sorting IP Addresses in VFP
Spam and Rabbit Stew Lounge
SPS VFPEncryption Update
SQL implementations, database servers, and VFP
SSIS Debugging: Find in Files, Naming Conventions, and a Problem Solved!
SSIS Expressions (by Scott Whigham)
SSIS Packages and setting up Jobs
Stubborn Foxers labeled unwilling to learn
Sys(2017) and Comparing Data
Take That, Microsoft!
Take the Survey!
The “Not Intersect” or “Symmetric Difference” Between Two Tables
The 64-bit excuse
The 80/20 Principle and Software Development
The CBS/Jericho Nuts Campaign is Really Taking Off!
The Future of Open Source in BI
The Role of Good Database Design and Normalization for Data Integration Projects
Tod means Fox (b)
Trends in Business Intelligence
Under rock? SP2 and Sedna betas released.
UNION oddity (or maybe it’s just me)
Updated VFP9 with SP2
Use .sql Files with SQLEXEC for Better Script Management
Use Beyond Compare to compare tables in VFP
Using ASSERTS with VARTYPE to Test Parameters
VFP Boot Camp in Kansas City this August
VFP Boot Camp in October
VFP Conference Attendance
VFP gotcha with _TALLY, RECCOUNT, DELETED, and an INDEX
VFP INTERSECTing SQL
VFP Workshop
VFP9 at Amazon.com for ?
VFPBuild to build Visual FoxPro Applications Using MSBuild
W32.Ukuran.Worm attacks FoxPro DBFs
Warehouse Data with Microsoft Visual FoxPro
We’re a cultish group, aren’t we?
Web Analysis with VFP: Download, Parse, and Stage
Welcome to the new Tod means Fox
Welcome to Tod means Fox
What is MDM Anyway?
What’s faster? SQL or looping to return a set of records?
Who’s Blogging From SWFox 2007?
Windows Live Spaces fails validation
Working in the Phone Booth (another article ’bout MS and VFP)