I love getting to see new technologies changing the world. The opening of the new Vancouver Microsoft Canada Excellence Centre included prominent Microsoft and Canadian leaders, including our Geek Prime Minister. Take a few minutes to see how all my favourite buzzwords come together:
Microsoft + my Canadian BF + Jobs + Deep Learning + AI + Machine Learning + Investing + Accessibility + YVR + SEA + Innovation + Prime Minister "knows how to code already" + Geek + Big news for Canada
This sort of “making a difference” is why I keep getting out of bed in the morning.
I was preparing for my webinar tomorrow for Idera when I decided to look up how long ER/Studio Data Architect has been around. I was happy to see that the press release for ER/1 (what it was called before they got in a bit of a trademark issue with ERwin* folks) that it was released on 15 March 2006.
I started using ER/1 not too long after that.
Some Interesting ER/Studio Trivia
- ER/1 listed for $1399 a seat, but there was a special deal for a few months to get it for $899.
- It could handle “hundreds of entities”
- It did not feature bi-directional updating of Logical to Physical
- It did not yet feature on diagram editing
- You can still download the Documentation for ER/1 1.0
- it supported:
- Oracle 7
- Sybase 11 and 10
- Microsoft SQL Server 6
- SQL Anywhere
- SQL Base
- “ER/1 can x-ray your databases and extract their structure” < Love this.
- It followed IDEF1X methodology adopted as part of the Federal Information Processing Standards
- Submodelling (Subject areas diagramming) was not supported yet.
- There was a separate product ER/1 for Borland Interbase
March 15, 1996
Embarcadero Technologies Ships ER/1 Data Modeling Tool
San Francisco, CA, March 15, 1996, Embarcadero Technologies today announced the general availability of ER/1, a new visual, entity-relationship modeling tool. ER/1 supports all major SQL database platforms, including Oracle7, Sybase 11 and 10, Microsoft SQL Server 6, Informix, DB2, SQL Anywhere, Watcom and SQL Base.
ER/1 delivers a slew of features that promote high-quality, functionally correct data models as well as unparalleled power, ease-of use and value. Its highly customizable design allows you to create visually appealing diagrams with such tools as dockable toolbars, diagram zooming, and print scaling. Powerful inheritance logic is built into ER/1 providing referential integrity throughout your data model. In addition, ER/1 provides you with the following major features to facilitate the creation of both logical and physical designs:
Accurate and Quick Reverse Engineering
ER/1 x-rays your databases and extracts their structure into entity-relationship diagrams capturing the complete definition of your tables, including constraints, primary keys, foreign keys, indexes, table and column comments and all table dependencies.
Automatic Database Builds
ER/1 uses an ODBC connection to create a physical implementation of the logical database design you created in ER/1. This one-step process involves the creation of tables, indexes, triggers, stored procedures, views, defaults, rules and user datatypes and properly orders the creation of these objects to eliminate dependency errors.
This feature promotes code-reuse by providing a central repository to store rules, defaults, and user-defined datatypes. Once you establish a business rule as a Data Dictionary object, it is re-usable throughout your diagram. In addition, the Data Dictionary supports global updates of
these objects. Just make the change once in the dictionary and ER/1 automatically propagates these changes throughout your diagram.
ER/1 offers the most comprehensive reporting of any data modeling tool. It completely documents both your logical and physical designs and generates professionally formatted and structured reports at the summary or detail level.
Code Generation for Team Development
ER/1 can write SQL source code files ready for version control and team development. To facilitate team programming, you can generate separate source code files.
ER/1 for Windows 95 and Windows NT is priced at $1399 per user. Through April 30, 1996, Embarcadero Technologies is offering a special introductory price of only $899 per user.
About Embarcadero Technologies, Inc.:
Embarcadero Technologies is a software products company specializing in tools to design, create, administer, query, program and monitor Oracle, Sybase, Microsoft, and Informix databases. Embarcadero offers a suite of products marketed to corporate customers and database professionals worldwide and has rapidly become the leading provider of database administration tools for Sybase and Microsoft SQL Server. Embarcadero’s software has been recognized for excellence with outstanding independent product reviews conducted by PC Week, DBMS, Microsoft BackOffice Magazine and Databased Advisor.
Data Modeling Tools are Experienced
One of the reasons why some people find data modeling tools overwhelming is that they’ve been around for more than 20 years. That’s a long time for these tools to get more customized, more feature-rich, more complex.
I should give a shout out to Greg Keller, who was the product manager during the time I started using ER/Studio.
So happy birthday, Embarcadero…I mean…Idera…ER/1….ER/Studio. I’m going to have a cupcake in your honor! Maybe twenty.
*Say “ER One” Then say “ER WIN”. Yeah, almost a SOUNDEX trademark issue.
NOTE: There’s a 10% savings if you do early registration by 27 January 2016. CLICK THE BUTTON BELOW TO REGISTER.
Due to event rules, you must have a Canadian or US address to go for the medal/swag option, but if you live elsewhere, you can register under the “no swag” option. So anyone can join us.
We are repeating our efforts to be math-y runners by creating a team for #PiDay5k. Join us for a virtual run/walk/crawl. There’s great swag (Medal, t-shirt, stuff) and a chance to be part of a nerdy effort to move on Pi/Pie Day, 14 March 2016.
This isn’t competitive, much (there are some great prizes for special categories). You can cover your 5k distance how ever you want, at the pace you want…you can even spread it over several days. You can complete it on a treadmill or at your gym. Last year this fell just before a race, so Josh Fennessy (@joshuafennessy | blog ) and I walked a 5k. Then we ran a half marathon a few days later.
This year you can register for a 5k or a 10k, plus you can choose to register with a no-swag option. Just click on the button below to get signed up for the distance and package you want.
As a virtual race, you register before hand, they ship you the goods (including a race bib) and you complete your distance, then share that you completed it. It’s all on the honour system. We on #TEAMDATA (that’s you!) think the honour system is a good thing.
There’s even a kids option!
BTW, ladies, like all promotional shirt things, I recommend you size up two sizes if you want a shirt you can actually wear. Men, you likely want to size up, too.
I’ll update the #TEAMDATA roster here as we get signups. Join us in all the #nerdshirt glory of Pie, Pi and a 5k
Have questions? There’s a FAQ for that.
Registered Awesome Data Professionals:
@datachick Karen Lopez
@projmgr Rob Drysdale
Barbie Buckner, CA
Tom Bilcze, OH
Corine Jansonius , AB
Kim Medlin, NC
It’s a new year and I’ve given Thomas LaRock (@@sqlrockstar | blog ) a few months to recover and ramp up his training since our last Throwdown. The trophies from all my wins are really cluttering my office and I feel back that Tom has not yet had a chance to claim victory. So we will battling again in just a few days.
I’ll be dishing out the knowledge along with a handkerchief for Tom to wipe up his tears at SQL Saturday #461 Austin, TX on 30 January 2016. This full day community-driven event features real database professionals giving free presentations on SQL Server and Data Platform topics. All you need to do is register (again, it’s free) before all the tickets are gone.
Database Design Throwdown
Duration: 60 minutes
Track: Application & Database Development
Everyone agrees that great database performance starts with a great database design. Unfortunately, not everyone agrees which design options are best. Data architects and DBAs have debated database design best practices for decades. Systems built to handle current workloads are unable to maintain performance as workloads increase.Attend this new and improved session and join the debate about the pros and cons of database design decisions. This debate includes topics such as logical design, data types, primary keys, indexes, refactoring, code-first generators, and even the cloud. Learn about the contentious issues that most affect your end users and how to avoid them.
One of the other great benefits of attending these events is that you get to network with other data professionals who are working on project just like yours…or ones you will likely work on at some point.
Join us an other data pros to talk about data, databases and projects. And make sure you give a #datahug to Tom after the Throwdown. He’s gonna need it.
I posted a tongue-in-cheek Twitter poll about some database design features that tend to polarize team members.
Of course, every design decision comes down to cost, benefit and risk. So there aren’t any evil choices.
How would you vote?
I conducted a Twitter poll last week about how to spell DATATYPE (or is it DATA TYPEs?). Many compound words start out as two separate words, then get hyphenated, then concatenated to a new word. We saw this with:
data base –> data-base –> database
I keep seeing data types spelled both ways (and never as data-type).
Ted Codd used DATA TYPE in his 12 Rules for a Relational Database Product.
Embarcadero ER/Studio and CA ERwin Data Modeler use DATATYPE in their products and occasionally use DATA TYPE in their help or documentation.
Oracle uses both spellings in their documentation. Microsoft sticks heavily to DATA TYPE.
Twitter polls last for 24 hours and not all clients can see or vote on them. So consider this more of a fun question on social media.
How do you spell this concept? Are there other words you find with a variety of spellings?
…looks like to me.
Sure, you’ve got your own home-grown database security system all designed and working in development. And then you ask me to confirm that it’s “safe”. I’ll tell ya “it’s safe as long as you don’t actually put any data in it”.
Subscribe via E-mail
- September 2016
- August 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- January 2016
- December 2015
- November 2015
- September 2015
- July 2015
- June 2015
- May 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- September 2010
- August 2010
- July 2010
- February 2009