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.
Some useful SQL that lets you find how much disk space your database and tables are actually using.
Useful SQL to create a reference table of human generations like Millennial, Generation X, Baby Boomer etc with start and end dates.
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.
How to compare two timestamps in SQL and express the result in hours.
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.
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.
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.
How to find the number of AMPs and Nodes in a Teradata installation using a simple SQL query.
This SQL creates a series of commands that can be used to DROP (aka delete) all the TABLES that match a pattern or username.