{"id":700,"date":"2015-09-04T10:06:50","date_gmt":"2015-09-04T17:06:50","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=700"},"modified":"2015-09-04T10:06:50","modified_gmt":"2015-09-04T17:06:50","slug":"dont-hard-boil-your-next-sql-server-upgrade","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/","title":{"rendered":"Don’t Hard Boil Your Next SQL Server Upgrade"},"content":{"rendered":"

SQL Server upgrades and hard-boiled eggs. What do these two things have in common? Probably nothing, but last week Jon and I were having a conversation about an upgrade I need to do for one of our clients. Now I can’t go into specifics because of the NDA, but I can give you some of the pieces:<\/p>\n

It\u2019s a two-node cluster, there are two instances of an older version of SQL Server Standard Edition, they want to upgrade to a recent release of SQL Server, there\u2019s replication involved\u2026and we may or may not reuse the existing servers.<\/p>\n

Now, I like talking through different options for this kind of challenge with someone else on the team, and Jon loves<\/em> this type of thing. I love solving problems, it’s one of my favorite parts of my job. I think that Jon thrives on it. We\u2019ll discuss some project or process and I will have an idea for how to do it, and then three hours later I’ll get another email or a phone call from Jon that starts with, \u201cWell you could also\u2026\u201d<\/p>\n

Our conversation about upgrading was interspersed with a conversation about getting into better shape and eating better (yes I’m usually going in three directions at once, aren’t we all?), and Jon mentioned hard-boiled eggs because they are a good breakfast protein. I asked him if he was still buying them already boiled\u2026because he used to do that. He said no (hooray!), that one of his friends now boils them for him in big batches (nice friend!). Then he mentions how difficult it is to boil eggs.<\/p>\n

And I’m thinking, \u201cAre you kidding me?\u201d He\u2019s one of the smartest people I know and boiling eggs is a challenge? So I sent him the steps below, which is this which is an adaptation of instructions provided in Cook’s Illustrated (great cooking magazine if you\u2019re interested):<\/p>\n

    \n
  1. Place eggs in a large pan and enough cold water so that it\u2019s at least 1\u201d above the eggs. Add a splash of vinegar.<\/li>\n
  2. Place on burner and set to high.<\/li>\n
  3. When the water starts to boil, set a timer for 5 minutes.<\/li>\n
  4. When the timer goes off, turn off the burner, set another timer for 7 minutes, let the eggs sit in the hot water.<\/li>\n
  5. When the timer goes off the second time, drain the hot water, fill with cold water and ice.<\/li>\n
  6. Let sit for a couple minutes, then either drain and put in the fridge, or peel and eat.<\/li>\n<\/ol>\n

    And Jon replies with this (yes I know the image is large, it’s so you don’t have to click on it to read the text! \ud83d\ude42<\/p>\n

    \"Upgrading<\/a>
    Upgrading is easier than boiling eggs<\/figcaption><\/figure>\n

    I laughed. A lot. I was thinking, \u201cI’ll take boiling eggs over an upgrade any day, no matter how much I love SQL Server.\u201d<\/p>\n

    And then yesterday I decided to boil a couple eggs for breakfast. I put them in the pan with plenty of water and a splash of vinegar, turned on the burner, and then went to my office (just 20 feet away) to work on my Insider Video. Forty minutes later (yes, 40) I remembered the eggs. I forgot to set a timer. I always set a timer, but yesterday I just forgot. I ran to the kitchen\u2026there was about an inch of water left in the pan. I was lucky. Nothing destroyed, the eggs were even edible! But here\u2019s the thing\u2026<\/p>\n

    It doesn\u2019t matter how many times you\u2019ve done something before, and how well you know the steps involved and KNOW that they work. Sometimes unexpected events happen or a single step gets missed that causes a problem (or a disaster).<\/p>\n

    Need a real-life example? Jon had a customer that wanted to remove partitioning for a huge table. They had gone through the steps many times in a Test environment, and they were all documented. When it came time to run the process in Production, however, the step to disable the nonclustered indexes on that table before removing partitioning was missed. As a result, the nonclustered indexes (on that extremely large table) were rebuilt three separate times. The step was in the documentation, and had been done during the tests, but for some reason wasn\u2019t done during the process in Production.<\/p>\n

    So back to that upgrade\u2026we\u2019re still planning for it. If I get approval from the customer, I\u2019ll share the details and let you know how it goes. Until then, keep making those checklists and testing your upgrades. You just never know what\u2019s going to happen.<\/p>\n","protected":false},"excerpt":{"rendered":"

    SQL Server upgrades and hard-boiled eggs. What do these two things have in common? Probably nothing, but last week Jon and I were having a conversation about an upgrade I need to do for one of our clients. Now I can’t go into specifics because of the NDA, but I can give you some of […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[],"yoast_head":"\nDon't Hard Boil Your Next SQL Server Upgrade - Erin Stellato<\/title>\n<meta name=\"description\" content=\"Planning a SQL Server upgrade? Read on for some reminders of why checklists and testing are important, but don't always account for everything!\" \/>\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\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Don't Hard Boil Your Next SQL Server Upgrade - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"Planning a SQL Server upgrade? Read on for some reminders of why checklists and testing are important, but don't always account for everything!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-04T17:06:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2015\/09\/photo-577x1024.png\" \/>\n<meta name=\"author\" content=\"Erin Stellato\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Erin Stellato\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/\",\"name\":\"Don't Hard Boil Your Next SQL Server Upgrade - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2015-09-04T17:06:50+00:00\",\"dateModified\":\"2015-09-04T17:06:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"description\":\"Planning a SQL Server upgrade? Read on for some reminders of why checklists and testing are important, but don't always account for everything!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Don’t Hard Boil Your Next SQL Server Upgrade\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\",\"name\":\"Erin Stellato\",\"description\":\"The SQL Sequel\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\",\"name\":\"Erin Stellato\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"caption\":\"Erin Stellato\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/erin\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Don't Hard Boil Your Next SQL Server Upgrade - Erin Stellato","description":"Planning a SQL Server upgrade? Read on for some reminders of why checklists and testing are important, but don't always account for everything!","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\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/","og_locale":"en_US","og_type":"article","og_title":"Don't Hard Boil Your Next SQL Server Upgrade - Erin Stellato","og_description":"Planning a SQL Server upgrade? Read on for some reminders of why checklists and testing are important, but don't always account for everything!","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/","og_site_name":"Erin Stellato","article_published_time":"2015-09-04T17:06:50+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2015\/09\/photo-577x1024.png"}],"author":"Erin Stellato","twitter_misc":{"Written by":"Erin Stellato","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/","name":"Don't Hard Boil Your Next SQL Server Upgrade - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2015-09-04T17:06:50+00:00","dateModified":"2015-09-04T17:06:50+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"description":"Planning a SQL Server upgrade? Read on for some reminders of why checklists and testing are important, but don't always account for everything!","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/dont-hard-boil-your-next-sql-server-upgrade\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"Don’t Hard Boil Your Next SQL Server Upgrade"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/","name":"Erin Stellato","description":"The SQL Sequel","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158","name":"Erin Stellato","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","caption":"Erin Stellato"},"sameAs":["http:\/\/3.209.169.194\/blogs\/erin"],"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/700"}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/comments?post=700"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/700\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}