-
Convert Excel file with hyperlinks to CSV
It seems the venerable file format CSV (Character/Comma-separated values) never goes out of style. According to CSV wikipedia page, IBM Fortran started supporting this format in 1967, before many of us were born. CSV has been with us, through thick and thin, silently but steadfastly, ready to spring into action when duty calls. For sure, […]
-
Using rsync to backup remote n00 files
I had trouble rsync remote Linux 600 files (rw——-) today. I knew that I came across this issue before but couldn’t remember how I resolved it. Therefore I had to waste time looking for and verifying a solution. Hence this blog post. This is the problem I had earlier: [code language=”bash”] rsync -zr userA@remoteServer:/var/www/website/ /home/user/Documents/webSiteBackup/website/www/ […]
-
Grant full permission to Windows folders and files
For a Windows application or service, it is often necessary for either the user or service startup account to have full control to its folders and files. In most cases, this is transparent to the user. It is generally being taken care of by various delegation mechanisms behind the scene. However, this can be a […]
-
sed tricks
I helped a charity to rebuild a MySQL server and to restore a database with a lot of data of longblob type in the last two days. Fortunately there was a dump backup file for the database in question. However, tables with longblob column(s) were not defined with “ROW_FORMAT=COMPRESSED”. I’d like to restore that database […]
-
Script to generate index rebuild with PAGE compression
For BI data warehouse databases, since the data does not change much and they typically require a lot of space, it makes a lot of sense to compress the indexes to save space. I came across some BI databases whose indexes were created without compression. We are in the process of migrating those databases to […]