How do you spell “Brittany”? The picture above has four well-known women with four different spellings of the name. It turns out there are nearly 100 different ways that Americans have spelled it. The US Social Security Administration names data lets us tease out all the spellings and find out which ones are most popular – and when.
Read more
What’s in a name? or rather, in the SSA Names data
One of the amazing things about being a DBA/developer in 2016 is the sheer amount of freely available, downloadable data to play with. One fun publicly available data sets is the American Social Security Administration names data. It contains all names for which SSNs were issued for each year, with the number of occurrences (although names with <5 occurrences are not included to protect individual privacy).
“What do you mean there’s line breaks in the address?” said SQLLDR
I had a large-ish CSV to load and a problem: line breaks inside some of the delimited fields.
Read more
Tip of the day: Always put this in your .bashrc
if you like to scp:
# If not running interactively, don't do anything [[ $- == *i* ]] || return
Otherwise scp will fail without error – it’s a known bug.
SQL vs. Excel – Subgroup medians
Got anyone who needs April Fooling?
Do you have a sql*plus user who really needs an April Fool’s joke played on them? With a little editing to their glogin.sql, every sql*plus session will exit with what appears to be a pseudo-random TNS error.
Read more
Review: Oracle RAC Performance Tuning
Some time ago, I received a free review copy of Brian Peasland‘s recent book, Oracle RAC Performance Tuning.
Read more
Roman numerals to decimal in SQL
Earlier this week I got tangled up doing a Roman Numeral conversion in my head. So of course my second thought, right after “Doh!”, was “I bet I can write a SQL statement to do this for me next time.”
Read more
Search plugins: Search Oracle docs from your browser search bar
Tired of navigating to the SQL documentation every time you need to look up syntax? I created a search plugin so that you can search the SQL documentation directly from your browser’s search bar:
Running totals in SQL
One of the many useful things analytic SQL makes it easy to do is a running total - or running average, or other calculation. This post is a quick look at the syntax.