Powershell: Get extension of a string

Easy way to get the extension of a path or filename.

Microsoft SQL SELECT INTO multiple values

Today I came across an interesting construct in Microsoft SQL whereby you are allowed to insert multiple values into a table using a single SELECT INTO statement. Naturally there are more ways of achieving the same goal (SELECT..UNION, CREATE TABLE .. INSERT INTO) but I thought it would be interesting to post this option here …

Continue reading »

Oracle SQL Developer – Get Results in Query window

If you want the Oracle SQL Developer script results to show in a query window instead of the script window, read this article!

Bloomberg: Obtain members of index through Data License

To have Bloomberg return the ISIN codes of index members instead of the default ticker code you can follow the process described in this post.

Word: Adding a sequence number into your document

Find out how to add a numbered item all across your document and update it automatically.

Excel: select subset of string based on delimiter

Explanation on how to pull apart strings in a certain cell using Excel built-in functions only.

Download videos from Youtube and Vimeo using just Google Chrome

Find out how to download almost any streaming video from the web using just your own Google Chrome browser!

Turn off typing sound in Android

Something silly that had me baffled for a while was that in Android, even though I had the sound turned off, typing would still generate sound. The reason for this is because the keyboard sound doesn’t take it’s cue from the touch screen setting, but from the input setting itself. To turn it off, go …

Continue reading »

Remove lines from file if keyword is found

Need to filter lines from a file based on keywords in another file? Find out how to do this very quickly using DOS command line only!

Solution: Windows 7 Resume loader USB Keyboard

How to enable your USB keyboard after POST but before Windows starts

Older posts «