2013 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.

  • 9233243 (roughly): the number of page views across my blog according to Google (up around 15% from 2012)
  • 112289: the number of miles I flew on United
  • 29660: my current tweet total (up 3271 from 2012)
  • 12060: the number of emails I sent (up 1238 from 2012)
  • 10290: the number of subscribers to our Insider mailing list (up 1793 from 2012)
  • 7681: the number of people who follow my Twitter ramblings (up 2011 from 2012)
  • 1330: the number of books (real ones) that I own (up 144 from 2012)
  • 707: the number of books I own but haven’t read yet (up 90 from 2012)
  • 198: the number of nights away from home (all with Kimberly, so not *too* bad)
  • 142: miles per hour I hit driving a NASCAR car around Charlotte Motor Speedway after PASS in October
  • 122: the number of dives I did this year in Kona, Thailand, and Turks & Caicos, taking my total to 307
  • 109: the number of feet down on my deepest dive this year
  • 83: the number of minutes of my longest dive this year
  • 75: the number of days in Immersion Events and conferences
  • 66: the number of SQLskills blog posts, including this one
  • 56: the number of books I read (see this post)
  • 54.25: the percentage of time we were away from home (which is why we call it our vacation home!)
  • 42: the number of flights this year
  • 26: the number of different places we slept apart from our house and on planes
  • 20: the number of new bird species I saw, taking my total to 464
  • 19: the number of new Pluralsight courses we published this year, taking our total to 30
  • 17: the number of airports I flew through this year
  • 15: the number of monthly magazines I subscribe to
  • 6: the number of  SQLskills full-time employees, all of whom are fabulous and indispensable
  • 5: the number of countries we visited this year
  • 4: the number of new airports I flew through, taking my total to 80
  • 2: the number of new countries I visited this year (Japan and Turks & Caicos), taking my total to 32
  • 2: the number of awesome daughters we have, who got Nitrox certified and passed their Advanced Open Water SCUBA certifications last week
  • 1: rated session at the PASS Summit for my Waits, Latches, and Spinlocks session – woohoo!
  • 1: rated pre-con workshop at the PASS Summit for my Practical Disaster Recovery Techniques workshop – woohoo again!
  • 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!


(Diving with the girls over Christmas on the excellent Turks & Caicos Aggressor, courtesy of the boat crew)


(Swimming with Caribbean Reef Sharks, courtesy of Kimberly)


2013: 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 200920102011, 2012) and people have been enjoying it, so I present the 2013 end-of-year post. I set a moderate goal of 60 books this year and I managed 56. Next year I want to get through some of the really large historical and biographical books I’ve been putting off so I’m setting myself a goal of 40.

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 – and I’m not interested in ever reading electronically. I also don’t ‘speed read’ – I read quickly and make lots of time for reading.

There were several strong candidates for my favorite book this year (including Cutting for Stone by Abraham VergheseThe Known World by Edward P. Jones, and Great North Road by Peter F. Hamilton) but I have to choose The Hydrogen Sonata by Iain M. Banks, in honor of my all-time favorite author for the last 25 years who died tragically early in June this year after a short fight with gallbladder cancer. I’ve read all of his sci-fi novels several times and most of his regular fiction (published as Iain Banks) and I wish I could have met him to thank him for his work. I actually cried when I heard he’d died and even writing this I have a lump in my throat. RIP Iain – you are sorely missed by your fans.

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.

Once again 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 24800 pages, or 68.0 pages a day, and a book every 6.5 days or so. The chart below shows the number of pages (y-axis) in each book I read (x-axis).



The average book length was 443 pages, 26 pages shorter than last year. Quite interestingly, I read about half the amount of historical fiction this year compared to 2012, and made up for that with more non-fiction and history, and many more travel books.

The Top-10 Top-15

Once again I really struggled to pick a top-10 this year as I read a lot of truly *superb* books in 2013. I didn’t want to leave any out of my short list and deny you the chance of having them suggested so I present you with my top-15! If you don’t read much, at least consider looking at some of these in 2014. 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.

HydrogenSonata #1 The Hydrogen Sonata; Iain M. Banks; 517pp; Science Fiction; January 5; (True to Banks’ usual form, his latest Culture novel is excellent. Lots of ship and Mind conversation, clever action, and great characters. Strongly recommended, a must for Banks fans.)

EmptyQuarter #2 Empty Quarter: A Photographic Journey to the Heart of the Arabian Desert; George Steinmetz ; 208pp; Photographic; January 8; (Stunning aerial photography of the Empty Quarter of Arabia in Oman, Yemen, Saudi Arabia, and the United Arab Emirates. I’ve been fascinated by this area of the world since reading books like Thessiger’s Arabian Sands and its on my list of places to see before I die. This is the next best thing – 2– plates shot from a microlight 1000 feet up – just stunning! I’ve got several more of Steinmetz’s photography books in my plans this year. Strongly recommended!)

GreatNorthRoad #5 Great North Road; Peter F. Hamilton; 948pp; Science Fiction; January 31; (Just finished book #5 this year. Absolutely excellent, long, sci-fi romp from one of my favorite authors.)

Stonemouth #6 Stonemouth; Iain Banks; 356pp; Fiction; February 3; (Read most of it on the plane down from Seattle to Tampa – a real page turner. I haven’t read much of Banks’ non-science fiction since I was put off by Dead Air a while back. This book is really excellent though and I’d recommend it to anyone. Reminds me of some of my life in my early twenties.)

Lionheart #7 Lionheart; Sharon Kay Penman; 608pp; Historical Fiction; March 5; (Finished this on the flight from Kushiro to Tokyo. Great part 4 of the series covering the Angevin empire in the 1100s. This book really covers the 3rd Crusade and Richard’s involvement in it – a topic I’ve read a lot on but never read a fictionalized account of. Penman doesn’t disappoint and I strongly recommend this book to historical fiction fans.)

KingHereafter #8 King Hereafter; Dorothy Dunnett; 736pp; Historical Fiction; March 17; (Brilliant fictionalization of King Macbeth in the 11th Century. A very long book (730pp) with very dense writing and small font that made it feel like 1500pp really. Dunnett does an awesome job of describing the people, places, and society and I’m looking forward to reading her Lymond and Niccolo series. Strongly recommended.)

secretum #22 Secretum; Monalid & Sorti; 812pp; Historical Fiction; June 18; (An excellent sequel to Imprimatur that I read last year, this is set 17 years later, in 1700 in Rome, with the same protagonists involved in intrigue, subterfuge, and adventure. Intermingling meticulously-researched history and real characters, the book deals with the wrangling over the Spanish Succession leading up to the death of Charles II of Spain. Highly recommended.)

AmericanRust #28 American Rust; Philipp Meyer; 384pp; Fiction; July 9; (Excellent drama set in recently declining Pennsylvania steel country. Hard to describe the story line except to say it’s told from the points of view of six people linked to single act of violence that sets a bunch of stuff in motion. Great new author for me to discover – recommended!)

KnownWorld #31 The Known World; Edward P. Jones; 432pp; Historical Fiction; July 14; (Really excellent and powerful novel about slavery in mid-1800s Virginia, and one of the best books I’ve read this year, although I stopped midway to read #29 and #30. Barbarous to think of people as property, and that a husband could be freed and then have to work up to paying for the eventual freedom of his wife and children. Runaways, if they were caught, could expect to be ‘hobbled’ by severing one of their Achilles tendons – nasty. Strongly recommended.)

orchardist #34 The Orchardist; Amanda Coplin; 448pp; Historical Fiction; July 18; (Excellent novel, set just outside Leavenworth, WA around the end of the 19th Century. Complicated story, which I’ll spoil if I relate too much here. Based around a man who had his own orchard and his life is interrupted and changed forever when two runaway girls enter his land and his life. Definitely a candidate for best book so far this year and highly recommended.)

cutting #36 Cutting for Stone; Abraham Verghese; 688pp; Fiction; July 23; (Wonderful book! Hard to describe the plot without giving away what happens in the book. Written by a surgeon, with lots of factually accurate descriptions of surgeries and medical issues. Follows the life of a family in Addis Ababa in the ’60s and ’70s, with drama and betrayals. Masterfully written, became a two-day page-turner for me after dithering about buying it since it came out. Very strongly recommended.)

technologists #41 The Technologists; Matthew Pearl; 555pp; Historical Fiction; August 17; (I really enjoyed Pearl’s The Dante Club a few years ago so was looking forward to this book. The story is set in 1868 when the first class of M.I.T. is about to graduate. Boston is rocked by a serious of large-scale terrorist acts and some of the M.I.T. students investigate and bring the perpetrator to justice. Excellent novel – recommended.)

djinns #50 City of Djinns; Walter Dalrymple; 352pp; Travel; December 5; (This excellent book covers a year that Dalrymple and his wife lived in Delhi researching the city’s history and meeting people in it. He nicely weaves in the history of the city’s various rulers, conquests, and cultures, while also vividly portraying the people in his life there. I’m looking forward to reading the next book of his on my list, and visiting some of the shrines and forts he describes on our next trip to India.)

monalisa #52 I, Mona Lisa; Jeanne Kalogridis; 544pp; Historical Fiction; December 14; (The novel is set in Florence in the late 1400s, and covers the time around the downfall of the Medicis and the rise and fall of Fra Savonarola. It centers on Madonna Lisa (the subject of da Vinci’s painting), who becomes intricately involved in all the politics and subterfuge of the time. Excellent and recommended.)

amazon #53 Walking the Amazon; Ed Stafford; 320pp; Travel; December 16; (What an incredible journey this guy did! 8000km over more than two years, going through some of the worst jungle on the planet, and all walking. The book’s very well written and conveys the mental and physical adversities Stafford overcame to complete the journey. A great read and inspiring too.)

The Complete List

And the complete list, with links to Amazon so you can explore further.

  1. The Hydrogen Sonata; Iain M. Banks; 517pp; Science Fiction; January 5
  2. Empty Quarter: A Photographic Journey to the Heart of the Arabian Desert; George Steinmetz ; 208pp; Photographic; January 8
  3. Red Mars; Kim Stanley Robinson; 592pp; Science Fiction; January 21
  4. America: Flying High; Jim Wark; 640pp; Photographic; January 30
  5. Great North Road; Peter F. Hamilton; 948pp; Science Fiction; January 31
  6. Stonemouth; Iain Banks; 356pp; Fiction; February 3
  7. Lionheart; Sharon Kay Penman; 608pp; Historical Fiction; March 5
  8. King Hereafter; Dorothy Dunnett; 736pp; Historical Fiction; March 17
  9. Headhunting in the Solomon Islands; Caroline Mytinger; 372pp; Travel; March 28
  10. Elizabeth’s Spymaster: Francis Walsingham and the Secret War that Saved England; Robert Hutchinson; 400pp; History; April 1
  11. An Empire of Wealth: The Epic History of American Economic Power; John Steele Gordon; 496pp; History; April 6
  12. Underwater Eden: 365 Days; Jeff Rotman; 744pp; Photographic; April 20
  13. Do Androids Dream of Electric Sheep?; Philip K. Dick; 244pp; Science Fiction; April 28
  14. The Mongoliad: Book 3; Neal Stephenson et al; 716pp; Historical Fiction; May 13
  15. Burghley: William Cecil at the Court of Elizabeth I; Stephen Alford; 432pp; History; May 21
  16. An American Life; Ronald Reagan; 752pp; Autobiography; May 25
  17. Oracle Bones: A Journey Through Time in China; Peter Hessler; 528pp; Travel; May 27
  18. Absolute Monarchs: A History of the Papacy; John Julius Norwich; 528pp; History; May 30
  19. Among the Russians; Colin Thubron; 224pp; Travel; June 1
  20. In Siberia; Colin Thubron; 304pp; Travel; June 6
  21. The Prince of the Marshes: And Other Occupational Hazards of a Year in Iraq; Rory Stewart; 432pp; Nonfiction; June 9
  22. Secretum; Monalid & Sorti; 812pp; Historical Fiction; June 18
  23. Around India in 80 Trains; Monisha Rajesh; 288pp; Travel; June 25
  24. A Bend in The River; V. S. Naipaul; 288pp; Fiction; June 28
  25. Trespassers On the Roof Of the World: The Race for Lhasa; Peter Hopkirk; 288pp; History; June 29
  26. The Marsh Arabs; Wilfred Thesiger; 256pp; Travel; July 3
  27. To a Mountain in Tibet; Colin Thubron; 220pp; Travel; July 5
  28. American Rust; Philipp Meyer; 384pp; Fiction; July 9
  29. Howards End is On the Landing; Susan Hill; 240pp; Nonfiction; July 12
  30. The Yellow-Lighted Bookshop; Lewis Buzbee; 224pp; Nonfiction; July 13
  31. The Known World; Edward P. Jones; 432pp; Historical Fiction; July 14
  32. Used and Rare: Travels in the Book World; Lawrence & Nancy Goldstone; 224pp; Nonfiction; July 14
  33. Tolstoy and the Purple Chair; Nina Sankovitch; 256pp; Nonfiction; July 17
  34. The Orchardist; Amanda Coplin; 448pp; Historical Fiction; July 18
  35. The Victorian Internet; Tom Standage; 256pp; History; July 19
  36. Cutting for Stone; Abraham Verghese; 688pp; Fiction; July 23
  37. Wuthering Heights; Emily Bronte; 416pp; Fiction; July 25
  38. The Old Curiosity Shop; Charles Dickens; 608pp; Fiction; July 31
  39. South Sea Tales; Jack London; 384pp; Fiction; August 6
  40. Great Expectations; Charles Dickens; 544pp; Fiction; August 11
  41. The Technologists; Matthew Pearl; 555pp; Historical Fiction; August 17
  42. Tess of the d’Urbervilles; Thomas Hardy; 480pp; Historical Fiction; August 24
  43. American Gods; Neil Gaiman; 624pp; Fiction; September 11
  44. Lone Survivor; Marcus Luttrell; 448pp; Nonfiction; October 13
  45. Between the Woods and the Water; Patrick Leigh Fermor; 280pp; Travel; October 26
  46. The Joy Luck Club; Amy Tan; 288pp; Fiction; November 2
  47. Hyperbole and a Half; Allie Brosh; 384pp; Humor; November 6
  48. Seal Team Six; Howard E. Wasdin; 368pp; Nonfiction; November 25
  49. Terra Incognita; Sara Wheeler; 320pp; Travel; November 30
  50. City of Djinns; Walter Dalrymple; 352pp; Travel; December 5
  51. Agincourt; Bernard Cornwell; 380pp; Historical Fiction; December 10
  52. I, Mona Lisa; Jeanne Kalogridis; 544pp; Historical Fiction; December 14
  53. Walking the Amazon; Ed Stafford; 320pp; Travel; December 16
  54. Silent House; Orphan Pamuk; 334pp; Fiction; December 18
  55. Brass Man; Neal Asher; 528pp; Science Fiction; December 24
  56. Polity Agent; Neal Asher; 562pp; Science Fiction; December 30

SQLskills holiday gift to you: all 2012 Insider videos

As we all wind down for the 2013 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’ for all your support during 2013, and what better gift than more free content?!

As many of you know, I publish a bi-weekly newsletter to more than 10,000 subscribers that contains an editorial on a SQL Server topic, a demo video, and a book review of my most recently completed book. We’ve decided to make all the 2012 demo videos available  so everyone can watch them – 25 videos in all, WMV format only. I did the same thing last year with the 2011 videos.

Here are the details:

  1. January 2012: Troubleshooting common VM issues (video)
  2. January 2012: Lecture video on indexing strategies from the MCM series (video)
  3. February 2012: Using the free PAL tool (video)
  4. February 2012: PerfMon tips and tricks (video)
  5. March 2012: Using the free SQL Nexus tool (video | demo code)
  6. March 2012: Using the free Plan Explorer tool (video)
  7. April 2012: Lecture video on snapshot isolation from the MCM series (video)
  8. April 2012: Using the 2012 Extended Events SSMS UI (video)
  9. April 2012: Using the free Process Explorer tool to diagnose CPU usage (video | demo code)
  10. May 2012: Using wait statistics demo from the MCM series (video)
  11. May 2012: Using the SSMS Tools Pack (video)
  12. June 2012: Using semantic search (video | demo code)
  13. June 2012: Using Distributed Replay (part 1) (video)
  14. July 2012: Using Distributed Replay (part 2) (video)
  15. July 2012: Using Distributed Replay (part 3) (video)
  16. August 2012: DBCC CHECKDB and rolled-back transactions (video | demo code)
  17. August 2012: RECOVERY, NORECOVERY, and STANDBY restore options from the MCM series (video)
  18. September 2012: SQL Agent cluster failover (video)
  19. September 2012: Cardinality estimation issues (video | demo code)
  20. October 2012: Setting PerfMon default counters (video)
  21. October 2012: EXECUTE AS and SQL injection from the MCM series (video)
  22. October 2012: Regaining instance access without the sysadmin role (video | demo code)
  23. November 2012: Regaining instance access without downtime (video | demo code)
  24. November 2012: Using Windows Server 2012 Task Manager (video)
  25. December 2012: Indexing strategies from the MCM series (video)

If you want to see the 2013 videos before next December, get all the newsletter back-issues, and follow along as the newsletters come out, just sign-up at http://www.SQLskills.com/Insider. No strings attached, no marketing or advertising, just free content.

Happy Holidays and enjoy the videos!