A global tag that covers all the How-To posts in the blog :)
Explains how to use SQL to check if a table already exists. Very useful to check prior to dropping a table, or for volatile tables if you re-run SQL.
As a data exploration tool, Tableau is second to none, but sometimes the SQL it generates to access SQL databases is just eye watering. Work
This one came about because a set of data I was dealing with had UK postcodes in it. The data came in from a whole variety of sources, and a
One of the big problems I have with Windows is when you shut it down it automatically installs any outstanding updates. On a normal day this
OK, this one is fairly basic for anyone who regularly uses SQL, but it's a neat trick if you're not familiar with it. Normally when you crea
If your reading a lot of records from a database and you need to find the first or last record in a sequence, you can do this in MS SQL by u
In this blog you'll find a whole series of posts that come under the collective heading of Using whatever. Where whatever might be Excel, or