Skip to content




Clean Debian from bad things

Last time my server bases on Debian was several times attacked by bad guys bia linnuux viruses on malware. To fight with them there's an utility Linux Malware Detect (LMD). So I copypaste some info not to search it but just open the page. (read more...)

Visual Studio shortcut keys

I found a great collection of Visual Studio shortcuts. While coding I often comment some lines of code.  Using shortcuts it's even more easy. It's not a common combination - select lines to comment and press Ctrl + K then Ctrl + C, to uncomment  - Ctrl + K then Ctrl + U. (read more...)

SELECT from table WHERE items IN (@variable)

You need to make query like "SELECT * from tbl WHERE items IN ('item1', 'item2', 'item3', 'item4')" and you want to send items to IN clause as variable. It’s nice when, for example, you want to execute Stored procedure or, as in example below, use INSERT ... SELECT construction. Then you need to make a fint with quotes. (read more...)