{"id":1542,"date":"2019-03-14T17:22:35","date_gmt":"2019-03-15T00:22:35","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1542"},"modified":"2020-01-11T12:51:57","modified_gmt":"2020-01-11T20:51:57","slug":"how-to-handle-power-grid-failure","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/","title":{"rendered":"How to Handle Power Grid Failure"},"content":{"rendered":"

<\/h2>\n

The Blizzard<\/span><\/span><\/h2>\n

On March 13-14, 2019, most of eastern Colorado experienced a pretty severe blizzard<\/a>. A blizzard<\/a> is when you have snow combined with sustained winds of 35 mph or more that last for three hours or more. This storm was unusual because it was characterized by extremely low barometric pressure. Lamar, CO had an official reading of 970.4 millibars, which may be the lowest in Colorado history. The lower the barometric pressure, the more severe the storm typically is. A storm like this is more serious when you have a power grid failure.<\/span><\/p>\n

You may have heard this storm called a \u201cbomb cyclone\u201d, which is a reference to bombogenesis<\/a>. Bombogenesis is when you have a pressure drop of at least 24 millibars in 24 hours. The weather station at my house<\/a> recorded a low of 979.3 millibars around 10AM on March 13, 2019. You can convert from inHg to millibars by multiplying inHg times 33.8637526.<\/span><\/p>\n

 <\/span><\/p>\n

<\/h2>\n

My Electric Company<\/span><\/span><\/h2>\n

I get my electricity from Intermountain Rural Electric Association<\/a> (IREA). IREA is an electric distribution cooperative<\/a> that covers 5,000 square miles in Colorado. They buy power from Xcel Energy and the Western Area Power Administration. They also buy some solar power from the 13-megawatt Victory Solar facility<\/a> in Bennett, CO. Unfortunately, they also own 25.3% of Comanche Unit 3 in Pueblo, CO. Comanche Unit 3<\/a> is a 750-megawatt coal-fired generation plant in Pueblo, CO that went online in 2010.<\/span><\/p>\n

I don\u2019t like IREA<\/u><\/strong>. Until recently, they were extremely hostile to renewable energy, especially residential solar PV electricity. Unlike most utility companies, they have never offered any rebates or incentives for energy efficiency upgrades. This includes things like getting energy efficient appliances, upgrading insulation, getting a solar PV system, etc.. None of this is encouraged or incentivized by IREA.<\/span><\/p>\n

IREA also used to include a regular screed in their monthly newsletter about the folly of renewable energy. It was too expensive, it was too unreliable, IREA had a multitude of objections. They have finally stopped doing that, giving in to the changing economics of renewable energy.<\/span><\/span><\/p>\n

 <\/span><\/p>\n

Power Grid Failure<\/span><\/span><\/h2>\n

We lost power twice on March 13, 2019. The first time was for about two hours from about 12PM till 2PM. That was not a big deal. Due to my preparations, we got through that with not much of a problem. The second outage was 16 hours, from about 5PM until about 9:30AM on March 14, 2019. That was less fun, due to the length and the time of day (and night) that it happened.<\/span><\/p>\n

Our house is primarily electric. We do have a natural gas fueled water heater and furnace, which both require electricity to actually operate. They don\u2019t have pilot lights, and you need electricity for the furnace fan and the exhaust vent fan for the water heater.<\/span><\/p>\n

 <\/span><\/p>\n

Residential Solar PV Power<\/span><\/span><\/h2>\n

We have a 9.7KW rooftop grid-tied solar PV system that went into service in July of 2015. It consists of (29) 335 watt SunPower SPR-X21-335 panels connected to two SunPower SMA 5000 TL US 22 inverters (PDF).<\/a> This system has generated 63.5 MWh of electricity so far.<\/span><\/span><\/p>\n

With a typical grid-tied solar PV system, when the public grid goes down, your solar system is automatically shutdown. This happens to avoid backfilling the grid and being a potential safety hazard to utility workers. This means you have no power at all when the public grid is down.<\/span><\/p>\n

You can get special model inverters that have a dedicated “secure power supply” that lets you flip a switch during a power outage. If the sun is up, (after a short delay), you can then pull up to 1500 watts from two dedicated outlets next to each inverter. This would let you run a decent amount of stuff during the day during an extended power outage (like a zombie apocalypse). It would not have helped last night, since it was dark. This video explains how it works:<\/span><\/p>\n

\n

Sunny Boy TL-US Secure Power Supply<\/a><\/span><\/p>\n<\/blockquote>\n

IREA Limitations<\/font><\/font><\/h2>\n

IREA limits you to a 10KW or smaller solar PV system. By Colorado state law<\/a>, IREA has to offer net-metering, which means that when your solar system is producing more electricity than you are using, your electric meter will run backwards. IREA will track your net metering credits (on an annualized basis). They settle up every May, and issue a bill credit for your net metering credit for the year. Settling up in May is the worst time of the year for the consumer, coming pretty soon after winter.<\/span><\/p>\n

IREA charges $10.00 per month to be connected to their system. Our solar PV system generates more electricity than we use just about every month. The exception is December and January, because of the shorter days and the sun being lower in the sky. The annual net metering credit is usually about $90.00, so we usually pay about $30.00\/year for electricity.<\/span><\/p>\n

 <\/span><\/p>\n

Energy Storage<\/span><\/span><\/h2>\n

Even with SPS inverters, residential solar PV by itself will not get you through an extended power outage unless you have storage. You won\u2019t get any solar power production at all during nighttime. Your production will also be lowered by bad weather, especially if you have snow on your panels. So far, I have some very limited energy storage capability. This includes:<\/span><\/p>\n

\n

(3) APC BX1500G<\/a> UPS <\/span><\/p>\n

(2) Cyber-Power LX1500GU<\/a> UPS (two 12V 9.0 Ah batteries)<\/span><\/p>\n

(1) DeWalt DCB1800B Portable Power Station<\/a> (with four 20V 5.0 Ah batteries)<\/span><\/p>\n<\/blockquote>\n

The APC and Cyber-Power UPS units both have about 216 watt hours of storage each. The DeWalt Portable Power Station has about 400 watt hours of storage. This means that I only have about 1480 watt hours total (nearly 1.5 kWh). So, I could run a 1500 watt load for about one hour, or a 100 watt load for about 15 hours. That really isn\u2019t enough capacity for most purposes, but it is better than nothing!<\/span><\/p>\n

 <\/span><\/p>\n

Energy Storage Performance<\/span><\/span><\/h2>\n

In my case, I was able to keep my Arris SB8200<\/a> cable modem and ASUS router going through the entire outage. I was also able to keep our two cell phones charged. We had regular internet until Comcast\u2019s neighborhood equipment probably exhausted their batteries sometime while we were sleeping.<\/span><\/p>\n

Once the sun came up on March 14, I was able to pull power from my SPS outlets on one inverter in order to start charging most of the UPS units and the DeWalt Portable Power Station. I was also able to turn on a small electric heater plugged into the other inverter.<\/span><\/p>\n

 <\/span><\/p>\n

\"Charging<\/a><\/span><\/p>\n

Figure 1: Charging From SPS Outlets<\/strong><\/span><\/p>\n

 <\/span><\/p>\n

Power Grid Restoration<\/font><\/font><\/h2>\n

Luckily, the grid power was restored mid-morning on March 14. If this hadn\u2019t happened, we could have probably limped along for an extended period, not being very comfortable. As it was, our interior house temperature got down to 55 degrees Fahrenheit after 16 hours with no heat. This was while it was 18 degrees Fahrenheit outside. Our house is very well insulated, with R-54 in the ceiling and about R-40 in the walls. We were losing about one degree per hour, which wasn\u2019t too bad.<\/span><\/p>\n

My Tesla Model 3 was sitting in the garage with a fully charged battery. Over time, it would lose its charge since it automatically keeps the battery pack warm enough to protect the batteries. When the house got too cold to bear, we could have slept in the Tesla with the seat heaters on. If I had a long enough heavy-gauge extension cord (which I don\u2019t), I could have also slowly charged the Tesla from the SPS outlet during daylight hours. Officially, you are NOT supposed to use any type of extension cord to charge a Tesla.<\/span><\/p>\n

 <\/span><\/p>\n

Lessons Learned<\/span><\/span><\/h2>\n

Well, I don\u2019t have enough energy storage to deal with an extended outage, especially during a blizzard in the winter. I knew that, but this experience reinforced that knowledge. I can keep a small amount of electronics going during the night, and recharge my storage during the day. I also have enough power generation during the day to do a little bit of electrical heating. But that isn\u2019t enough to stay very comfortable.<\/span><\/p>\n

On the other hand, my current setup can deal very well with short electrical outages. All of the UPS units are mainly there for surge protection and line conditioning. The battery capacity is just a small bonus. So what can I do about this? <\/span><\/span><\/p>\n


<\/span><\/span><\/p>\n

<\/span><\/span><\/h2>\n

Long Term Solutions<\/font><\/font><\/h2>\n

The cheapest solution would be a gasoline powered generator, hooked up to a transfer switch. But then I would have to be storing gasoline, and rotating it to keep it from going bad. Plus, I would probably only have a few gallons on hand. I could also siphon gasoline from my wife\u2019s car, but her tank is only about 13 gallons.<\/span><\/p>\n

Another solution would be a natural gas powered generator from somebody like Generac<\/a>. This would work as long as you had natural gas.<\/span><\/p>\n

\"Generac\"<\/a><\/span><\/p>\n

Figure 2: Generac Guardian<\/strong><\/span><\/p>\n

 <\/span><\/p>\n

The high-tech, expensive solution is a couple of Tesla Powerwall 2<\/a> units. These are 13.5 kWh battery packs with their own inverters. You can use these with or without solar PV. If you have solar PV, it will charge the Powerwall(s) first, before going back to the public grid. When the public grid goes down, you automatically pull energy from the Powerwall until it is exhausted. If you have solar PV, you will run off of that during the day, and then draw from the Powerwall during the night. This would be the most environmentally friendly solution, which is important to me.<\/span><\/p>\n

 <\/span><\/p>\n

\"support-backup-whole-essential_installation-02.jpg\"<\/a><\/span><\/p>\n

Figure 3: Tesla Powerwall 2<\/strong><\/span><\/p>\n

 <\/span><\/p>\n

Figure 4 shows how this works.<\/span><\/p>\n

\"powerwall_energy_consumption\"<\/a><\/span><\/p>\n

Figure 4: Solar PV and Powerwall<\/strong><\/span><\/p>\n

 <\/span><\/p>\n

The Tesla app that I already use for my car also lets you monitor your solar system and your Powerwall units.<\/span><\/p>\n

\"Tesla<\/a><\/span><\/strong><\/p>\n

Figure 5: Tesla App for Powerwall<\/span><\/strong><\/p>\n

 <\/span><\/p>\n

Conclusion<\/span><\/span><\/h2>\n

This was an interesting, if slightly uncomfortable experience. It was short enough that we did not get truly cold, and we did not lose the food in our refrigerator and freezer. It proved that my limited preparation so far can handle relatively short outages but not longer outages. This is especially true during a winter blizzard which limits your solar production during the day. I also got some real-world experience with how the SPS circuit works.<\/span><\/p>\n

I am going to make a few small changes and improvements to my current setup, and then decide what I want to do for a much better setup that can handle a longer grid outage. Just like with SQL Server, going through an actual outage teaches you how resilient your system actually is. It also shows where you have room for improvement.<\/span><\/p>\n

 <\/span><\/p>\n

 <\/span><\/p>\n

 <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

The Blizzard On March 13-14, 2019, most of eastern Colorado experienced a pretty severe blizzard. A blizzard is when you have snow combined with sustained winds of 35 mph or more that last for three hours or more. This storm was unusual because it was characterized by extremely low barometric pressure. Lamar, CO had an […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[431],"class_list":["post-1542","post","type-post","status-publish","format-standard","hentry","category-sql-server-high-availability","tag-tesla-powerwall"],"yoast_head":"\nHow to Handle Power Grid Failure - Glenn Berry<\/title>\n<meta name=\"description\" content=\"Glenn Berry describes different ways to handle a power grid failure, including solar PV systems, power storage, generators, and Tesla Powerwalls\" \/>\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\/glenn\/how-to-handle-power-grid-failure\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Handle Power Grid Failure - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Glenn Berry describes different ways to handle a power grid failure, including solar PV systems, power storage, generators, and Tesla Powerwalls\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-15T00:22:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-11T20:51:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/Charging-from-SPS_thumb.jpg\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/\",\"name\":\"How to Handle Power Grid Failure - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/Charging-from-SPS_thumb.jpg\",\"datePublished\":\"2019-03-15T00:22:35+00:00\",\"dateModified\":\"2020-01-11T20:51:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"description\":\"Glenn Berry describes different ways to handle a power grid failure, including solar PV systems, power storage, generators, and Tesla Powerwalls\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/Charging-from-SPS_thumb.jpg\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/Charging-from-SPS_thumb.jpg\",\"width\":1028,\"height\":687},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Handle Power Grid Failure\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Handle Power Grid Failure - Glenn Berry","description":"Glenn Berry describes different ways to handle a power grid failure, including solar PV systems, power storage, generators, and Tesla Powerwalls","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\/glenn\/how-to-handle-power-grid-failure\/","og_locale":"en_US","og_type":"article","og_title":"How to Handle Power Grid Failure - Glenn Berry","og_description":"Glenn Berry describes different ways to handle a power grid failure, including solar PV systems, power storage, generators, and Tesla Powerwalls","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/","og_site_name":"Glenn Berry","article_published_time":"2019-03-15T00:22:35+00:00","article_modified_time":"2020-01-11T20:51:57+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/Charging-from-SPS_thumb.jpg","type":"","width":"","height":""}],"author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/","name":"How to Handle Power Grid Failure - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/Charging-from-SPS_thumb.jpg","datePublished":"2019-03-15T00:22:35+00:00","dateModified":"2020-01-11T20:51:57+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"description":"Glenn Berry describes different ways to handle a power grid failure, including solar PV systems, power storage, generators, and Tesla Powerwalls","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/Charging-from-SPS_thumb.jpg","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/Charging-from-SPS_thumb.jpg","width":1028,"height":687},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-handle-power-grid-failure\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"How to Handle Power Grid Failure"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1542","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=1542"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1542\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}