2017 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 that have been my life this year.

  • 106,914: the number of miles I flew on United this year (plus 8,504 miles on other airlines around Indonesia)
  • 34,827: my current tweet total (up 742 from 2016)
  • 13,642: the number of subscribers to our Insider mailing list (up 208 from 2016)
  • 13,379: the number of people who follow my Twitter ramblings (up 1,211 from 2016)
  • 9,683: the number of emails I sent (up 885 from 2016 – not a good thing!)
  • 1,900: the number of non-reference books (real ones) that I own (up 121 from 2016)
  • 1,059: the number of books I own but haven’t read yet (up 61 from 2016, but I removed a bunch of reference books from the total)
  • 329: the number of SQL Server wait types I have documented in my Wait Types Library (up 43 from 2016)
  • 141: the number of nights away from home (down 43 from 2016, and all with Kimberly)
  • 172: the total number of hours of online training we have available on Pluralsight (up 23 from 2016)
  • 153: the number of dives I did this year, in Indonesia and the Bahamas, taking my total to 805
  • 107: the number of minutes of my longest dive this year, at what we think is the best muck-diving site in the world
  • 38.63: the percentage of time we were away from home (which is why we call it our vacation home!)
  • 60: the number of SQLskills blog posts, including this one
  • 58: the number of Pluralsight courses we have available
  • 48: the number of books I read (see this post)
  • 44: the number of flights this year (2 more than 2016)
  • 42: the answer to the question of life, the universe, and everything!
  • 35: the number of days in Immersion Events and conferences
  • 24: the number of different places we slept apart from our house and on planes
  • 18: the number of monthly magazines I subscribe to
  • 17: the number of airports I flew through this year
  • 10: the number of years I’ve been married to Kimberly
  • 9: the number of different octopus species we saw in Indonesia this year (coconut, algae, reef, blue-ring, greater blue-ring, starry-night, mimic, wonderpus, long-arm)
  • 5: the number of Great Courses I watched this year
  • 4: the number of countries we visited this year
  • 3: the number of new airports I flew through (Ambon, Indonesia; Freeport, Bahamas; Fort Lauderdale), taking my total to 94
  • 2: the number of awesome daughters we have
  • 1: the number of new bird species I saw, taking my total to 512
  • 1: the number of new airlines I flew on (WestJet), taking my total to 36
  • 1: the person who seems to cram the most into non-work time (farming, scouts, PokemonGo, building, …): Tim Radney
  • 1: the person who is the best at snapping her fingers and ran a marathon this year: Erin Stellato
  • 1: the number of Jonathan Kehayias in the world – thankfully :-)
  • 1: the number of indispensable assistants, without whom our lives would be a distressing quagmire – Libby we love you!
  • 1: our wonderful chocolate lab, Coco, who passed away in November
  • 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!


(July 4th, on our deck, watching the fireworks over Lake Sammamish)

(July 8th, in Canada: It’s not dark. It’s 150 miles to home. We have a giant letter R. We’re both wearing sunglasses… let’s go!)

(Later in July, diving in the Bahamas with Emma, the 18-foot tiger shark; I’m on the left, our daughters are on my right)

2017: 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) and people have been enjoying it, so here I present the 2017 end-of-year post. I set a moderate goal of 50 books this year but I only managed 48 as I spent a bunch of time in the first half of the year catching up with my magazine backlog. Next year I’m setting myself a goal of reading 50 books again.

For the record, I read ‘real’ books – i.e. not in electronic form – I 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 one electronically this year out of necessity, and will have to read a few in 2018 electronically due to insurmountable luggage weight and volume restrictions on one of our 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 just couldn’t come to a decision, so just like in most years, I give you my favorite 3 books: The North Water by Ian McGuire, I Contain Multitudes: The Microbes Within Us and a Grander View of Life by Ed Yong, and Remarkable Books: The World’s Most Beautiful and Historic Works by DK. All three are superb books and I strongly recommend you give them a try. 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 20,628 pages, which is an average of 56.52 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 430 pages, almost exactly the same as last year (429) but shorter than previous years. That’s because I again read a lot of series books where each isn’t hugely long.

I read a lot more nonfiction than in previous years, which is shown by 8 of my top-13 below being nonfiction books.

The Top 10

I read a lot of excellent books this year and I thought as I only read 48 that I’d be able to whittle them down to a top-10, but I couldn’t, so here is my top 13. If you don’t read much, at least consider looking at some of these in 2017. 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.

 #3; The Bone Tree; Greg Iles; 816pp; Fiction; January 10; (This is the follow-on from the fantastic Natchez Burning, which was my favorite book of 2014, and you really need to read that before this one, as this one continues the story from the next day. This book starts to pull the characters into the Kennedy assassination investigations and links to the extreme racist murders from the 1960s. It’s hard to say more without giving away some of the plot and twists. The writing is excellent, with great dialog, and the book is a real page-turner. The story isn’t complete though – that’s coming in March in Iles’ conclusion to the trilogy: Mississippi Blood. Highly recommended!)

 #10; Dirty Wars: The World Is a Battlefield; Jeremy Scahill; 681pp; Nonfiction; April 21; (This is an extremely interesting book that investigates the ongoing, autonomous U.S. military operations around the world that have been undertaken as part of the war on terror. It exposes the extrajudicial capture/torture/kill program that was created in secret by the Bush administration (and continued and greatly enhanced by the Obama administration), and operated by the CIA and various Special Forces under the JSOC umbrella in Yemen, Iraq, Pakistan, Afghanistan, and Somalia. It uses the case of Anwar Awlaki as the center-point of the narrative. He was a U.S. citizen of Yemeni descent, who became an Islamic teacher and, after fleeing the U.S., went on to become an outspoken proponent of violent jihad against the West. He was linked to AQAP and wrote for their Inspire newsletter. I actually downloaded one of the newsletters to read – quite disturbing stuff. It’s a huge book that’s full of factual information without engaging in partisan criticism. Scahill raises some excellent questions about the morality and constitutional legality of such a program, especially when it targets U.S. citizens for death. Whether you agree with such programs or not, the book is well worth reading. Highly recommended!)

 #14; The Revenge of Analog: Real Things and Why They Matter; David Sax; 304pp; Nonfiction; July 11; (What a great book! As a confirmed Luddite, I was really looking forward to the various parts of the book. It covers the resurgence of vinyl records, paper and magazines (check out Stack and Delayed Gratification, both of which I subscribed too), photo film, board games, books, bricks-and-mortar retail, and analog ideas around work, education, and online companies. It’s quite clear that going all digital isn’t what people want. Very interesting, not written in a preachy or manifesto way, and highly recommended!)

 #18; Fast Food Nation: The Dark Side of the All-American Meal; Eric Schlosser; 362pp; Nonfiction; August 25; (Schlosser’s book is a searing expose of the business practices behind the American fast food industry, focusing on McDonald’s and the giant beef processing companies that supply it. Although written in 2001, the industry is still much the same today (not including those chains that create and cook their food fresh every day). The most shocking thing is really how the industry has pressured the government into reducing and/or removing safety and health inspections from the beef supply chain. Once you read about the meat processing facilities, I’ll be surprised if you ever eat a frozen beef patty again. This is definitely not a go-vegetarian rant, but a level-headed, fact-based examination of how fast food is sourced, processed, and prepared. Highly recommended. (And I also strongly recommend Schlosser’s Command and Control that I read a few years ago.))

 #22; What the Dog Saw: And Other Adventures; Malcolm Gladwell; 448pp; Nonfiction; September 3; (I really enjoy Gladwell’s books (e.g. The Tipping Point, Blink, Outliers) and this one was just as good. Rather than being a book that focuses on a single topic about how to understand ourselves and the world, this is a collection of some of Gladwell’s best long articles for The New Yorker along the same lines. It covers 19 topics, all of which are extremely interesting and thought provoking. Highly recommended! (and all his other books too!))

 #23; Crystal Fire: The Invention of the Transistor and the Birth of the Information Age; Riordan and Hoddeson; 368pp; History; September 3; (This book recounts the history of the development of the transistor, from the beginnings of solid-state physics in the late 1800s and early 1900s through to the invention and fabrication of the first microchips in the early 1960s. It’s also something of a biography of William Shockley, who was arguably the central character in the transistor’s creation, along with John Bardeen and Walter Brattain, fellow Bell Labs employees and co-winners of the 1956 Nobel Prize for Physics. Hugely interesting and very readable – highly recommended!)

 #27; Why Nations Fail: The Origins of Power, Prosperity, and Poverty; Acemoglu and Robinson; 544pp; Nonfiction; September 9; (The book puts forth a theory that nations with inclusive economic and political institutions are much more likely to succeed than those with extractive institutions (extractive meaning that the populace is exploited by a small elite for their own gain, inclusive meaning that all citizens are treated equally and property rights are protected by law). It also explains why inclusive institutions developed in some parts of the world and not in others, with exploitative colonialism being a major historical impediment to inclusivity. Lots of interesting case studies and history – highly recommended!)

 #30; The North Water; Ian McGuire; 272pp; Historical Fiction; September 26; (Excellent book! (So good I just picked up all McGuire’s other novels.) Set in the mid-1800s as the whaling industry is coming to an end. A ship sets off for the Greenland waters and many dark things happens. It reminds me of Melville’s Moby Dick, but a lot faster, and a lot more raw. Highly recommend and a possible candidate for my best book of the year!)

 #31; I Contain Multitudes: The Microbes Within Us and a Grander View of Life; Ed Yong; 357pp; Nonfiction; October 1; (What an excellent book! Thanks to Buck Woody for the recommendation. The book explains all kinds of fascinating things about bacteria and our microbiomes, the history of their understanding by science, and how the quest to rid ourselves of them is futile, and in quite a few cases, actually harming people that live in developed nations. More interestingly, it also introduces many scientists who have identified beneficial bacteria and used them to help solve medical or environmental problems – e.g. preventing the dreaded Bd fungus killing a group of frogs, inoculating a group of mosquitoes with a bacteria that prevents them carrying dengue fever, and fecal-matter transplants to help sufferers of persistent C-diff infections – poo pill anyone? Hugely interesting, and written in an entertaining manner, this book is for anyone. Highly recommended!)

 #36; Days Without End; Sebastian Barry; 272pp; Historical Fiction; October 13; (This is my time reading Barry’s work and won’t be the last (already bought 3 more of his books). The book follows a pair of Irish immigrants who join the US army in the mid-1800s, take part in brutally putting down Indians, and fight in the Civil War on the Union side. Very atmospheric and a page turner. Highly recommended!)

 #37; The Lighthouse Road; Peter Geye; 304pp; Historical Fiction; October 14; (Excellent novel, following a misbegotten family in early 1900s north Minnesota – starting with a young Norwegian immigrant woman. Logging, wolves, fishing, orphans, tough times, and heartbreak, lots of heartbreak. Highly recommended.)

 #44; The Little Paris Bookshop; Nina George; 416pp; Fiction; November 18; (I started this last week on the day Coco died as a distraction – what could be more uplifting for a bibliophile than a book about books and a bookshop? It’s a lovely book, about a bookseller who prescribes certain books to ease his customers’ pains. He loses love, takes his floating bookshop downriver, and finds it again. Gentle read and very relaxing. And did I mention it’s about books? Recommended.)

 #47; Remarkable Books: The World’s Most Beautiful and Historic Works; DK; 256pp; Nonfiction; December 25; (Merry Christmas! Just finished book #47 this year. As you all know I’m seriously addicted to books and reading – a true bibliophile. I’ve been working through this wonderful book during December reading about a few books each day. Here’s the Amazon blurb about it that describes is better than I can:<begin> A beautifully illustrated guide to more than 75 of the world’s most celebrated rare and seminal books and handwritten manuscripts ever produced with discussions of their purpose features and creators. From ancient masterpieces such as The Art of War written on the leaves of bamboo to the stunningly illustrated Birds of America to Chairman Mao’s Little Red Book Remarkable Books delves into the stories behind the most incredible tomes ever produced offering an insight into their wider social and cultural context and is chronologically ordered to demonstrate the synergies between the growth in human knowledge and the bookmaking process. Alongside breathtaking images of the books and manuscripts themselves close-up views draw out interesting features which are discussed in greater detail while biographies tell the lives of the people who produced them. This coffee table–worthy book is wrapped in a textured jacket with gold foil making it a great gift for those with an interest in literature and art and design. <end> I’m familiar with many of the books covered especially the illustrated manuscripts from the Middle Ages as those are of particular interest to me. It really is a fantastic book itself and I hugely recommend it!)

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. Memories of Ice: A Tale of the Malazan Book of the Fallen; Steven Erikson; 1187pp; Fantasy Fiction; January 3
  2. The Wine-Dark Sea; Patrick O’Brian; 295pp; Historical Fiction; January 5
  3. The Bone Tree; Greg Iles; 816pp; Fiction; January 10
  4. Indonesia, Etc.: Exploring the Improbable Nation; Elizebath Pisani; 416pp; Travel; January 22
  5. The Life of Elizabeth I; Alison Weir; 656pp; History; February 20
  6. Forbidden Places: Exploring our Abandoned Heritage; Sylvain Margaine; 256pp; Photography; March 1
  7. House of Chains: A Tale of the Malazan Book of the Fallen; Steven Erickson; 1040pp; Fantasy Fiction; March 27
  8. The Origins of Political Order: From Prehuman Times to the French Revolution; Francis Fukuyama; 608pp; Nonfiction; April 2
  9. Fresh Air Fiend: Travel Writings; Paul Theroux; 480pp; Travel; April 9
  10. Dirty Wars: The World Is a Battlefield; Jeremy Scahill; 681pp; Nonfiction; April 21
  11. Shift; Hugh Howey; 608pp; Science Fiction; May 10
  12. A Night Without Stars; Peter F. Hamilton; 640pp; Science Fiction; May 25
  13. Babylon’s Ashes; James S. A. Corey; 538pp; Science Fiction; June 27
  14. The Revenge of Analog: Real Things and Why They Matter; David Sax; 304pp; Nonfiction; July 11
  15. The Life-Changing Magic of Not Giving a F*ck; Sarah Knight; 224pp; Nonfiction; July 29
  16. The Bat; Jo Nesbo; 384pp; Fiction; August 18
  17. The Kingdom by the Sea: A Journey Around the Coast of Great Britain; Paul Theroux; 368pp; Travel; August 23
  18. Fast Food Nation: The Dark Side of the All-American Meal; Eric Schlosser; 362pp; Nonfiction; August 25
  19. The Commodore; Patrick O’Brian; 303pp; Historical Fiction; August 28
  20. Bleak House; Charles Dickens; 1088pp; Fiction; August 28
  21. The Yellow Admiral; Patrick O’Brian; 264pp; Historical Fiction; August 29
  22. What the Dog Saw: And Other Adventures; Malcolm Gladwell; 448pp; Nonfiction; September 3
  23. Crystal Fire: The Invention of the Transistor and the Birth of the Information Age; Riordan and Hoddeson; 368pp; History; September 3
  24. The Hundred Days; Patrick O’Brian; 272pp; Historical Fiction; September 5
  25. Blue at the Mizzen; Patrick O’Brian; 252pp; Historical Fiction; September 6
  26. Book 21 / The Complete Aubrey/Maturin Novels; Patrick O’Brian; 65pp; Historical Fiction; September 6
  27. Why Nations Fail: The Origins of Power, Prosperity, and Poverty; Acemoglu and Robinson; 544pp; Nonfiction; September 9
  28. Midnight Tides: A Tale of the Malazan Book of the Fallen; Steven Erikson; 960pp; Fantasy Fiction; September 15
  29. Dark Intelligence: Transformation Book One; Neal Asher; 402pp; Science Fiction; September 23
  30. The North Water; Ian McGuire; 272pp; Historical Fiction; September 26
  31. I Contain Multitudes: The Microbes Within Us and a Grander View of Life; Ed Yong; 357pp; Nonfiction; October 1
  32. Thirteen Days: A Memoir of the Cuban Missile Crisis; Robert F. Kennedy; 222pp; History; October 4
  33. The Peripheral; Willam Gibson; 485pp; Science Fiction; October 5
  34. Dust; Hugh Howey; 480pp; Science Fiction; October 10
  35. Night of Knives: A Novel of the Mazalan Empire; Ian C. Esslemont; 304pp; Fantasy Fiction; October 12
  36. Days Without End; Sebastian Barry; 272pp; Historical Fiction; October 13
  37. The Lighthouse Road; Peter Geye; 304pp; Historical Fiction; October 14
  38. Mr. Penumbra’s 24-Hour Bookstore; Robin Sloan; 288pp; Fiction; October 25
  39. Neutron Star; Larry Niven; 285pp; Science Fiction; October 25
  40. Archipelago: Portraits of Life in the World’s Most Remote Island Sanctuary; Middleton and Liittschwager; 264pp; Photography; October 26
  41. Atlas of Remote Islands; Judith Schalansky; 144pp; Nonfiction; October 27
  42. The Technician; Neal Asher; 503pp; Science Fiction; November 9
  43. Atlas of Cursed Places: A Travel Guide to Dangerous and Frightful Places; Olivier Le Carrer; 144pp; Nonfiction; November 15
  44. The Little Paris Bookshop; Nina George; 416pp; Fiction; November 18
  45. Platform Souls: The Trainspotter as 20th-Century Hero; Nicholas Whittaker; 288pp; Nonfiction; November 24
  46. Origin; Dan Brown; 461pp; Fiction; December 8
  47. Remarkable Books: The World’s Most Beautiful and Historic Works; DK; 256pp; Nonfiction; December 25
  48. Mrs Rosie and the Priest; Giovanni Boccaccio; 54pp; Fiction; December 27

Live online training from Kimberly in early January!

We’ve been considering doing some live, online training classes for a while now, and with the demand for Kimberly to teach an Immersion Event on partitioning, we’ve decided to take the plunge and present our first live, online class in January!

Kimberly will be teaching our new IEVLT: Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning live, online over January 9-11, 2018.

Rather than have people try to watch a full day of training at their computer for one of more days, the class will run from 10am to 3pm PST each day, with two 90-minute teaching sessions, each followed by Q&A, and a lunch break. We chose to do this, and to spread the class over a few days, so the times work well for those in the Americas, Africa, and Europe (we might consider doing some time-shifted classes for those in Asia and Australia/New Zealand, depending on demand). We also realize that this is complex, architectural content, so want to give attendees time to digest each day’s material, plus extensive Q&A.

The modules covered will be:

  • Horizontal Partitioning Strategies
  • Partitioned Views
  • Partitioned Tables
  • Tables, Indexes, Keys, and Relationships
  • Implementing the Sliding Window Scenario
  • Key Partitioning Concerns and Considerations
  • Partitioning Techniques Combined
  • Review

The price of the class is US$595 and you can get all the details here.

The class is already half full, as we announced it in our newsletter on Monday. All future live, online training classes will always be announced first in the newsletter, with a discount price available for 48 hours before the class is announced here and linked into the training section of our website, at the regular price.

We decided to start teaching some live, online classes as we recognize that not everyone can travel to our in-person classes, or take that time away from work or family, or simply have travel budget as well as training budget. People also have different ways they learn, some preferring in-person training, some preferring recorded, online training, and some preferring live, online training.

We’ll be doing more of this in 2018, on a variety of topics, so stay tuned for updates (and discounts through the newsletter).

We hope you can join us!