QueryCSV enables you to load CSV files and manipulate using SQL queries then export it to CSV file ⌘ Read more…

Testing @!(ref “weewiki_sql” “page markers” “iterate_over_values”)!@.

sql2slack - send sql results periodically to slack ⌘ https://github.com/alash3al/sql2slack

While certainly not a solution to everything, I find I’m using temporary SQLITE database a bunch to solve problems with a few lines of sql and less then 50 lines of code (to insert data into the SQLITE DB) instead of several hundred of lines of code and a bunch of arrays.

Fun with data! The complete roster twtxt database can be downloaded at https://roster.twtxt.org/twtxt_20160405.sql.gz

Modern SQL in PostgreSQL by @MarkusWinand http://t.co/odkPaoSnh2 via @SlideShare

Thanks to the Slammer, Slammed
Yes, just like a lot of people around, we got “slammed at work.” There were several hundred of machines on Campus, I presumed, but the five we got compromised are the one’s that bothered me the most.

Out of the five, two were servers, our servers, my servers. A brand new SQL server, just a week old, more or less, was missing the hot fix. Another older one, under the control of somebody else, but still within my College was missing it too. It could have been wors … ⌘ Read more