Using... & How To's

A global tag that covers all the How-To posts in the blog :)

Jamie Whitehorn
Members Public

Using Teradata SQL: Finding a person's age

How to calculate a person's age correctly given a date and their date of birth in Teradata SQL.

Jamie Whitehorn
Members Public

Using Teradata SQL: Check the size of tables in a database

Some useful SQL that lets you find how much disk space your database and tables are actually using.

Jamie Whitehorn
Members Public

Using Teradata SQL: Create a reference table for human generations

Useful SQL to create a reference table of human generations like Millennial, Generation X, Baby Boomer etc with start and end dates.

Jamie Whitehorn
Members Public

Using Teradata SQL: How to find all the tables in a database or user area

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.

Jamie Whitehorn
Members Public

Using Teradata SQL: Find the difference between two timestamps and express as hours

How to compare two timestamps in SQL and express the result in hours.

Jamie Whitehorn
Members Public

Using Excel: How to count unique values

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.

Jamie Whitehorn
Members Public

Using Teradata SQL: How to find the number of AMPs and Nodes

How to find the number of AMPs and Nodes in a Teradata installation using a simple SQL query.

Jamie Whitehorn
Members Public

Using Teradata SQL: How to drop (aka delete) a lot of tables at once

This SQL creates a series of commands that can be used to DROP (aka delete) all the TABLES that match a pattern or username.

Jamie Whitehorn
Members Public

Using Teradata SQL: How to check if a table exists

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.

Jamie Whitehorn
Members Public

Using Tableau: Massive queries and slick 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. Working smart can cure that. In one the reports I generate, there are two important dates. The reporting month and the dataset extraction date. In fact

Jamie Whitehorn
Members Public

Using Teradata SQL: Validating a UK Postcode

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 as such, was not very good in quality terms. The system that the data was going to, on the other hand

Jamie Whitehorn
Members Public

Using Windows 7: How to prevent updates on shutdown

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 is just annoying, but sometimes it is essential you get the machine shutdown as quickly as possible and, by default, Windows gives you no