Using... & How To's

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

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

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

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

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.

SQL
Jamie Whitehorn

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. Work

Tableau
Jamie Whitehorn

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 a

SQL
Jamie Whitehorn

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

Using... & How To's
Jamie Whitehorn