Category Archives: Data Modeling

Automating ER/Studio with C# code.

I really enjoy data modelling and I really enjoy using the various modelling tools I’ve come across. All of them have their charms and their drawbacks. But I’ve yet to use one which works the way I want it to … Continue reading

Posted in Automation, Data Modeling, ER/Studio | Tagged , , , | 2 Comments

Broaden your vision

Where there is no vision, the people perish (Proverbs 29:18A, KJV) It’s old wisdom but still valid. When you have no direction you flounder and sometimes the people around you flounder, too. This is true in the tech world as … Continue reading

Posted in Automation, Business, Data Modeling, Life, PowerShell, spirit, Sybase PowerDesigner, Tools | Tagged , , , | 2 Comments

Data Modeling, Conciseness and Philosophy

Graeme Simsion and Graham Witt use the term conciseness to describe one of the most interesting aspects of a data model. Simsion and Witt write that a good data model implicitly defines a whole set of screens, reports and processes … Continue reading

Posted in Data Modeling, Life, Uncategorized | Tagged , , | Leave a comment

Importing Column Documentation from a CSV into a Sybase PowerDesigner Data Model

(Update – I have a more efficient version of this script posted here) I’m a big fan of data modeling tools. I used to chafe against them as so often it was easier for me to think in code. But … Continue reading

Posted in Automation, Data Modeling, PowerShell, Sybase PowerDesigner, Tools | 4 Comments