It Sounds Like...

Imagine a world where everyone had the spelling capability of a High School English teacher... Now snap out of it, because that's slightly delusional. Everybody makes the odd spelling mistake, especially when it comes to names, luckily there's a way in SQL to get around this...

Google Doodles Hacked... Well kind of...

When the Google Doodles were initially released during the Olympics I played every single game up to the point of absolute boredom. Then yesterday I was a bit bored and started going on a random Google spree and came across the games again and once again I decided to play them, then I thought... Why not try to automate this...

How to use CTE's

What is a CTE?

Basically a common table expression is a table that gets created and only lasts for the duration of that query. Once the query is executed, the table doesn't exist anymore. It can be self referenced and can be referenced multiple times in the same query.

Copy and paste programming

Copy and paste programming by Boipelo Rathebe

A couple a of weeks ago I had a very interesting chat with a java software developer friend of mine, who had just recently started the job and us just having a friendly chat around how he’s finding it, and to my surprise, or not, because  I am quite convinced that we all have found ourselves doing “it”. He tells me it is very hectic and this as a result has taken his friendship with google to a whole new level, so basically when he gets stuck he’ll just do an internet search on what he’s struggling with and hopefully get a suitable solution.

Database vs Data Warehouse

What is a data warehouse?

A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis. Often designed as OLAP (On-Line Analytical Processing) systems, these databases contain read-only data that can be queried and analysed far more efficiently as compared to your regular OLTP (On-Line Transaction Processing) application databases. In this sense an OLAP system is designed to be read-optimized.

Zoom Zoom...

Here is an awesome little JQuery hack if you ever come across the problem of displaying multiple images on a single page without having to make them all thumbnail sized and ruining the entire visual experience of the page.

Keeping Regular with Regex

Keeping Regular with Regex

The first time I encountered Regex (Regular Expressions), I just shrugged it off as some overly complicated way of doing easy tasks such as simple control content validation. I did not fully understand the powerful capabilities, or what it could enable me to do.