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.
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 time ⏱. It's a limited resource and we need to maximise it. The problem is I've never found a system that works for me.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.