Save an image from SQL Server to a file using SQL

Images take up a lot of space in a database, you'll want to keep images out of the database and on a disk somewhere. To get the images out of the database, you could use the following SQL script.

Read on ...

2017-01-01 23:36:31

Practical example of S-AES encryption

This is a very practical example of Simplified AES encryption. 

if you have comments, adjustments, hints, ... contact me on twitter.

Read on ...

2016-11-17 22:27:50

Book Review: the best books I've read in 2015

2015 holds a new personal record, 32 books read. This year, however, only 12 of them received 4 to 5 stars in Goodreads from me. Those are the books that I will discuss here. For all the others, you can check out my Goodreads account.

In this exact order, the best books I've read in 2015:

Crash & Burn by Lisa Gardner

The Impossible Lives of Greta Wells by Andrew Sean GreerThe Paying Guests by Sarah WatersI am Pilgrim by Terry HayesAfter Mrs Hamilton by Clare AshtonThe Night Watch by Sarah WatersTen Little Lesbians by Kate McLachlanKiss the Girl by Melissa BraydenMissing You by Harlan CobenRest Home Runaways by Clifford HendersonToo Close to Touch by Georgia Beers

Read on ...

2016-01-03 13:00:18

Book Review: the best books I've read in 2014

2014 has been a good book year for me. I've read a little over 30 books (the number I set out to read in my Goodreads challenge) and a lot of them received 4 to 5 stars. Those are the books that I will discuss here. In this exact order, the best books I've read in 2014:

Stoner by John WilliamsLife After Life by Kate AtkinsonReturn Of An Impetuous Pilot by Kate McLachlanStarting From Scratch by Georgina BeersChristmas Crush by Kate McLachlanExtremely Loud And Incredibly Close by Jonathan Safran FoerNo Second Chance by Harlan CobenMiracle Cure by Harlan CobenThe Panda Theory by Pascal GarnerThe Humans by Matt HaigThe Coma by Alex Garland96 Hours by Georgia BeersBarring Complications by Blythe Rippon

Olive Oil and White Bread by Georgia BeersMr. Penumbra's 24 Hour Bookstore by Robin Sloan

Read on ...

2014-12-30 17:07:15

CSS Selectors

Read on ...

2014-10-06 16:07:25

One Gmail account, multiple e-mail addresses

We all know the advantages of Gmail, like their 7,5GB (and still counting) of storage, numerous lab features, filters, labels, one account for all services, ... What most people don't know, though, is that when you sign up for one gmail address, you actually receive multiple e-mail addresses, all linked to that same inbox. How does that work, you might wonder?

Read on ...

2014-10-06 13:57:56

Show multiple rows in one column in SQL

I've been looking for a way to show multiple rows in one column, one cell for MS SQL Server 2000. The content of it separated by comma's.

Read on ...

2014-10-06 13:57:40

Synchronize data to FTP with WinSCP

I recently discovered WinSCP, a Free SFTP, FTP and SCP client for Windows. It has a graphical interface, but for me the most important feature is that you can easily script your way to a very fast and automated synchronization system with the software.

Read on ...

2014-10-06 13:57:10

Accessible (web app) table: a good table with a bad rep

Tables are an essential tool for visualizing data in web apps. A good reason to use a table is for displaying tabular information. An example of a good accessible table would the following.

Read on ...

2014-10-06 13:56:37