msgbartop
News, views, tips and tricks on Oracle and other fun stuff
msgbarbottom

Click Me Please

The Digg site for Oracle stuff, that’s how Matt Topper described his newly born Oracle site ora-click.com, where you can submit Oracle related stories or articles and vote on submitted ones.

For a start, articles with at least three votes will be promoted to the front page. You can grab the front page’s RSS feed here. Moreover, all the articles you vote on will be saved in your profile for easy retrieval later on.

On Twitter, Jake came up with the idea of feeding OraNA to ora-click, so Matt setup an automatic import of posts from OraNA.info to ora-click.com. The result is that now you can easily vote on your favorite Oracle blog posts without even submitting them, including your own posts if you are an Oracle blogger.

Here is an idea, how about every month, the blogger with the highest number of front page posts is declared the blogger of the month?

1 Comment | Filed in Oracle | Tags:


OraNA.info Now With Categories and More Feeds

Aggregated by OraNA I spent a few hours last weekend categorizing the 300+ Oracle related blogs that are aggregated by OraNA. I tried to follow the categorization on blogs.oracle.com, plus I added a few more.

The new OraNA categories currently include the following:

If you are only interested in specific categories, you can subscribe to the corresponding feeds or follow them on the OraNA.info site. But, if you like to follow all categories, you can always browse OraNA.info or subscribe to the main feed.

By the way, whether you’re browsing one category or all categories, you can always enjoy OraNA’s infinite scrolling capabilities.

4 Comments | Filed in Oracle | Tags:


Oracle Blogs Ranked by Technorati Authority – July 07 Edition

Last May I published a list of top Oracle blogs ranked by Technorati authority. Since then, I have had requests to publish an updated list. I was reluctant to do it because creating the list takes quite a bit of time. However, last Sunday afternoon, I was able to automate the creation of the spreadsheet. I wrote a ColdFusion page that used the Technorati API to get the Technorati information about each blog aggregated by OraNA.info.

Now that I have it automated, I will try to publish an updated list on a regular basis, highlighting the changes in authority for each blog, up, down or unchanged. The list includes ALL the blogs aggregated by OraNA.info, even the ones that have no Technorati information.

As a reminder, the Technorati “authority” is the number of blogs (not links) linking to a blog in the last six months. The Technorati Rank is calculated based on how far you are from the top. The blog with the hightest Technorati Authority is the #1 ranked blog. The smaller your Technorati Rank, the closer you are to the top.

The above list has been automatically generated by calling the Technorati BlogInfo Query for each blog URL. The call was made using an HTTP GET to http://api.technorati.com/bloginfo?key=[apikey]&url=[blog url].

If your blog has a low authority and if you care about boosting your authority ranking you may want to write posts that are interesting to other bloggers (not just to you) so they’ll link to you. I have found the following FAQs helpful in understanding how to have Technorati index your blog:

  1. How do I get indexed? or better indexed?
  2. My posts are not indexed and my post tags aren’t either. What can I do?
  3. Links from other blogs not showing up in search?
10 Comments | Filed in ColdFusion, Oracle | Tags:


Running on a Virtual Private Server and a Couple of Pictures

If you are one of the lucky people who was greeted by the following dreaded error page when you visited my blog, OraQA.com or OraNA.info in the past few weeks, I have good news for you (and me). Obviously, the shared hosting account that I had with BlueHost.com could not handle the load of three websites (my fourth domain oradot.com is forwarded to my Tumblr blog). I have not had any issues with BlueHost until recently when my account was “exceeding its CPU quota” several times a week. This was not good. I had to do something.

Account Exceeded

Sean Corfield recently wrote about his move from a shared hosting account to a Virtual Private Server (VPS) at HostMySite.com. So, I decided to do the same. I completed the move of the three domains from BlueHost to a Linux VPS on HostMySite last weekend. Like Sean, I am very impressed with the excellent support at HostMySite and so far the sites are in a very good health.

On another personal note, I took Thursday and Friday off to spend some time with my family. The weather in the Portland (Oregon) area has been warm and sunny for the last few days. On Friday, we toured a couple of places a few miles east of Portland. Here are a couple of pictures:

013

This is me holding my 9 month old daughter Julie

028

… and with my 6 year old son George

Can you guess the places where these pictures were taken? Here is another hint from my car’s GPS, the red arrow represents the car:

011

Comments Off | Filed in Personal, WordPress | Tags: ,


Have You Heard of Tumblelogs?

I’m not a big fan of blogrolls. A blogroll is a collection of links to other blogs. I believe what’s more interesting and useful is to have a a collection of links to other blog posts and web pages, or a linkblog. Some bloggers use the shared items in Google Reader as their linkblog. Robert Scoble uses this approach for his famous linkblog.

But even a linkblog can be limiting. What if you want to blog not only links, but also photos, quotes, dialogues and video, quickly and easily. Well, there is a special type of blog, called tumblelog, that does exactly that. Unlike blogs, there is no commenting on tumblelogs.

I like this tumblelog idea. So I set up one, Eddie Awad Randomized (feed). I’ll be posting interesting, educational, useful or just plain fun tumbles, Oracle and non-Oracle related. I also set it up to to automatically import my shared items in Google Reader. But unlike Google Reader’s shared items, I can search my tumblelog using any known blog search service.

Eddie Awad Randomized is powered by tumblr, a free and extremely easy online tool for creating tumblelogs.

EddieAwadRandomized

Note: I’m writing this blog post using Windows Live Writer, I like it. 

5 Comments | Filed in Links, Oracle, Technology | Tags:


Infinite Scrolling at OraNA.info and New Oracle Bloggers Group

Aggregated by OraNA OraNA.info, the unofficial Oracle news and blogs aggregator, has a new look and cool new features:

  • OraNA now runs on WordPress, which means that, unlike the older version, OraNA is no more limited to showing only the latest 20 posts. It is still a River of News style aggregator, but the river has become as long as the Nile.

  • OraNA now supports infinite scrolling. You scroll and scroll and scroll infinitely. Basically, as soon as you get near the bottom of the page it automatically adds more posts (AJAX is so cool). No more “Next Page” and “Previous Page”, it’s virtually endless. Quick tip: use the space bar to scroll down and shift+space bar to scroll up.

  • OraNA has a cleaner look. Posts are clearly separated and authors are displayed below post titles.

  • OraNA now aggregates more Oracle blogs than ever, over 266 Oracle employee and non-employee blogs as of today.

If your blog is aggregated by OraNA.info you may:

  • add the “Aggregate by OraNA” button to your blog. Just copy the following HTML Code and paste it to your blog’s sidebar:

Google Groups
Subscribe to OraBloggers
Email:

The OraBloggers group is not really new. It was created back in January 2006 and currently has a few members. Maybe it’s time to revive it and use it as a public place to discuss the current affairs in the Oracle blogosphere or each others’ posts as Paul suggests, or whatever you like, you decide.

6 Comments | Filed in Oracle, WordPress | Tags: , , ,


Top Oracle Blogs Ranked by Technorati Authority

Recently, Technorati introduced the Technorati Authority. It is the number of blogs (not links) linking to a website in the last six months. The higher the number, the more Technorati Authority the blog has.

In addition to Authority, there is also the Technorati Rank. It is calculated based on how far you are from the top. The blog with the hightest Technorati Authority is the #1 ranked blog. The smaller your Technorati Rank, the closer you are to the top.

So, who is currently the most authoritative blogger in the Oracle blogosphere? To answer this question, which somehow I had a feeling to who that would be, I have compiled a list of blogs that are aggregated by OraNA.info and that have a Technorati Authority of 2 or more. I then sorted the list by Technorati Authority in a descending order.

Obviously, blogs that are not aggregated by OraNA.info or that do not have an authority yet are not included in the list. Without further ado, here is the list: Continue reading…

24 Comments | Filed in Oracle | Tags: ,


Find Out If Your Blog Is Usable, Accessible or Simply Good

Tom Johnson has a list of twenty usability tips for your blog. Does your blog follow these principles that distinguish good blogs from poor ones? I believe that mine does. Here is why. My blog:

  • Has a tag line that clearly identifies the topic of the blog: News, views, tips and tricks on Oracle, ColdFusion and other fun stuff. Although, the focus has been mostly on Oracle.

  • Allows comments and does not require readers to register before commenting. At one time, I turned comment registration on. That was before I discovered this WordPress plugin: Math Comment Spam Protection.

  • Provides the option to be notified of follow-up comments via e-mail and RSS, thanks to Subscribe to Comments WordPress plugin.

  • Makes it easy to subscribe to the blog’s feed by placing an orange RSS button in a highly visible location (the menu bar at the top). Moreover, the Subscribe Me WordPress plugin adds site subscription links to popular RSS readers, and Feedburner Feed Replacement plugin forwards all feed traffic to Feedburner.

  • Offers an e-mail subscription to the latest posts.

  • Has an About page to tell the reader who I am.

  • Has a Contact page to give the reader the option to contact me offline, thanks to the WP Contact Form III plugin for WordPress.

  • Includes visuals (graphs, charts, photos, blockquotes, videos…) in blog posts. Here is an example.

  • Has mostly short blog posts. Unless they are extremely useful or interesting, I do not have time to read long posts on other blogs and I figure other people do not have the time to read my long posts either.

  • Has subheadings for long posts. Here is an example.

  • Is generous in linking to other blogs and websites. Here is an example.

  • Clearly describes posts’ content in the posts’ titles. You judge for yourself.

  • Archives posts by category.

  • Has a search feature and with the Google Sitemap Generator plugin for WordPress, Google visits my blog very frequently, quickly making it searchable on the net as well.

  • Has a list of related posts beneath each post, thanks to these WordPress plugins: Ultimate Tag Warrior and ST Add Related Posts to Feed.

  • Does not have confidential, overly-emotional, rude, or unprofessional posts. I’m not an emotional guy anyway and I’m nice overall.

  • Has a “top posts” section in the sidebar (or bottombar) thanks to WP-PostViews WordPress plugin.

  • Has a “recent posts” section in the sidebar (or bottombar).

  • Has a “top commentators” section in the sidebar (or bottombar), thanks to Show Top Commentators WordPress plugin.

  • Has a sitemap or index page, thanks to Sitemap Generator WordPress plugin.

  • Has a URL that nearly matches the title of the blog. The URL of my blog is awads.net/wp, the title of my blog is Eddie Awad’s blog. Close enough.

  • Is refreshed with new posts on a regular basis. I used to post at least 4 times a week, but with two kids, a full time job and project deadlines looming, I try to post at least once a week on average.

And here are some additional usability measures I think are also important and worth mentioning:

  • Has a white background color. To me, It’s just more readable having dark text on light background.

  • Makes it easy to share posts Web 2.0 style, thanks to the Share This WordPress plugin and FeedFlare.

  • Publishes a full-text feed instead of a truncated one. Here is why I switched to a full-text feed and here are more thoughts about this subject.

  • Has useful and interesting content (at least to me). After all, what’s a blog without good content?

5 Comments | Filed in Tips, WordPress | Tags: , ,


What Is OraNA.info?

Aggregated by OraNA Please update your bookmarks and links. OraNA, the largest Oracle news and blogs aggregator, has a new home: OraNA.info. It also has a new look. The OraNA RSS feed, however, is still the same.

If your blog is aggregated by OraNA, you can grab the HTML code from here to easily place the “Aggregated by OraNA.info” button on your blog.

Comments Off | Filed in Oracle | Tags: ,


Bye Bye 2006, Welcome 2007

As we say bye bye to 2006, I would like to thank you, my dear reader, for reading my blog and spending part of your time leaving comments and feedback.

For me, the highlights of 2006 were:

I would also like to share with you some statistics from the past 12 months (as per Google Analytics and Feedburner):

Top 10 pages

The following pages received the most hits during 2006:

  1. Home page
  2. Format your SQL the easy way
  3. Oracle SQLPlus
  4. Saving/Downloading files to/from Oracle using ColdFusion
  5. Cool SQL function: EXTRACT
  6. Back to basics: outer joins
  7. NVL, NVL2 or COALESCE?
  8. HTTP POST from inside Oracle
  9. PRAGMAtism in Oracle PL/SQL
  10. Oracle Trace Analyzer is TKPROF on Steroids

content.png

Top 10 browsers

Internet Explorer was the most popular followed by Firefox:

browsers.png

Top 10 countries

Almost half of the traffic originated from the US and the UK:

country.png

Top referrers

Google was responsible for more than 65% of the traffic, and 10% of the visits were direct, i.e. from bookmarks or directly typing the blog URL:

visitsource.png

The number of subscribers to the blog feed has been steadily growing:

fb.png
fbstats.png

In 2007 I will continue to blog about whatever I find interesting and useful to both you and me.

Here on the west coast of the United States, we celebrate new year later than the rest of the world. At the time of this writing, there is almost 12 hours till we welcome the arrival of 2007.

My next post will be next year :)

Happy New Year!

Comments Off | Filed in ColdFusion, Google, Oracle, WordPress | Tags: ,