The Data Warrior

Changing the world, one data model at a time. How can I help you?

Archive for the category “Oracle”

02 Feb 2012

Ready for a Rocky Mountain High?

Got the mid winter blues?

Ready for some bright sunshine and fresh mountain air? Maybe some snow?

The wait is almost over! RMOUG Training Days 2012, February 14 – 16, is only 14 days away! That’s right, only a few days until the biggest, and the best regional Oracle users group conference kicks off! But why wait until the last minute?

You still have a few days to take advantage of the lower Standard Registration rates. Register by February 9 to receive the lower rate.

And don’t forget to sign up for a University session. I am participating in this one:

Data Warehouse Performance

Jerry Ireland, Rightsizing Inc., Mark W. Farnham, Rightsizing, Inc., Tim Gorman, Evergreen Database Technologies, Inc, & Kent Graziano, TrueBridge Resources

This session brings together four experts in performance and data warehousing. All are Oracle ACEs, two are members of the OakTable, and together they represent over ninety years of experience with Oracle. All of the ideas and techniques presented can be implemented with minimal additional hardware and most with a manageable effort. The session will start with some hints and tips that can be used on existing data warehouses and progress to a method of getting performance when the CBO does not recognize a star schema. The session will present partitioning strategies to increase scaling, and finally take a glimpse at some of the benefits of relatively new, but growing, database architecture. The day will be wrapped up with a Q & A with all symposium presenters.

So don’t delay, make your plans today!

And maybe get some skiing in?

See ya!

Kent

Posted in Data Warehouse, Oracle, User Groups and tagged , , , | Leave a comment
24 Jan 2012

Hello Montreal!

Well, it took all day, but I am safely tucked away for the evening in my hotel (Le Meridien Versailles) in Montreal.  I am here for a three-day Data Vault Certification class.

I left Houston this morning, flew through Cleveland (CLE) and then to Burlington, Vermont. There, my good friend, Dan Linstedt, kindly picked me up at the airport and drove us across the border to Montreal, Canada (which took about 2 hours) and deposited me at my hotel. Dan lives north of Burlington and was coming this way anyhow (he is actually teaching the class I am attending). It was a great chance for us to catch up as we have not seen each other (face to face anyway) for quite a few years. Look for some big things from Dan in the coming months.

Monday night I prepared for the class by loading up my laptop with all the latest Oracle toys: SQL Developer Data Modeler Release 3.1 Early Adopter, SQL Developer Release 3.1 Early Adopter, and the Oracle Database 11g Express Edition Release 2 (AKA Oracle XE). These are all free tools and very easy to set up (even for a non-DBA like moi). With that I should be able to actually build out the examples in the class for real.

(Hmm…maybe I can use those for examples in my KScope 12 session…)

In any case, it should be a fun few days meeting some new people, seeing a new city (I have never been here before), and seeing what new techniques Dan has come with in the Data Vault arena.

Stay tuned this week as I plan to provide some updates each day on what I learned in the class. (You might want to click the “follow” button if you haven’t already)

If there are any questions you want me to ask Dan, leave them below in the comments.

 

Posted in Data Vault, ODTUG, Oracle, SQL Developer Data Modeler, User Groups and tagged , , , | Leave a comment
06 Jan 2012

Don’t forget to register for RMOUG Training Days

Yes, it’s that time of year – time to get on board for the Rocky Mountain Oracle Users Group annual training event in Denver, Colorado. All I can say is that it is certainly the biggest and best regional Oracle conference I have ever been too. (To be fair – I helped organize the very first one and quite a few after that!)

Don’t miss it – register soon.

I will not be attending in person this year but I will be there remotely delivering part of the Data Warehouse Performance university session.

Anyway – check it out .

Later,

Kent

Posted in Oracle and tagged | Leave a comment

Post Navigation

Newer Entries →