An Expert's Guide to Oracle TechnologyLewis Cunningham is an Oracle ACE, Database Architect and self-professed database geek. Lewis has almost 20 years of database experience. Follow along as he builds a working Oracle encyclopedia, sharing his knowledge and experiences, and describing ways to integrate that technology in various projects and business areas.Off Topic: The Katrina Myth- August 29, 2008 LewisC's An Expert's Guide To Oracle Technology On this, the third anniversary of Hurricane Katrina, there is a hurricane (Gustav) setting its sights on New Orleans (and another, Hanna, in the Atlantic). It's looking like it might be a busy storm ye...http://networking.ittoolbox.com/r/rss.asp?url=http://it.toolbox.com/blogs/oracle-guide/off... Update on my whereabouts- August 26, 2008 I know I haven't posted much recently. I'm posting this from my blackberry in Iowa City, Iowa. I was in Chicago yesterday. I don't have my laptop with me on this trip so I feel waaayyyyyy out of touch. I'll have some good topics to write about soon. I'm able to spend some time on warehousing topics now (that is the focus of my job now) so that will be a major focus for me on the blog, too. I have not been able to dowload and clean up the survey data as of yet. I'll be back in tampa onhttp://networking.ittoolbox.com/r/rss.asp?url=http://it.toolbox.com/blogs/oracle-guide/upd... Database Survey Closes Aug 24- August 19, 2008 This is the last week to participate in a database usage survey. The survey will be closed on Aug 24. I'll download the responses, clean the data and then upload the raw results. Over the next couple of weeks, I will publish some personal analysis and thoughts of the data. If you haven't already done so, please take a few minutes to answer 25 questions. I may reopen the survey afterward ahttp://networking.ittoolbox.com/r/rss.asp?url=http://it.toolbox.com/blogs/oracle-guide/dat... Oracle 11g Mini-tip: Ordering Trigger Execution- August 13, 2008 LewisC's An Expert's Guide To Oracle Technology Oracle does not guarantee that multiple triggers on a table will fire in any particular order. Well, they do guarantee some things. For example a BEFORE trigger will fire before an AFTER trigger and ROW triggers fire before STATEMENT triggers. But for two triggers of the same type (say 2 BEFORE ROW triggers), Oracle does not guarantee which wihttp://networking.ittoolbox.com/r/rss.asp?url=http://it.toolbox.com/blogs/oracle-guide/ora... MS Live Mesh Overview- August 8, 2008 LewisC's An Expert's Guide To Oracle Technology You might not think of remote desktop as a cloud tool but MS has added cloud storage to remote desktop and called it Live Mesh. I have been using it recently and it is pretty nice. I use VNC fairly extensively and, when I'm not using VNC, I tend to use a hrhttp://networking.ittoolbox.com/r/rss.asp?url=http://it.toolbox.com/blogs/oracle-guide/ms-... Way Cool Job On The West Coast- August 7, 2008 LewisC's An Expert's Guide To Oracle Technology Just thought I would pass this along. Aptana is looking for people to join their Cloud Team. This looks like a very cool job. Areas and systems of interest: li style="MARGIN:http://networking.ittoolbox.com/r/rss.asp?url=http://it.toolbox.com/blogs/oracle-guide/way... 100% SQL Developer 1.5- August 7, 2008 LewisC's An Expert's Guide To Oracle Technology Well, I have made the leap to SQL Developer. No more TOAD. In the past, I was using SQL Developer quite a bit but I would still fall back to TOAD for certain things. No more. I am using v1.5 and have not had any weird crashes, no performance problems. There's nothing that I need to do that I can't. In a few instances, I have had to search arouhttp://networking.ittoolbox.com/r/rss.asp?url=http://it.toolbox.com/blogs/oracle-guide/100... Does Oracle Require a License For a Development Database- August 6, 2008 LewisC's An Expert's Guide To Oracle Technology I think I have once again run into one of the most misunderstood issues facing Oracle shops. We run RAC in an SE environment and were thinking about setting up a new development (with RAC) configuration. Do we need to purchase a license to develop and test in this environment The short answer is that in most cases, yes, we must purchase a license.phttp://networking.ittoolbox.com/r/rss.asp?url=http://it.toolbox.com/blogs/oracle-guide/doe... State of the Database 2008: Vertica, Part 2- August 5, 2008 LewisC's An Expert's Guide To Oracle Technology In the first part of this series, I talked about Vertica the company and how Vertica is licensed. This entry will discuss the architecture of the database and how it handles various issuhttp://networking.ittoolbox.com/r/rss.asp?url=http://it.toolbox.com/blogs/oracle-guide/sta... Book Review - High Performance MySQL- August 4, 2008 LewisC's An Expert's Guide To Oracle Technology Chapter 1: MySQL Architecture Chapter 1 is an overview of the MySQL architecture. The chapter doesn't get very deep into MySQL internals (thats not the books focus) but this chapter provides an excellent fast track understanding of how MySQL works at a fairly detailed level. This chapthttp://networking.ittoolbox.com/r/rss.asp?url=http://it.toolbox.com/blogs/oracle-guide/boo... |