Jamie Whitehorn

Jamie Whitehorn

A self proclaimed geek who loves technology, data, computers and science; but balances this by spending time with his wonderful better half and their dogs and horses in the countryside.

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.

SQL
Jamie Whitehorn

Time Management - Categories, Activities and Contexts

Time manangement is one of those things I return to from time to time. We're always being told that we need to be more efficient with our ti

Life
Jamie Whitehorn

Can I answer the question I'm asking, with the data I have?

When you look at data, one of the most important you need to consider is "Can I answer the question I'm asking, with the data I have?" ... and be prepared to be creative.

Data Science
Jamie Whitehorn

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.

SQL
Jamie Whitehorn

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.

SQL
Jamie Whitehorn

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.

SQL
Jamie Whitehorn

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.

SQL
Jamie Whitehorn

Dogs and hot houses

With hot weather looming, we have some tips on how to keep your house cool when you have dogs but don't have air-conditioning.

Dogs
Jamie Whitehorn

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.

Using... & How To's
Jamie Whitehorn