unimportant

excel 2010 displays garbage when opening xls documents from the web

by .pQd
while migrating few dozens of users to new desktops with the new office 2010 i’ve encountered a problem: when users open xls [saved in the excel 97-2003 format] directly from the web browser and allow editing excel displays garbage. amount of garbage depends but sometimes it makes the spreadsheet completely unusable. things get even worse ... Read More

gtd

by .pQd
i like gtd, i’ve heard first time about the idea around 2006. since then i use some tiny-little-miniature form of it on daily basis; it boils down to writing things down, using reminders, tasks and todo lists. in other words – having OCD / being anal. i still manage to miss things, but in general ... Read More

[pl] petelicki

by .pQd
dobre podsumowanie serji brutalnych samobojstw tutaj. a lemingi w najlepsze griluja cieszac sie co tym co im mainstream podrzuci. ciekawe komentarze na stronie michalkiewicza. + dla przeciwwagi – confirmation bias aka efekt potwierdzenia.

extracting single database from a [large] mysqldump

by .pQd
extracting the whole database: sed -n '/^-- Current Database: `databaseName`/,/^-- Current Database: `/p' /path/to/the/fill/dump.sql > output.sql single table: sed -n '/^CREATE TABLE `tableName`/,/^\-\- Table structure for table /p' /path/to/the/fill/dump.sql > output.sql [via this blog]

new sphinx, new connector/j headaches

by .pQd
sphinx 2.0.3 is out; and as new drama of getting mysql’s connector/j begins. i did not figure out [yet] any way of making both work using the latest 5.1.18 connector, but at least i’ve managed to convince one that i use now [ 5.1.15 ] to work with sphinx. what works: mysql-connector-java-5.1.13-bin.jar but.. only if ... Read More

excluding some mysql queries from the slow query log

by .pQd
i keep close eye on the mysql-slow.log log of queries that take more than 1s to execute. but at the same time i know about few house-keeping queries that are executed few times per day that by design take longer to execute [eg table checksums]. i don’t want those queries to ‘pollute’ the slow query ... Read More

ilo

by .pQd
i take care of one HP server with ILO remote access card. but recently i started having problems with using web applet to connect to it.