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