TIOBE Programming Community Index for July 2009

PL/SQL in 12th (was 13th in July 2008) in the TIOBE programming community index

Mosquito - Loco Loco

Aqui fica a letra da música que o meu filho (quase a fazer dois anos) quer sempre ouvir no carro.

Is NVL really slower?

I recently found this tip.

Small "abstract": the use of a verbose to compare values including null values is faster than the use of nvl, or even coalesce. An NVL is must slower than the other two options!

I wanted to try it in 11g (Oracle Database 11g Release 11.1.0.7.0 - 64bit Production)
I show here the code of that article but cut-paste friendly :-) (So you can try it by yourself)

Os Velhotes (Statler e waldorf)

Nos Marretas os Velhotes eram os que tinham as melhores piadas.

Aqui fica uma selecção.

Em inglês sem legendas (desculpem lá)


Statler: That was wonderful!
Waldorf: Bravo!
Statler: I loved it!
Waldorf: Ah, it was great!
Statler: Well, it was pretty good.
Waldorf: Well, it wasn't bad...
Statler: Uh, there were parts of it that weren't very good though.
Waldorf: It could have been a lot better.
Statler: I didn't really like it.
Waldorf: It was pretty terrible.
Statler: It was bad.
Waldorf: It was awful!
Statler: It was terrible!
Waldorf: Take 'em away!
Statler: Bah, boo!
Waldorf: Boo!

O Urso da Casa Azul

Foi mesmo um prazer
até uma outra vez
o tempo já passou
com tanta rapidez

Adeus, adeus amigos meus
Nós temos de partir
mas ouve bem como ninguém
porque em breve havemos de voltar
havemos de voltar

Nós adoramos ter-te aqui
Mas temos de ir embora
já está na hora
é bom saber que nos queres ver
nós voltamos para estar junto como agora
voltamos sem demora

Adeus, adeus amigos meus (adeus)
Nós temos de partir
O urso, a lua e a casa azul
e em breve nós havemos de voltar
havemos de voltar
havemos de voltar

Quotes for today

"Measuring programming progress by lines of code is like measuring aircraft building progress by weight." - Bill Gates

"If debugging is the process of removing software bugs, then programming must be the process of putting them in."

"Remember that there is no code faster than no code."
-- Taligent's Guide to Designing Programs

"Computer Science is the only discipline in which we view adding a new wing to a building as being maintenance."
-- Jim Horning

Programmers hell!

First "A Song by programmers, for programmers": "Every Build your make" from people at Oracle.


I really like the comment one guy wrote at youtube for this video:" the project requirements change just in the meanwhile he's talking : "i have 3 things for you: pitch, tempo, dynamics and interpretation!" I'm crystal clear about this"

As a friend of mine (S.R.) told me the other day:

""Walking on water and developing software from a specification are easy if both are frozen" !!!" –Edward V. Berard
:-)

I think this next video presents that very nicely :-)


And now some others songs from a programmer (Microsoft I think) ...
This first is another version from the previous one


This one is my favorite of these: "I don't want to blog it"
"(...)and your code's so complex
that the changes of us fixing it is ...never
(...)man your code sucks(...)"


I love this "love" song


Some others...


"Still Haven't Found the Bug"

Best Practices PL/SQL (2)

Some time ago (maybe a little to long) I wrote an blog entry about best practices in PL/SQL. I stared then some blog entries that I never finish writing so now I will make then public even unfinished.

One of the topics I mention in that first best practices entry was coding standards and naming conventions. Steven Feuerstein wrote recently an article presenting his ideas about that an updated and "not all-over the place" format.

I will talk here about the rules that he mention (june 2009) I follow and the ones I have trouble with.
I will number the rules according to the other they appear the May 27 2009 version
(SF :-) P for principles, G for general guidelines, N for naming)

Hacker consegue informação confidencial da Twitter

Fonte: http://apnews1.iwon.com/article/20090716/D99F79200.html

Um hacker usando o ponto mais velhinho de entrada (password de um empregado da Twitter) conseguir acesso a documentos internos da Twitter.

Com o uso de documentos online, usando serviços tipo os disponibilizados pelo Google (em vez de localizados em computadore internos à companhia), "basta" encontrar a password de gmail de um empregado para aceder aos docuemntos partilhados noutros serviços da google.

O elo mais fraco é a password...e um dos métodos é fazer-se passar por um gestor do sistema seja via telefónica ou por email.

Por isso repito o que digo sempre: "nunca diga a sua password por telefone ou envie por email, msn, etc".
Se por alguma razão, muito pouco provável, os serviços técnicos necessitarem dessa informação será sempre presencial e deverá ser pedido que seja você a introduzir a password que deve logo depois da intervenção ser alterada para uma outra completamente diferente.

Mantenham-se seguros!

Everything

Everything
Michael Buble
---

You're a falling star, you're the get away car.
You're the line in the sand when I go too far.
You're the swimming pool, on an August day.
And you're the perfect thing to say.

And you play it coy but it's kinda cute.
Ah, when you smile at me you know exactly what you do.
Baby don't pretend that you don't know it's true.
'cause you can see it when I look at you.

And in this crazy life, and through these crazy times
It's you, it's you, you make me sing.
You're every line, you're every word, you're everything.

You're a carousel, you're a wishing well,
And you light me up, when you ring my bell.
You're a mystery, you're from outer space,
You're every minute of my everyday.

And I can't believe, uh that I'm your man,
And I get to kiss you baby just because I can.
Whatever comes our way, ah we'll see it through,
And you know that's what our love can do.

And in this crazy life, and through these crazy times
It's you, it's you, you make me sing.
You're every line, you're every word, you're everything.

So, la, la, la, la, la, la, la
So, la, la, la, la, la, la, la

And in this crazy life, and through these crazy times
It's you, it's you, you make me sing.
You're every line, you're every word, you're everything.
You're every song, and I sing along.
'Cause you're my everything.
Yeah, yeah

So, la, la, la, la, la, la, la
So, la, la, la, la, la, la, la

SQL Navigator: Better Because of You!

Today I got to be in the Hall of Fame of SQL Navigator users!
http://sqlnavigator.inside.quest.com/better_because.jspa

That is due to my participation in the beta program.
I really think that the next version (6.2) will be a great version!

Ok, it need some other things (and has some bugs)...but the SQL Navigator team is on it!

Happy coding!

O Partir

O Partir

A espera sentida que te faz sofrer
A espera que espera sem ninguém saber

A espera tão dura que te faz chorar
E nesse momento pões-te a recordar

Amigos distantes que já não podes ver
Mas que o teu coração não te deixa esquecer
Que o coração não te deixa esquecer

A vida é assim
Não sabes o que vai dar
Não sabes o que vai dar

Espero por ti aqui
Neste largo caminhar
Espero por ti aqui


É um sentimento que nos unirá
E sempre no tempo permanecerá

É esta ausência que se faz sentir
Ao trilhar o caminho que temos que seguir

A espera tão dura que te faz chorar
E nesse momento pões-te a recordar

Amigos distantes que já não podes ver
Mas que o teu coração não te deixa esquecer
Que o coração não te deixa esquecer

A vida é assim
Não sabes o que vai dar
Não sabes o que vai dar

Espero por ti aqui
Neste largo caminhar
Espero por ti
Espero por ti aqui

---
Canção 9 do alinhamento abaixo

Firefox add-ons -228 error

I upgraded my Firefox to 3.5 but my prefered extension Firebug needed an update to work with this new version of Firefox.

But trying to update or download an extension from Firefox gave me a download error -228.

Even with another browser...so maybe its a server problem.

Anyone also get this error?

Meanwhile I found out that exchanging from the extension url the "https://addons.mozilla.org/en-US/firefox/addon/" by "http://ftp.mozilla.org/pub/mozilla.org/addons/" I could access the folders and install/download the extension :-)

Uma disfunsão social?

SQL optimization videos

SQL indexing explanation


Rewrite SQL queries for performance

Video: Oracle Architecture and Data Storage explanation

Oracle Architecture
(what is the Oracle DB doing when you start it and when you execute an SQL statement)


Oracle Data Storage explanation

Funny moment