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: 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

Hacking a Davis Wireless Vantage Pro 2 Weather Station: Part 2 - the basic hardware

Part 2 deals with the basic hardware you need to hack the Davis VP2 ISS by intercepting the radio signals and shows the basic premise works.

Maker
Jamie Whitehorn

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.

SQL
Jamie Whitehorn

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.

SQL
Jamie Whitehorn

Hacking a Davis Wireless Vantage Pro 2 Weather Station: Part 1 - the theory

Part 1 discusses the Davis Vantage Pro 2 Weather sStation and the theory of a possible way to hack it and enhance its functionality.

Maker
Jamie Whitehorn

Diet Progress Report - February 2018

Lost another 4.4kg this month, making 10.4kg lost in total. Worth spending another month feeling vaguely hungry for :-)

Health
Jamie Whitehorn