Ranking the rows
I was asked a few days to write a SQL that would retrieve the one but latest row. Take as an example a few rows below: we have a several…
I was asked a few days to write a SQL that would retrieve the one but latest row. Take as an example a few rows below: we have a several…
SQLite is the smallest database server we know. The engine itsself is about 500 KB – considerably less than other engines. It can be downloaded from http://www.sqlite.org/ . Once downloaded,…
Cookies are small items that can be written on the hard disk of a client computer. In Google Chrome, these cookies can be found in a binary file. I found…
Today, I tried to link a ODBC compliant database to a SAS programme. SAS is a programme, much like Perl, that allows data to be read, transformed and written back…
I now work with a financial institute where they took the decision NOT to use date formats for data-values. This meant that they use 20110310 to indicate the 10th March…
In some environments, the possibility to create an ODBC link is prohibited. Due to misunderstood security issues, the creation of an ODBC link is not permitted. But is might be…
I am subscribed to a ADSL provider who also provides Email services. Hence, I could try to send some mail from the command line on my laptop. As a first…
I am subscribed to several blogs. One such blog is a blog from Dylan Jones that is maintained from the “Data Quality Pro community”. From this blog I got the…
Previous pages can be found here I had a site previously. This was basically a standard HTML based site to which comments were added over time. Above link brings you…
Recently I bought a NAS server. Just to store some files, photos and one or two movies that came across. To be honest, I did not realise how much software…