Category Archives: Thesis

See in a graph your SQL Server activity


SQL Check is a free tool of Idera that allows you see what is happening in your database, monitoring around 20 metrics of performance of SQL Server.

Idera has other paid version with more features.

Graph legend:






This blog has a new domain

Hi everyone,

This mini post is to tell that this blog has a new domain which is shorter than previous. The new address for this blog is


Álvaro Brange

pickleDB, a key/value store for python


PickleDB logo

PickleDB is a simple store of kind key/value that was written by Harrison Erd. I made simple test to storing:

  • Number,
  • Text,
  • Dictionaries
and  it works fine for a not huge quantity of keys, may be, less or around 1.000.000, depending you machine configuration (In my test, I used a Intel Core i7 2600CPU@3.40 gHZ, 4 GB Ram computer with Python over Windows 7 Professinoal).
  • Very easy to use. I got it working in few minutes
  • Easy integrate with your python code
  • Has a limited capacity to work with large dataset, due that works with it in memory and then dump it to a file.

If you need work with more data, I recommend to play with other, like as Riak, Couchbase, Redis or OrientDB. For a large list of nosql database, go to

Example of usage (Python console):

In [19]: import pickledb
In [20]: db=pickledb.load('data.db',False)
In [25]: db.set('key1',1)
Out[25]: True
In [26]: db.get('key1')
Out[26]: 1

2011 in review

The stats helper monkeys prepared a 2011 annual report for this blog.

Here’s an excerpt:

A New York City subway train holds 1,200 people. This blog was viewed about 6,100 times in 2011. If it were a NYC subway train, it would take about 5 trips to carry that many people.

Click here to see the complete report.

Writing business letters, useful phrases

It’s a copy from

There you will find more content about it and updates.

  • Dear Mr Brown
  • Dear Ms White
  • Dear Sir
  • Dear Sirs
  • Dear Madam  
  • Dear Sir or Madam
  • Gentlemen


  • We are writing to inform you that …
    to confirm …
    to request …
    to enquire about …
  • I am contacting you for the following reason.
  • I recently read/heard about  . . . and would like to know . . .
  • Having seen your advertisement in … , I would like to …
  • I would be interested in (obtaining/receiving) …
  • I received your address from …      and would like to   …
  • I am writing to tell you about …


       Referring to
previous contact
  • Thank you for your letter of March 15 …
  • Thank you for contacting us.
  • In reply to your request …
  • Thank you for your letter regarding …
  • With reference to our telephone conversation yesterday …
  • Further to our meeting last week …
  • It was a pleasure meeting you in London last month.
  • I enjoyed having lunch with you last week in Tokyo.
  • I would just like to confirm the main points we discussed on Tuesday . . .


       Making a request
  • We would appreciate it if you would …
  • I would be grateful if you could…
  • Could you please send me . . .
  • Could you possibly tell us/let us have…
  • In addition, I would like to receive …
  • It would be helpful if you could send us …
  • I am interested in (obtaining/receiving…)
  • I would appreciate your immediate attention to this matter.
  • Please let me know what action you propose to take.


       Offering help
  • We would be happy to …
  • Would you like us to …
  • We are quite willing to …
  • Our company would be pleased to …
       Giving good news
  • We are pleased to announce that …
  • I am delighted to inform you that …
  • You will be pleased to learn that …
       Giving bad news
  • We regret to inform you that …
  • I’m afraid it would not be possible to …
  • Unfortunately we cannot/we are unable to …
  • After careful consideration we have decided (not) to …
  • I am writing to express my dissatisfaction with …
  • I am writing to complain about …
  • Please note that the goods we ordered on (date) have not yet arrived.
  • We regret to inform you that our order n°— is now considerably overdue.
  • I would like to query the transport charges which seem unusually high. 
  • We are sorry for the delay in replying …
  • I regret any inconvenience caused
  • I would like to apologize for (the delay/the inconvenience) …
  • Once again, I apologise for any inconvenience.
  • Thank you for your quotation of …
  • We are pleased to place an order with your company for …
  • We would like to cancel our order n°…    
  • Please confirm receipt of our order.
  • I am pleased to acknowledge receipt of your order n°…
  • Your order will be processed as quickly as possible.
  • It will take about (three) weeks to process your order.
  • We can guarantee delivery before …
  • Unfortunately these articles are no longer available/are out of stock.
  • Please send us your price list.
  • You will find enclosed our most recent catalogue and price list.
  • Please note that our prices are subject to change without notice.
  • We have pleasure in enclosing a detailed quotation.
  • We can make you a firm offer of …
  • Our terms of payment are as follows :
       Referring to payment
  • Our records show that we have not yet received payment of …
  • According to our records …
  • Please send payment as soon as possible.
  • You will receive a credit note for the sum of …
       Enclosing documents
  • I am enclosing …
  • Please find enclosed …
  • You will find enclosed …
       Closing remarks
  • If we can be of any further assistance, please let us know
  • If I can help in any way, please do not hesitate to contact me
  • If you require more information …
  • For further details …
  • Thank you for taking this into consideration
  • Thank you for your help.
  • We hope you are happy with this arrangement.
  • We hope you can settle this matter to our satisfaction.
       Referring to future
  • We look forward to a successful working relationship in the future
  • We would be (very) pleased to do business with your company.
  • I would be happy to have an opportunity to work with your firm.
       Referring to future
  • I look forward to seeing you next week
  • Looking forward to hearing from you
  •     ”           ”      to receiving your comments
  • I look forward to meeting you on the 15th
  • I would appreciate a reply at your earliest convenience.  
  • An early reply would be appreciated.
        Ending business letters 
  • Sincerely,          }
  • Yours sincerely, } (for all customers/clients)
  • Sincerely yours, }
  • Regards,             (for those you already know and/or
    with whom you already have a working relationship.)

Installing IPython on Mac OS X 10.6.8

If you work with python, you likely know Ipython which allow works with Python in a nice way. I’ve worked previously in ubuntu linux. Now that I need  work with this in Mac, I used the following commands to get it working.

sudo easy_install ipytho
sudo easy_install  readline

In my first attempt, I followed this post of Brin Berliner but I got an compilation error, so I changed it to my commands and it works well.

Crea y descarga animaciones de carga/espera para tus sitios o aplicaciones con Ajaxload Web Page Web Page

Cuando necesites contar con una imagen para mostrar a tus usuarios que su página web o aplicación esta realizando una operación asíncrona y deben esperar, como ocurre cuando se trabaja con aplicación Ajax, el sitio te ofrece generar varios tipos de GIF animados, pudiendo seleccionar el color de fondo, incluyendo transparente, el color de frente y el tipo de animación o ícono a utilizar.

Abstract: Create and download animated gif for ajax web sites o applications using gif animator.