Tuesday, July 29, 2008

help me i'm in hell

My kitchen is dirty as hell.. i swear i can hear voices that are either satan trying to tell me something, or the plumbing needs fixing.

há 12 anos

... tinha eu 16 anitos. Lembro-me que acreditava piamente que havia muito mais para lá da realidade palpavél. Do quotidiano. Do mundano. Dizia saber que a realidade não era a verdade. A verdade esconde-se sempre por trás do que conseguimos (ou queremos) acreditar, daquilo a que chamamos "a nossa realidade".

Other planes lie beyond the reach
Of normal sense and common roads
But they are no less real
Than what we see or touch or feel

Como é que eu me esqueci disso, é um misterio. Porque é que eu tive de ser recordado agora, é o destino.

Friday, July 18, 2008

The lyrics of Shortbus pt II

Is you is or is you ain't my baby
Well, the way you're acting lately, well it makes me doubt
You were still my baby, baby
But it seems like my flame in your heart, well it's just gone out

A man is a creature
That has always been strange
Just when you're sure of one
You'll find that he's gone and made a change

Is you is or is you ain't my baby
Well, maybye my baby found somebody new
Or is my baby still my baby too

Anita O'Day - Is You Is Or Is You Ain't My Baby?

Thursday, July 17, 2008

The lyrics of Shortbus pt I

I walk a tight rope
and live with a high hope
that somehow we still feel the same
through this catastrophe it's quietly telling me welcome that first word again

I don't care if the worlds upside down if you're lost or you're found
I know your feet will stay far from the ground
If you just stick around

I know the shots you call gentle
cause I could fall and break
you'll hear what they say

I read between the lines
It's just like a hate crime
And tell me the dateline today

I don't care if the worlds upside down if you're lost or you're found
I know your feet will stay far from the ground
If you just stick around

Scott Matthew - Upside Down

Friday, July 11, 2008

Things white people like

I just found out this morning that I'm a cliche. To be more precise, I'm a white guy.

Reading trough the list of things white people like I had 61 hits out of the 103 items.

Among the ones that I felt mirrored my own tastes, I would point out the following based on accuracy or just how funny their importance to _me_ is described.

# Film Festivals
# Coffee
# Diversity
# Asian Girls
# The Daily Show/Colbert Report
# Indie Music
# Apple Products
# Living by the Water
# Irony
# Vintage
# Japan
# Modern Furniture

Funnily enough.. they forgot indie cartoons.

BTW, do you know these guys?

Monday, July 07, 2008

We drink and dance and smoke and die of a stroke

... living like steamers, some sirens screamed and we started singing: nous sommes derrangés toujours par des mirages, mais ça fait réver plus, ça donne du courage! Jungle life is quite absurd if you haven’t got a knife!

Mais letras de JPS aqui

Ah well... you know...

Ich hoffe dass diese Nachricht Dich erreicht, wo immer Du auch gerade bist.

Sunday, July 06, 2008

SQL Server Performance, pt I

If your in Amsterdam, you have to look at windows.

Ok, so my career brought me back to Windows and Microsoft products. Bummer. One of my tasks recently required me to go over SQL Server 2005 Performance guidelines and Troubleshooting techniques and attending a lab of some sort where this performance guru shared some really nice tips.

It was actually very pleasant, and I want to share with you all some of the things I got from the training and if MS SQL Server is your thing, maybe you'll get some value out if this post.

So, first things first:
1 - tempdb: You can read more about it in this Technet article. The default size for this very important db is only 8 MB. Change it according to the few basic rules outlined in the link above.

2- Gathering generic performance statistics. MSSQL Tips gives a very nice overview on how and what kinds of statistics you can gather in MS SQL Server. I find this very useful to start a performance evaluation. Better yet, the Performance Dashboard add-on that can be downloaded here. It's too big and complex for this post, but if you need some pointers, ask me. Another really useful set of tools, jointly referred to as RML Utilities for SQL Server can be found here. Do some read-up on them and enjoy.

3 - I/O. This is one one the key elements in performance for just about any application. This might be a good time to introduce you to the SQL Server Best Practices
. The whitepaper on Predeployment I/O Best Practices is a must read if you don't know the basics on how to measure and improve this performance parameter.

4 - Isolation Levels. Be sure to read the Books Online on the 6 supported isolation levels in SQL Server 2005. Read uncommitted (or nolock), read committed, repeatable read, serializable, read committed snapshot and snapshot. Understand how these different levels affect concurrency.

5 - Stored Procedures. In most situations, SP's will provide better performance over queries any day. The reason for this is two-fold: The Data and Procedure caches, aka Memory Hogs R' us. A nice article I found on this can be read here.

There is so much more to say about this topic that I might consider transforming this in a series of posts. It would be just too much for a single post and there are several areas that I find would be really interesting to go over in depth, provided that I have the time to actually write something that is. :-)

Managing MS SQL Server is much more than pointing and clicking and therefore it is very easy to get it wrong. On the other hand, this is really valuable knowledge if you're considering a career as a performance engineer / consultant. Or even if you're just writing a Web App (RoR springs to mind) that you just can't figure out how to go about squeezing out every last bit of performance of, really knowing what you can do with the database layer is a definite plus.

Wednesday, July 02, 2008

Talking about the weather

Hoje foi um dia muito quente. As pessoas andavam meio loucas, a roupa pesada (e a comprida... e em alguns casos a, vá, decente) ficou em casa... E lembrei-me de coisas quentes. O verão em Portugal, por exemplo...

A proposito, a partir de hoje não se pode fumar tabaco em recintos fechados em Amsterdão. Se fôr numa coffee shop pode-se fumar erva, mas sem misturas, claro.