A global tag that covers all the How-To posts in the blog :)
This SQL lets you find all the tables in a particular database or your user area (your personal database) in Teradata, or table names that match a pattern.
How to compare two timestamps in SQL and express the result in hours.
How to count unique values in a table or other data range in Excel. Includes a quick method for numbers, and a slower generic method that works with text.
How to find the number of AMPs and Nodes in a Teradata installation using a simple SQL query.
This SQL creates a series of commands that can be used to DROP (aka delete) all the TABLES that match a pattern or username.
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