Google pages will be migrating to Google sites :(

Google pages is migrating to Google sites and Google sites is forbidden at Türkiye, since I maintained for years all my SQL scripts mentioned here at my Google pages domain and these files are not a part of the planned migration this migration will cause lots of trouble for me and of course for the readers of this blog unfortunately.

To my taste blogs must be short and to the point, so I always proffered to link my long SQL scripts inside my posts to a text file uploaded at my Google pages, this way also the text file is opened inside browser and the file is not downloaded(you may check out for the behavior on this example post here).

I have hundreds of files linked to hundreds of blog posts, so this file maintainance will take lots of time. I will try to fix first the all time most read ten posts referenced from WordPress stats and as a workaround I will upload the text SQL files as word documents to wordpress media library(you may check out for an example migrated post here). I hope someone may advise a better alternative soon :)

I am busy with lots of reporting projects lately, most of them related to the 3g introduction in my country and CRM application migration at my company. This week I will be attending to Oracle 11g Data Warehousing Masterclass with Mark Rittman at Istanbul and at last I will have two days time to get away from the work and enjoy this seminar. And after 4 weeks I will be a family database guy now; I am getting married at the end of this July and I am very excited that for the first time in my 13 years career I will be having my first two consecutive weeks holiday as my honeymoon :)

ps: I was thinking what if apex.oracle.com or wordpress kind of free services also migrates with some constraints, too boring even to imagine, free services and their risks are like roses and their thorns.

EXASOL?

Today I was looking at the recent TPC-H benchmark results, I saw a vendor named EXASOL which dominated the benchmark results, what kind of a performance is this? They have their own operating system and they are listed as clustered, who are these guys? :)

Once I wrote on Oracle vs. SQL Server – a never ending story and advised on checking the other open source options as well. Today global economic crisis is upon all of us so I observe that any kind of financial decision is stressed as never before. EXASOL seems to be an interesting case study for our reporting database needs maybe, needs careful testing of course parallel to each individuals’ needs.

Really congratulations to EXASOL because of their engineering/creativity against giants like Oracle and Microsoft.

This is a team of miracles, and now 70 million are waiting for Germany :)

I have no hearth to say anything for this kind of a game, you must see especially the last 5 minutes yourself, unbelievable..

Turkey triumph in Vienna shoot-out

The InfoTech 100: Oracle is 22nd and Turkcell is 25th

For the fifth consecutive time my company is in the list at 2007. Oracle is 22nd and Turkcell is 25th, above technology giants like HP, LG, Intel.

I am very lucky to be a part of Turkcell, one of the largest Oracle customer all over the world :)

http://tinyurl.com/46mr7m

I am tagged also, so here are 8 things about me :)

This week I am preparing the Log Buffer #79 and it is very busy in deed, I am trying to apply the archives and hope to catch up tonight with the recovery :)

This tagging thing is this week’s hot issue, and it reached me as well by Rob van Wijk, thank you Rob :) Like Rob I’ll make an exception for this post since I have my non-Oracle blog at blogspot and I guess this will be my first non-Oracle post in my wordpress Oracle blogging career. And here we go;

1) I was born in February 1977 and have one younger brother, who is a microsoft and macromedia trainer(funny ha:) and doing very well, I am very proud of him, soon he will a Mvp I guess :)

2) I love to(and try to) play the guitar, rock’n'roll was always my escape exit from life, and I am a 3* Cmas diver. Once after the university I really thought to leave this world and pay my bills with my hobby, then Oracle turned out to be my hobby, ironically :)

3) I love Fenerbahce! This comes from my parents, I (nearly:)die for my team, no other words are needed I guess, watch our game at the Champions League, I will be there :)

4) I was born and grown in Fethiye, a beautiful Mediterranean village, where I think to go back and die happily with my grant children :) My family owns a small hotel there, so I am proudly announce here that any Oracle blogger will have %25(good one really:) discount if they will contact me if they want to visit my hometown, Fethiye :)

5) Recently I have been hit by a truck and my car was nearly destroyed, I was so lucky to get out without any harm. Happy to be still alive, lots of things to do :)

6) I am not married yet, but my grand parents are making a lot of pressure on me for a baby :)

7) I love traveling, I have been to New York, Orlando, Miami, San Francisco, Los Angles, London, Paris, Berlin, Cairo, Red Sea and some of the best places of my country, Türkiye. I want to travel to Asia and Australia soon and I also believe that I live in the best city of the world, İstanbul :)

8) This will be an all time confession; I was once an Informix lover and resisted to migrate to Oracle and even prepared a presentation at that time to my company’s management and tried to convince them not to migrate :) Also this year I am very interested with Postgre SQL, since it is open source and very similar to Oracle, I think it is a good start point to learn the internal stuff deeper.

And now it’s my turn to tag, as far as I followed these are my blogger friends who are still not tagged, tadaaaaa :)

1. Coskans Approach to Oracle http://coskan.wordpress.com/
2. Alejandro Vargas’ Blog http://blogs.oracle.com/AlejandroVargas/
3. Jeremy Schneider’s Blog http://www.ardentperf.com/category/technical
4. Software Engineer Thoughts by Pawel Barut http://pbarut.blogspot.com/
5. Patrick Wolf’s Blog http://inside-apex.blogspot.com
6. OraStory by Dominic Brooks http://orastory.wordpress.com/
7. Databasesystems info by Kubilay Çilkara http://kubilaykara.wordpress.com
8. Arul’s Oracle Zone http://oraclezone.wordpress.com/

See you tomorrow with the Log Buffer, I will also have little surprises ;)

ps : Howard Roger’s did it again; http://www.dizwell.net/prod/archives/57 world needs Howard style people more than ever today, don’t walk and question the path everyone walks :)

Group Metalink is looking for members

If you are living in İstanbul, love to rock’n'roll and Oracle chat then check this proposal out :) Join group Metalink

Oracle Star Wars

I have written a post earlier about the expert categories in Oracle community I experienced. I didn’t know I was playing with fire :) I don’t know the historical reasons behind the below war I will mention but I can only imagine why someone like Mr.Lewis or Mr.Kyte would go after each post of someone like Mr.Burleson.

Mr.Burleson is a very well known Oracle expert for years and every single Oracle newbie who uses google during their researches instead of metalink or docs, meets with his articles immediately :) As a result someone who has this much power must be very careful about what he suggests to the community, if not we face another example of “Question Authority.”

On the other hand Mr. Lewis has always been like a scientist, when you read his books, articles you always feel like you are in a laboratory. Mr.Lewis kind of people never mislead the starters with a fear that it is too much complicated to write on, you never read something like “.. immediately rebuild your indexes when they have X amount of deleted leaves ..”

So there can not be any excuse like “since they are newbie they do not have the opportunity to learn the rights”, at least above word kills the wonder feeling and do not let others to try with a test case and see some outcomes for their specific conditions.

At forums alanm From: Shropshire, U.K. commented “It makes the forum something less than it should be.” and some anonym user user584951(maybe he is also someone important:) warned two community leader and the war seems to pause for sometime. Know I leave you with the war series I found :)

Burleson – http://forums.oracle.com/forums/profile.jspa?userID=105473
http://www.dba-oracle.com/t_biased_test_cases.htm

Lewis – http://forums.oracle.com/forums/profile.jspa?userID=554708
http://jonathanlewis.wordpress.com/2007/07/14/analysing-statspack-6/

Part I – http://forums.oracle.com/forums/thread.jspa?threadID=527201&start=0&tstart=0

Part II – http://forums.oracle.com/forums/thread.jspa?threadID=527201&start=15&tstart=0

Turkcell R&D – Software Development Internship 2007 started

I have been working on my company’s summer internship program for the last five years; http://tonguc.oracleturk.org/index.php?s=turkcell+staj

Every year it starts with choosing the right people and matching them with the right team, we work on small assignments with candidates; http://tonguc.wordpress.com/2006/12/25/hello-world/

With the chosen ones we start for a three months internship and support them with an education program; http://apex.oracle.com/pls/otn/f?p=20898:1:332182477501552

This year Bilal is writing his experiences, this is unique since anyone will have a chance to follow the program with his chronicles;
http://www.bhatipoglu.com/entry.asp?id=6

It is always a great experience for me to study with young talented software engineers, I am sure someday these guys will have important contributions to this community :)

Is Tonguc still alive – http://tonguc.wordpress.com’s first 6 months and over 50,000 hits :)

I am so sad for the last two months, I have been given a critical management assignment for my company, couldn’t say the magic word -NO- and this absolute waste of time duty consumed all of my valuable time. Couldn’t read enough and write the posts I planned. I hope this will change within 15 days..

I started this blog with the new year 2007, by the first six months wordpress says I crossed 50,000 hits :) Up to now the most read entries were -

Introduction to Oracle Trace Utulity and Understanding The Fundamental Performance Equation
Oracle 10g Flashback Versions Query, Drop Table and Recyclebin Management
Oracle Best Practices Part 1
Oracle SQL Extentions Part 1
Oracle Built-in Functions – Part 1

I hope to be much more productive and continue my posts within the categories I mentioned at http://tonguc.yilmaz.googlepages.com/

And also I have to mention that I was surprised when my latest post didn’t get the attention I expected, so what do you think about it? :)

A small sql puzzle

One of my friends asked me this question, it is a small sql puzzle, we have a table in the below organization;

create table tr_football_league
( club_id number,
club_name varchar2(32),
championship_year number(4), — only the year
year_100th_champion number(1) — 0 false, 1 true
) ;

– the data to be inserted is here
insert into tr_football_league (1, ‘FENERBAHCE’, 2007, 1) ;
…

so the wanted sql must return which club was champion on its 100th year and also owns the most championship count in the data mentioned above. the answer is so easy, it is my precious club FENERBAHCE, but what do you think about the sql?

This love will never end :)