Using Excel 2016 to unpivot data
Normal people, by which I mean those who don’t process data all day will often create data that is present …
Tag Archives: SQL
Create the Union of two tables in Excel revisited
In 2013 I published a technique to create the union of two tables in Excel. This post is still very …
Understanding Formidable Forms and WordPress
I have been using Formidable Forms with WordPress on and off for about 3 years. I have a conventional SQL …
Recreate views after changing datatypes in referenced tables
I recently came across a problem that was difficult to diagnose. After I had changed the datatype in a table …
“Big data” on AWS – Redshift
“Big data” is hot, hot, hot (Gartner hype cycle) and now supported by Amazon Web Services. Although pitched as “Big …
