I generally don't make resolutions, especially at the end of a year. I'm more of a "make small changes, every day, that will make a big difference over a year" type person.  For blogs and communities, resolution making is a tradition and we a ...

I generally don't make resolutions, especially at the end of a year. I'm more of a "make small changes, every day, that will make a big difference over a year" type person.  For blogs and communities, resolution making is a tradition and we a ...

I generally don't make resolutions, especially at the end of a year. I'm more of a "make small changes, every day, that will make a big difference over a year" type person.  For blogs and communities, resolution making is a tradition and we a ...

I generally don't make resolutions, especially at the end of a year. I'm more of a "make small changes, every day, that will make a big difference over a year" type person.  For blogs and communities, resolution making is a tradition and we a ...

Another option for doing this is to use a macro in ER/Studio to create all the FK indexes automatically. Then only remove ones that we know for certain are unneeded (extremely rare). So Reverse Engineer the database, run the macro, then compare to

One of the comments I got elsewhere to this post is that the models we create in ER/Studio are not data model, and therefor my terminology here is all wrong. What say you?

I was with a client for lunch one day and we asked the server "What do you have on tap?"  She was gone quite a long time, but came back and said "Beer."  It turned out she was right.  But her answer was not that helpful. One ...

I cleaned up a bunch of definitions and reformatted a bunch of diagrams. What did you do?

Just in case you've been head-down into your data models for too long, in the US the Friday after Thanksgiving is called Black Friday. Traditionally this is a day for massive s ...

Just in case you've been head-down into your data models for too long, in the US the Friday after Thanksgiving is called Black Friday. Traditionally this is a day for massive s ...

I'm getting these error when reverse engineering a database. I have never had a view throw these errors, so I'm not sure what to look at in the actual database. They appear to be FK violations, but they are being reported on SQL Server Views, which do not have FK constraints.
So what does this error message really mean?
Foreign Key Constraint , Parent: {view name one}, Child: {view name two} completes a circular chain
The relationship has been deleted from the model.
I'm not sure what relationships have been deleted.

Read More...

Second post in my series about Agile/Fragile Data Modeling.

http://community.embarcadero.com/index.php/write-blog-post/entry/are-your-data-models-agile-or-fragile-sprints 

Getting stories to start modeling at the same time that developers get the stories to start coding is FRAGILE.  Broken. Against the Agile Manifesto.  Who knew?

Karen

Last month I developed a whitepaper and a webinar on data modeling in an Agile environment.  These works focused on what we as data modelers can do to ensure that data models (and ...

Stan, what should users do to report bugs? Just email [url=mailto:[email protected]?][email protected]?[/url] Is there another method?

No, not just you.  I wonder if that is some sort of anti-spam feature they've turned on?  The text in the link is correct....

I've started a blog series about my thoughts on Agile and Data Modeling here.

http://community.embarcadero.com/index.php/blogs/entry/are-your-data-models-agile-or-fragile-documentation