Tech Tip: Connect to Snowflake db using #SQLDevModeler

So, some of you may have noticed that I took “real” job this week. I am now the Senior Technical Evangelist for a cool startup company called Snowflake Computing. Basically we provide a data warehouse database as a service in the cloud. Pretty cool stuff. (If you want to know more, check out our site […]

Better Data Modeling: What is #DataVault 2.0 and Why do I care?

Have you heard? Dan Linstedt has just had his new book published on Data Vault 2.0. It is called Building a Scalable Data Warehouse with Data Vault 2.0. If you are at all into data warehousing and agile design, you need to get this book now. So click here and be done. For those of […]

Oracle SQL Developer Data Modeler 4.1.2

Originally posted on HeliFromFinland:
The best news on Friday Oct 23rd was that version 4.1.2 of Data Modeler came out! We were really waiting for this release because of some bugs on 4.1.1 that made our lives quite difficult. Thank you development team for fixing everything so quickly and releasing 4.1.2 so fast! If you…

SALE: Oracle SQL Developer Data Modeler Jump Start

So in honor of the upcoming #OOW15 and User Group Sunday Symposiums, I decided to put my video workshop for #SQLDevModeler on Sale! Why use #SQLDevModeler? If you were an Oracle Designer user and are looking for a replacement data modeling tool, or you are using one of the other mainstream, expensive modeling tools and […]

The Data Warrior Goes to Oracle Open World 2015 (#OOW15)

Yes boy and girls, it is that time of year again. Time for the BIG show in San Francisco – OOW15 I will as usual, attend, but only for a few days this year (been away from home too much). My Talk I will be presenting my session Worst Practices in Data Warehouse Design (UGF9985) […]

Honored to be an Oracle Developer Choice Awards – Application Express Finalist

Originally posted on TH TECHNOLOGY:
I am honored to be a finalist in the Oracle Database Developer Choice Awards, in the Oracle Application Express category. I am most impressed with my fellow finalists – amazing devotion to helping the APEX community – and humbled to be included in such a crowd.  Congratulations to all! Please…

Better Data Modeling: Showing Super & Sub Types in #SQLDevModeler (SDDM)

So this started with a not so innocent tweet from Jeff Smith: @GuillaumeSL i’m betting @KentGraziano could answer your question right away — Jeff Smith (@thatjeffsmith) September 14, 2015 // Well, I sort of answered at least part of the question (eventually),  but along the way the topic of using super types and sub types […]

Recognizion for a DB Designer, FINALLY!

Originally posted on HeliFromFinland:
Finally the work of a database designer will be recognized! Oracle has announced the Oracle Database Developer Choice Awards nomination and one of the categories makes me very, very happy: DB Design. It has been too long that the work of a database designer has been ignored. If you know a…

How to define a PK using Data Modeler?

Originally posted on HeliFromFinland:
Primary Key (PK) identifies uniquely each row in a table. There can never be two tuples with same values in PK. There are two ways of defining a PK: a natural key or a surrogate key. I would say that if you can find a natural key that is always better.…

You asked for it! #DataVault 2.0 Boot Camp with The #DataWarrior in The Woodlands, Texas

Yes it is on! This is your one chance this year to come to Texas and learned Data Vault WHEN: Tuesday, September 15, 2015 at 8:30 AM – Friday, September 18, 2015 at 12:00 PM (CDT) WHERE: The Woodlands, TX How Much? Early Bird Price: If you purchase before August 15, 2015 you get this […]