{"id":4669,"date":"2016-12-29T04:44:37","date_gmt":"2016-12-29T12:44:37","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4669"},"modified":"2019-12-30T17:34:59","modified_gmt":"2019-12-31T01:34:59","slug":"2016-review-the-year-by-the-numbers","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/","title":{"rendered":"2016 review: the year by the numbers"},"content":{"rendered":"<p>The last post of the year! It\u2019s 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.<\/p>\n<ul>\n<li>125,402: the number of miles I flew on United<\/li>\n<li>34,085: my current tweet total (up 772\u00a0from 2015)<\/li>\n<li>13,434: the number of subscribers to our\u00a0<a href=\"http:\/\/www.sqlskills.com\/joincommunity.asp\" target=\"_blank\" rel=\"noopener noreferrer\">Insider<\/a>\u00a0mailing list (up 493\u00a0from 2015)<\/li>\n<li>12,168: the number of people who follow my Twitter ramblings (up 1,325\u00a0from 2015)<\/li>\n<li>8,798: the number of emails I sent (down 3,025\u00a0from 2015 &#8211; this is a good thing!)<\/li>\n<li>1,779: the number of books (real ones) that I own (up 176 from 2015)<\/li>\n<li>998: the number of books I own but haven\u2019t read yet (up 130\u00a0from 2015)<\/li>\n<li>286: the number of SQL Server wait types I have documented in my <a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/announcing-the-comprehensive-sql-server-wait-types-and-latch-classes-library\/\" target=\"_blank\" rel=\"noopener noreferrer\">Wait Types Library<\/a><\/li>\n<li>184: the number of nights away from home (up 36 from 2015, and all with Kimberly, so not *too* bad)<\/li>\n<li>149: the total number of hours of online training we have available on Pluralsight<\/li>\n<li>127: the number of dives I will have completed by 12\/31, all in Indonesia, taking my total to 653<\/li>\n<li>91: the number of minutes of my longest dive this year<\/li>\n<li>60: the number of days in Immersion Events and conferences<\/li>\n<li>50.41: the percentage of time we were away from home (which is why we call it our vacation home!)<\/li>\n<li>49: the number of Pluralsight courses we have available<\/li>\n<li>45: the number of books I read (see <a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/2015-the-year-in-books\/\" target=\"_blank\" rel=\"noopener noreferrer\">this post<\/a>)<\/li>\n<li>42: the number of flights this year (same as last year)<\/li>\n<li>42: the answer to the question of life, the universe, and everything!<\/li>\n<li>30: the number of different places we slept apart from our house and on planes<\/li>\n<li>25: the number of SQLskills blog posts, including this one<\/li>\n<li>22: the number of airports I flew through this year<\/li>\n<li>12: the number of new bird species I saw, taking my total to\u00a0511<\/li>\n<li>12: the number of monthly magazines I subscribe to<\/li>\n<li>9: the number of years I\u2019ve been married to Kimberly<\/li>\n<li>8: the number of different octopus species we saw in Indonesia (coconut, algae, reef, blue-ring, starry-night, mimic, wonderpus, long-arm)<\/li>\n<li>7: the number of countries we visited this year<\/li>\n<li>2: the number of new airports I flew through (Manado and Lubuan Bajo, both in Indonesia), taking my total to 91<\/li>\n<li>2: the number of\u00a0new countries I visited (Sweden and Finland), taking my total to 38<\/li>\n<li>2: the number of awesome daughters we have<\/li>\n<li>1: the number of new airlines I flew on (Silk Air, based in Singapore), taking my total to 35<\/li>\n<li>1: the person who seems to cram the most into non-work time (farming, scouts, PokemonGo, building, &#8230;): Tim Radney<\/li>\n<li>1: the person who is the best at snapping her fingers and ran a marathon this year: Erin Stellato<\/li>\n<li>1: the number of Jonathan Kehayias in the world &#8211; thankfully :-)<\/li>\n<li>1: the number of indispensable assistants, without whom our lives would be a distressing quagmire \u2013 Libby we love you!<\/li>\n<li>Finally, the one and only best person in my life: Kimberly, without whom I would be lost\u2026<\/li>\n<\/ul>\n<p><strong>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.<\/strong><\/p>\n<p><strong>I sincerely wish you all a happy, healthy, and prosperous New Year!<\/strong><\/p>\n<p><strong>Cheers!<\/strong><\/p>\n<p>(The whole team with all their kids after watching\/helping\u00a0Jonathan propose to Kristi at The Bean in Chicago in May)<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-large wp-image-4670\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o-1024x682.jpg\" alt=\"13115976_10154219508810452_5222187169913779670_o\" width=\"1024\" height=\"682\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o-1024x682.jpg 1024w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o-300x200.jpg 300w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o-900x600.jpg 900w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o.jpg 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>(With our wonderful girls in Longyearbyen on Svalbard in August)<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13891800_10210085606158681_1177987796550152003_n.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4672\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13891800_10210085606158681_1177987796550152003_n.jpg\" alt=\"13891800_10210085606158681_1177987796550152003_n\" width=\"960\" height=\"720\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13891800_10210085606158681_1177987796550152003_n.jpg 960w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13891800_10210085606158681_1177987796550152003_n-300x225.jpg 300w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13891800_10210085606158681_1177987796550152003_n-900x675.jpg 900w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/a><\/p>\n<p>(At about 80 degrees north, next to the\u00a07th largest ice cap in the world (Austfonna on the island of Nordaustlandet in the Svalbard archipelago) a couple of weeks later, at about 10pm. The ambient temperature is just above freezing, with a gentle katabatic wind coming off the ice, and I&#8217;m in shorts and a t-shirt &#8211; I don&#8217;t get cold!)<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/14324161_10210471030954060_4900316199109940557_o.jpg\"><img decoding=\"async\" class=\"alignnone size-large wp-image-4673\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/14324161_10210471030954060_4900316199109940557_o-1024x683.jpg\" alt=\"14324161_10210471030954060_4900316199109940557_o\" width=\"1024\" height=\"683\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/14324161_10210471030954060_4900316199109940557_o-1024x683.jpg 1024w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/14324161_10210471030954060_4900316199109940557_o-300x200.jpg 300w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/14324161_10210471030954060_4900316199109940557_o-900x600.jpg 900w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/14324161_10210471030954060_4900316199109940557_o.jpg 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The last post of the year! It\u2019s 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. 125,402: the number of miles I flew on United 34,085: my current tweet total (up 772\u00a0from 2015) 13,434: the number of subscribers [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67],"tags":[],"class_list":["post-4669","post","type-post","status-publish","format-standard","hentry","category-personal"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>2016 review: the year by the numbers - Paul S. Randal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2016 review: the year by the numbers - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"The last post of the year! It\u2019s 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. 125,402: the number of miles I flew on United 34,085: my current tweet total (up 772\u00a0from 2015) 13,434: the number of subscribers [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-29T12:44:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-31T01:34:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o-1024x682.jpg\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/\",\"name\":\"2016 review: the year by the numbers - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o-1024x682.jpg\",\"datePublished\":\"2016-12-29T12:44:37+00:00\",\"dateModified\":\"2019-12-31T01:34:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o.jpg\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o.jpg\",\"width\":1280,\"height\":853},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"2016 review: the year by the numbers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"2016 review: the year by the numbers - Paul S. Randal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/","og_locale":"en_US","og_type":"article","og_title":"2016 review: the year by the numbers - Paul S. Randal","og_description":"The last post of the year! It\u2019s 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. 125,402: the number of miles I flew on United 34,085: my current tweet total (up 772\u00a0from 2015) 13,434: the number of subscribers [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/","og_site_name":"Paul S. Randal","article_published_time":"2016-12-29T12:44:37+00:00","article_modified_time":"2019-12-31T01:34:59+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o-1024x682.jpg","type":"","width":"","height":""}],"author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/","name":"2016 review: the year by the numbers - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o-1024x682.jpg","datePublished":"2016-12-29T12:44:37+00:00","dateModified":"2019-12-31T01:34:59+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o.jpg","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2016\/12\/13115976_10154219508810452_5222187169913779670_o.jpg","width":1280,"height":853},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/2016-review-the-year-by-the-numbers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"2016 review: the year by the numbers"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=4669"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4669\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4669"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}