The WordPress.com stats helper monkeys prepared a 2014 annual report for my blog. Not as many posts as 2013 (I was way busy), but sure got a lot more traffic than I realized!
Here’s an excerpt:
The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 58,000 times in 2014. If it were a concert at Sydney Opera House, it would take about 21 sold-out performances for that many people to see it.
Just saw this tweet from Oracle Product Manager Ashly Chen:
Get thee to the site and download away!
Did I say, it is FREE?
(Do remember it is BETA as use it accordingly)
Cheers!
Kent
The Oracle Data Warrior
Back in September at the now annual OakTable world (OTW) at Oracle OpenWorld, I was privileged to give a talk where I ranted a bit about some of the worst data warehouse design mistakes that I have seen.
Well, if you missed out, now you can see that talk thanks to Kyle Hailey who had all the OTW talks videoed. This week, he tweeted that the video was ready for viewing.
So if you missed the talk, or just want to see it again, check it out!
Kent
The Oracle Data Warrior
P.S. If you would like to have me do this very fun presentation at your company or meeting, I would be happy to discuss arrangements with you. You know how to find me so drop me a comment, email, tweet, FB, DM, or even call 🙂
This is a nice piece of functionality that Oracle added to SQL Developer Data Modeler some time ago. Heli gives a nice step by step guide on how to use it.
You can easily document your database with Data Modeler: just reverse engineer the database with File-> Import -> Data Dictionary. But what if the database has no foreign keys? What’s the point of documenting then? Just tables that has nothing to do with each other….
Well, Data Modeler can help with that too: you can use “Discover Foreign Keys” functionality to find the foreign keys that should be in the database and even generate the DDLs for them if needed…
There are two ways Data Modeler can guess the foreign keys for you: the column has the same name as a primary key column in parent table or using the naming templates. And combinations of those.
Select the relational model from the Browser. Right-click and select “Discover Foreign Keys”. I have two tables: CUSTOMER and ORDER.
I will ask Data Modeler to find me the foreign keys.
If I select…
View original post 390 more words
This is quick. Saw it on Twitter this morning and it is just too funny to not share:
Have a great day!
Kent - The Data Warrior
Alumni
Now in paperback!
Kindle format on Amazon
Click to buy on Amazon
Learn Oracle Data Modeler from The Data Warrior
The Data Warrior 