In the webinar, Demystifying Macros with ER/Studio, Embarcadero Software Consultant Stanley Chan demonstrated how macros work in ER/Studio. He showed how to use the built-in macros and also shared some custom macros during the session. If you missed the live presentation, you can watch it on demand. There were a lot of great questions during the session, some of which Stan didn’t have time to answer live. So he has provided responses to several of those for this blog. Q: In the color-coding de...

Are you tired of people finding errors in your data models once they go to build an application on top of that fine database you designed for them?  Would you like to be in on a secret that others have to spend thousands of hours in the gym to accomplish?  Well I have the solution for you.  All you have to do is call in the next 7:00 minutes with your credit card number handy.   Hold on.   I first heard about this trick during one of my EDW sessions on database desig...

Во время вебинара (Web-семинар) по ER/Studio 17 ноября мне был задан вопрос о том, почему после процесса создания новой модели БД непосредственно с сервера Oracle (обратное моделирование или реверс-инженеринг) в одной из таблиц появились колонки со странным типом данных: NUMERIC(0,0). Хочу остановиться на этом вопросе несколько подробнее. Давайте проведем соответствующий эксперимент. В окне cmd запустим sqlplus. Выполним подключение под соответствующим логином. В данном случае я вошел под ...