2019 review: the year by the numbers

The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the numbers and showing some of the photos that have been my (and our) life this year.

  • 1,069,463: my lifetime total butt-in-seat miles on United, making me a Million-Mile Flyer
  • 61,027: the number of miles I flew on United this year
  • 35,755: my current tweet total (up 465 from 2018)
  • 14,893: the number of people who follow my Twitter ramblings (up 772 from 2018)
  • 13,834: the number of subscribers to our Insider mailing list
  • 6,558: the number of emails I sent (down 2,263 from 2018 – a good thing!)
  • 2,161: the number of non-reference books (real ones) that I own (up only 44 from 2018 – I restrained myself!)
  • 1,179: the number of books I own but haven’t read yet (exactly the same as 2018)
  • 350: the number of SQL Server wait types I have documented in my Wait Types Library (up 6 from 2018)
  • 188: the total number of hours of online training we have available on Pluralsight (up 6 from 2018)
  • 142: the number of nights away from home (down 9 from 2018, and all with Kimberly)
  • 110: the number of dives I did this year, in Mexico twice, Hawaii, and the Maldives, taking my total to 1,023
  • 71: the number of minutes of my longest dive this year
  • 65: the number of Pluralsight courses we have available
  • 44: the number of books I read (see this post)
  • 42: the answer to the question of life, the universe, and everything!
  • 38.90: the percentage of time we were away from home (which is why we call it our vacation home!)
  • 38: the number of flights this year (3 more than 2018)
  • 35: the number of days in Immersion Events and conferences
  • 33: the number of SQLskills blog posts, including this one
  • 25: the number of different places we slept apart from our house and on planes
  • 14: the number of airports I flew through this year
  • 14: the number of monthly magazines I subscribe to
  • 12: the number of years I’ve been married to Kimberly
  • 10: the number of different shark species we saw around the world this year (Galapagos, scalloped hammerhead, grey reef, black-tipped reef, white-tipped reef, silky, nurse, bull, silvertip, dusky)
  • 6: the number of full-time SQLskills employees, all of whom are fabulous and indispensable
  • 4: the number of countries we visited this year
  • 3: the number of wonderful cats we have (Andre, Holtzinger, Valentina)
  • 2: the number of new bird species I saw, taking my total to 606
  • 2: the number of awesome daughters we have (one a sophomore at UC Berkeley studying to be a trauma surgeon, the other a senior in high school)
  • 1: the number of new airlines I flew on (Trans Maldivian Airways – largest seaplane operator in the world), taking my total to 39
  • 1: the number of new airports I flew through (Male, Maldives), taking my total to 101
  • 1: the person who seems to cram the most into non-work time (farming, scouts, diving, building, …): Tim Radney
  • 1: the person who is the best at snapping her fingers and cooking yummy sweets: Erin Stellato
  • 1: the number of Jonathan Kehayias in the world – thankfully :-)
  • 1: the number of wonderful assistants, without whom our lives would be a distressing quagmire – Libby we love you!
  • Finally, the one and only best person in my life: Kimberly, without whom I would be lost…

Thank you to everyone who reads our blogs, follows us on Twitter, sends us questions, watches our videos, comes to our classes, and generally makes being deeply involved in the SQL community a joy.

I sincerely wish you all a happy, healthy, and prosperous New Year!


(April 10; at San Benedicto Island, Revillagigedo Archipelago (300 miles out into the Pacific), Mexico – it’s an 18-foot melanistic (all-black) mobula birostris, a.k.a. giant oceanic manta ray. The big-creature diving in the archipelago was so good that we’re going back in March.)

(September 11; at the end of the Glen Etive road, where the River Etive flows out into Loch Etive, a sea loch in Scotland. Nearby is the house, Invercharnan, that used to be owned by my high school, Glasgow Academy, and I made several weekend trips to in 1984, when I was 12, to help with restoration work. And I’ve camped around there since, many times!)

(September 13; outside the Talisker Distillery on Skye, illustrating one of the main differences between us… and yes, of course I bought a great bottle of scotch while I was there – do every time!)

(October 26; successful test of how good the suction cups are on one of Kimberly’s micro tripods… )

2019: the year in books

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009201020112012201320142015, 2016, 2017, 2018) and people have been enjoying it, so here I present the 2019 end-of-year post. I set a moderate goal of 50 books this year but after reading a record 101 books last year, I slacked off a bit in 2019 and only read 44. Next year I’m setting myself a goal of reading 50 books again as I have a lot of lengthy biographies and other history books I want to tackle.

For the record, I mostly read ‘real’ books – i.e. not in electronic form – I really don’t like reading off a screen. Yes, I’ve seen electronic readers – we both have iPads – but I don’t like reading electronically. Having said that, I did read 13 books electronically this year out of necessity (insurmountable luggage weight and volume restrictions on one of our dive trips). I also don’t ‘speed read’ – I read quickly and make lots of time for reading.

Why do I track metrics? Because I like doing it, and being able to compare against previous years. Some people don’t understand the logic in that – each to their own :-)

I went back-and-forth over the last few days about which book to nominate as my favorite, and I couldn’t come to a decision, so just like in most years, I give you my favorite 3 books: The Garden of Evening Mists by Tan Twan Eng, The Perfectionists: How Precision Engineers Created the Modern World by Simon Winchester, and The Grapes of Wrath by John Steinbeck. All three are superb books and I strongly recommend you give them a try – I was tempted to pick The Grapes of Wrath as the single best book but couldn’t bring myself to drop the other two. You can read my review of them in the top-10 list below.

Now the details. I enjoy putting this together as it will also serve as a record for me many years from now. I hope you get inspired to try some of these books – push yourself with new authors and very often you’ll be surprisingly pleased. Don’t forget to check out the previous year’s blog posts for more inspiration too.

As usual I leave you with a quote that describes a big part of my psychological make-up:

In omnibus requiem quaesivi, et nusquam inveni nisi in angulo cum libro!

Analysis of What I Read

I read 16,056 pages, which is an average of 43.99 pages a day. The chart below shows the number of pages (y-axis) in each book I read (x-axis).

The average book length was 365 pages, which is shorter than most previous years and that’s because I read a few short classics on my iPad while on trips.


Compared to previous years I read almost no science fiction or fantasy fiction, and a lot more history and historical fiction than last year.

The Top 10

I read a lot of excellent books this year and once again I couldn’t whittle it down to a top-10, so here is my top 12. If you don’t read much, at least consider looking at some of these in 2020. It’s impossible to put them into a priority order so I’ve listed them in the order I read them, along with the short Facebook review I wrote at the time.

#2; Savage Continent: Europe in the Aftermath of World War II; Keith Lowe; 496pp; History; January 18 (As school kids, at least in the UK, history classes taught us that WWII ended, and that was it, and I haven’t read anything about that period of history since my school days. In reality, violence and horror went on throughout Europe for years after the official end of the war. I learned a huge amount from this book that I didn’t know about, including the vengeance that occurred (against occupying forces, camp guards, collaborators), forced migrations of whole populations, ethnic cleansing, reuse of the concentration camps, economic collapse and mass starvation, and more. The book covers the period from the end of the war through end of the 1940s when Europe became relatively stable. Hugely interesting, shocking, and eye-opening, and a great primer for my continuing Cold War readings, as it also describes how the Soviet-backed communists established themselves in many countries. Highly recommended!)

 #4; What a Fish Knows: The Inner Lives of Our Underwater Cousins; Jonathan Balcombe; 304pp; Nonfiction; February 8 (Contrary to popular belief, fish do have intelligence, just not like humans. Fish can recognize individuals, learn to use tools, plan for a future event (a grouper signaling to a moray to hunt cooperatively, or a grouper pointing head down at prey hidden in a hole), play, and more. We generally think of fish as dumb things that lead simple lives, but reality is much more complex. This book is a fascinating exploration of what and how fishes perceive, feel, think, know, breed, and are exploited, drawing on myriad scientific studies and interactions. Highly recommended!)

 #7; The Last Days of Night; Graham Moore; 384pp; Historical Fiction; April 8 (This is an excellent fictionalization of the true events in the A/C – D/C ‘current war’ between Edison and Westinghouse in the late 1800s that led to the creation of General Electric. It’s a great page-turner and hugely interesting to me as I’d never read the details of the war before. Highly recommended!)

 #14; The Idea Factory: Bell Labs and the Great Age of Innovation; Jon Gertner; 422pp; History; June 27 (Amazon’s precis says everything I’d say: “From its beginnings in the 1920s until its demise in the 1980s, Bell Labs-officially, the research and development wing of AT&T-was the biggest, and arguably the best, laboratory for new ideas in the world. From the transistor to the laser, from digital communications to cellular telephony, it’s hard to find an aspect of modern life that hasn’t been touched by Bell Labs. In The Idea Factory, Jon Gertner traces the origins of some of the twentieth century’s most important inventions and delivers a riveting and heretofore untold chapter of American history. At its heart this is a story about the life and work of a small group of brilliant and eccentric men-Mervin Kelly, Bill Shockley, Claude Shannon, John Pierce, and Bill Baker-who spent their careers at Bell Labs. Today, when the drive to invent has become a mantra, Bell Labs offers us a way to enrich our understanding of the challenges and solutions to technological innovation. Here, after all, was where the foundational ideas on the management of innovation were born.” Highly recommended!)

 #19; The Map of Knowledge: A Thousand-Year History of How Classical Ideas Were Lost and Found; Violet Moller; 336pp; History; August 12 (This is a fascinating book that explains how ancient Greek knowledge survived the fall of the Roman Empire and suppression by Christianity (for being ‘pagan’) and was reintroduced in the Middle Ages to fuel the renaissance in Europe. It follows three key Greek texts – Euclid’s Elements, Ptolemy’s The Almagest, and Galen’s writings on medicine – plus Arab discoveries as they move around the Mediterranean. Seven cities are highlighted, where the texts either originated, translated, copied or a combination – Alexandria, Baghdad, Cordoba, Toledo, Salerno, Palermo, and Venice – along with the eclectic people mainly responsible. Highly recommended!)

 #21; The Garden of Evening Mists; Tan Twan Eng; 352pp; Fiction; September 11 (What a wonderful book! Definitely the best book of the year so far, it totally sucked me in as a page turner and I bought his debut novel as soon as I finished this one. From Amazon: “Malaya, 1951. Yun Ling Teoh, the scarred lone survivor of a brutal Japanese wartime camp, seeks solace among the jungle-fringed tea plantations of Cameron Highlands. There she discovers Yugiri, the only Japanese garden in Malaya, and its owner and creator, the enigmatic Aritomo, exiled former gardener of the emperor of Japan. Despite her hatred of the Japanese, Yun Ling seeks to engage Aritomo to create a garden in memory of her sister, who died in the camp. Aritomo refuses but agrees to accept Yun Ling as his apprentice “until the monsoon comes.” Then she can design a garden for herself. As the months pass, Yun Ling finds herself intimately drawn to the gardener and his art, while all around them a communist guerilla war rages. But the Garden of Evening Mists remains a place of mystery. Who is Aritomo and how did he come to leave Japan? And is the real story of how Yun Ling managed to survive the war perhaps the darkest secret of all?” Highly, highly recommended!)

 #22; The Marshall Plan: Dawn of the Cold War; Benn Steil; 608pp; History; September 17 (Continuing my loose ‘Cold War’ year of reading, this book does an excellent job of detailing the events leading up to the creation and implementation of the famous Marshall Plan. It helped with the reconstruction of post-war Western Europe as a barrier against the expansion of communism from the East, and was an extraordinary undertaking by the US to reintegrate Germany into society after the horrors it inflicted during WWII. It also can be said to have precipitated the Cold War, as Stalin’s instructions to countries under the Soviet thumb to refuse US aid effectively created the Iron Curtain and the division of Soviet vs. US spheres of influence in Europe. The book is quite the page turner and gives the complete history in a really engaging and interesting way, and now I’m looking forward to reading Steil’s The Battle of Breton Woods. Highly recommended!)

 #31; The Perfectionists: How Precision Engineers Created the Modern World; Simon Winchester; 416pp; Nonfiction; November 3 (Winchester’s books are always extraordinary and this one was really superb. As an engineer by education and training, this topic is fascinating. He orders the book by increasing precision, starting with a bored cylinder for James Watt’s steam engine in 1776 that had a tolerance of the width of a shilling, and ending with machines in the LIGO gravity-wave detection facilities (which can measure light to a precision of 1 ten-thousandth the width of a proton, or in another definition, the distance from Earth to Alpha Centauri A to an accuracy of less than the diameter of a human hair). Entertaining, *hugely* educational, and highly recommended (and also all the other books he’s written). Enjoy!)

 #32; The Lovely Bones; Alice Sebold; 352pp; Fiction; November 28 (I’ve seen this many times in airport bookshops and realized at the start of the flight that I had it on my iPad (don’t take real books on Asia dive trips any more) so gave it a whirl. What a page turner! Excellent novel about a girl who is murdered and then watches (from her heaven) her family, friends, and killer continue with their lives over the next 10 years. Very well written, and well deserved #1 best seller at the time. Highly recommended!)

 #33; A Farewell to Arms; Ernest Hemingway; 352pp; Fiction; November 28 (This is an excellent semi-autobiographical novel based on Hemingway’s time as an ambulance driver in Italy during WWI. It’s about an American ambulance driver who’s injured and falls in love with an English nurse during his convalescence. Once back at the front he gets caught up in a shambolic retreat and deserts to run away with his love. Hugely gripping and highly recommended!)

 #35; The Call of the Wild; Jack London; 64pp; Fiction; November 29 (What an excellent book! This is definitely on my short list for one of the best books of the year. It follows the life of Buck, a huge St. Bernard/shepherd mix, who is stolen from a life of privilege in CA and transported to the harsh life on a dog team in Alaska. Gradually Buck transforms into a leader and a legend, eventually reverting completely to a wild state. Hugely enjoyable and highly recommended!)

 #42; The Grapes of Wrath; John Steinbeck; 464pp; Fiction; December 17 (Wow. What a fantastic book. It’s an extremely powerful story about the struggles and deprivations of a mid-West family being thrown off their land and moving West to the Shangri-la of California during the Great Depression era of the US in the 1930s. Sometimes horrific and sometimes uplifting, it’s a total masterpiece. Hugely recommended!)

The Complete List

And the complete list, with links to Amazon so you can explore further. One thing to bear in mind, the dates I finished reading the book don’t mean that I started, for instance, book #2 after finishing book #1. I usually have anywhere from 10-15 books on the go at any one time so I can dip into whatever my mood is for that day. Some books I read start to finish without picking up another one and some books take me over a year. Lots of long airplane flights and boat trips help too!

  1. The Cold War: A New History; John Lewis Gaddis; 352pp; History; January 5
  2. Savage Continent: Europe in the Aftermath of World War II; Keith Lowe; 496pp; History; January 18
  3. Bookshops: A Reader’s History; Jorge Carrión; 304pp; Nonfiction; January 20
  4. What a Fish Knows: The Inner Lives of Our Underwater Cousins; Jonathan Balcombe; 304pp; Nonfiction; February 8
  5. London Underground: 1863 onwards (all lines and extensions); Paul Moss; 189pp; History; April 2
  6. Browsings: A Year of Reading, Collecting, and Living with Books; Michael Dirda; 256pp; Nonfiction; April 6
  7. The Last Days of Night; Graham Moore; 384pp; Historical Fiction; April 8
  8. Barkskins; E. Annie Proulx; 736pp; Historical Fiction; April 10
  9. Dragonfly in Amber; Diana Gabaldon; 752pp; Historical Fiction; April 13
  10. Flood of Fire; Amitav Ghosh; 624pp; Historical Fiction; April 17
  11. Raven Black; Ann Cleeves; 384pp; Fiction; May 7
  12. White Nights; Ann Cleeves; 400pp; Fiction; May 16
  13. Red Bones; Ann Cleeves; 404pp; Fiction; June 9
  14. The Idea Factory: Bell Labs and the Great Age of Innovation; Jon Gertner; 422pp; History; June 27
  15. Blue Lightning; Ann Cleeves; 368pp; Fiction; July 5
  16. The Catalogue of Shipwrecked Books; Edward Wilson-Lee; 416pp; History; July 6
  17. U-Boat 1936-45 (Type VIIA, B, C and Type VIIC/41); Alan Gallop; 160pp; History; July 7
  18. K Blows Top: A Cold War Comic Interlude Starring Nikita Khrushchev, America’s Most Unlikely Tourist; Peter Carlson; 352pp; History; August 1
  19. The Map of Knowledge: A Thousand-Year History of How Classical Ideas Were Lost and Found; Violet Moller; 336pp; History; August 12
  20. Ten Caesars: Roman Emperors from Augustus to Constantine; Barry Strauss; 432pp; Biography; September 8
  21. The Garden of Evening Mists; Tan Twan Eng; 352pp; Fiction; September 11
  22. The Marshall Plan: Dawn of the Cold War; Benn Steil; 608pp; History; September 17
  23. The Secret Scripture; Sebastian Barry; 320pp; Fiction; September 25
  24. Cicero: The Life and Times of Rome’s Greatest Politician; Anthony Everitt; 400pp; Biography; September 29
  25. Heart of Oak: A Sailor’s Life in Nelson’s Navy; James McGuane; 192pp; History; October 1
  26. The Trojan War: A New History; Barry Strauss; 288pp; History; October 4
  27. Dronescapes: The New Aerial Photography from Dronestagram; Dronestagram; 288pp; Photography; October 5
  28. Cold Earth; Ann Cleeves; 400pp; Fiction; October 14
  29. War of the Wolf; Bernard Cornwell; 352pp; Historical Fiction; October 15
  30. The Skinner; Neal Asher; 583pp; Science Fiction; October 18
  31. The Perfectionists: How Precision Engineers Created the Modern World; Simon Winchester; 416pp; Nonfiction; November 3
  32. The Lovely Bones; Alice Sebold; 352pp; Fiction; November 28
  33. A Farewell to Arms; Ernest Hemingway; 352pp; Fiction; November 28
  34. The Purloined Letter; Edgar Allan Poe; 64pp; Fiction; November 29
  35. The Call of the Wild; Jack London; 64pp; Fiction; November 29
  36. Diary: A Novel; Chuck Palahnuik; 272pp; Fiction; November 30
  37. Never Let Me Go; Kazuo Ishiguro; 304pp; Fiction; December 3
  38. The Scarlet Letter; Nathaniel Hawthorne; 256pp; Fiction; December 6
  39. Through the Looking Glass; Lewis Carroll; 128pp; Fiction; December 7
  40. Fugitives And Refugees: A Walk in Portland, Oregon; Chuck Palahnuik; 175pp; Nonfiction; December 7
  41. In The Woods; Tana French; 464pp; Fiction; December 14
  42. The Grapes of Wrath; John Steinbeck; 464pp; Fiction; December 17
  43. Gulliver’s Travels; Jonathan Swift; 288pp; Fiction; December 20
  44. East of Eden; John Steinbeck; 603pp; Fiction; December 26

Twenty years ago today…

… I emigrated to the United States. I boarded a plane in Glasgow with my (then) wife Sylvia, bounced in Amsterdam and then landed in Seattle, entering the US on an H1B visa after almost five years of working for DEC/Digital. We arrived in temp housing a block away from the Microsoft Campus late in the evening, and I started work in Building 1 with the SQL Server team on Monday, February 1st 1999. My first task was making the integer conversion code in BULK INSERT and bcp go faster. Microsoft was nice enough to pay for my Green Card, making us Permanent Residents on Valentine’s Day 2002, and I naturalized as a U.S. citizen on April 3, 2012.

Fast forward 20 years from 1999 and here I am today running SQLskills with Kimberly (left Microsoft on August 31, 2007), with an eldest daughter studying at U.C. Berkeley to be a trauma surgeon and the other daughter a junior in high school. (Sylvia is still here too, in case you were wondering, naturalized, remarried, and we’re good friends – the girls are lucky to have her as their mother.)

It’s been a pretty wild ride over the last twenty years, but I wouldn’t live anywhere else in the world now.

Thank you to Microsoft for bringing me here, and thank you to the United States for accepting me as a citizen.