Warning: Constant WP_TEMP_DIR already defined in /var/www/html/blogs/glenn/wp-config.php on line 94

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902
{"id":1326,"date":"2018-01-09T10:37:52","date_gmt":"2018-01-09T18:37:52","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1326"},"modified":"2018-01-11T13:02:47","modified_gmt":"2018-01-11T21:02:47","slug":"performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/","title":{"rendered":"Performance Effects of Meltdown and Partial Spectre Fixes on Intel Core i7-7500U Laptop"},"content":{"rendered":"

I have a fairly recent vintage HP Spectre x360-13w023dx laptop (slightly over a year old) that has an Intel Core i7-7500U<\/a> (Kaby Lake-U) processor, 16GB of DDR4 RAM, and a 512GB Samsung PM961 M.2 NVMe SSD that is running Windows 10 Professional Version 1709.<\/font><\/p>\n

Last night, I installed the Windows 10 January 2018 Security Update (KB4056892) on this system, and then used PowerShell to check my status, with the results as shown in Figure 1. These are the relevant results:<\/font><\/p>\n

Speculation control settings for CVE-2017-5715 [branch target injection] (This is Spectre variant 2)<\/strong><\/font><\/p>\n

\n

Hardware support for branch target injection mitigation is present: False<\/font><\/p>\n

Windows OS support for branch target injection mitigation is present: True<\/font><\/p>\n

Windows OS support for branch target injection mitigation is enabled: False<\/font><\/p>\n

Windows OS support for branch target injection mitigation is disabled by system policy: False<\/font><\/p>\n

Windows OS support for branch target injection mitigation is disabled by absence of hardware support: True<\/font><\/p>\n<\/blockquote>\n

Speculation control settings for CVE-2017-5754 [rogue data cache load] (This is Meltdown)<\/strong><\/font><\/p>\n

\n

Hardware requires kernel VA shadowing: True<\/font><\/p>\n

Windows OS support for kernel VA shadow is present: True<\/font><\/p>\n

Windows OS support for kernel VA shadow is enabled: True<\/font><\/p>\n

Windows OS support for PCID performance optimization is enabled: True [not required for security]<\/font><\/p>\n<\/blockquote>\n

Suggested actions<\/font><\/p>\n

\n

* Install BIOS\/firmware update provided by your device OEM that enables hardware support for the branch target injection mitigation mitigation<\/font><\/p>\n<\/blockquote>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

\"image\"<\/a><\/p>\n

Figure 1: After Windows 10 Security Update, but before BIOS Update<\/strong><\/font><\/p>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

After I had installed the Windows 10 January 2018 Security Update (KB4056892) on this system, I ran both the CPU-Z 1.82.1 CPU benchmark and the CrystalDiskMark 6.0.0 synthetic disk benchmark three times, to get a performance baseline before I installed the new BIOS (that has the microcode update to enable the Spectre variant 2 fixes). Some results from these test runs are shown in Figures 3 and 5 below.<\/font><\/p>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

Following Microsoft\u2019s guidance, I located and installed the latest BIOS for my HP Spectre x360 laptop, which is version F.42. Then, I again used PowerShell to check my status, with the results as shown in Figure 2. These are the relevant results:<\/font><\/p>\n

Speculation control settings for CVE-2017-5715 [branch target injection] (This is Spectre variant 2)<\/strong><\/font><\/p>\n

\n

Hardware support for branch target injection mitigation is present: True<\/font><\/p>\n

Windows OS support for branch target injection mitigation is present: True<\/font><\/p>\n

Windows OS support for branch target injection mitigation is enabled: True<\/font><\/p>\n<\/blockquote>\n

Speculation control settings for CVE-2017-5754 [rogue data cache load] (This is Meltdown)<\/strong><\/font><\/p>\n

\n

Hardware requires kernel VA shadowing: True<\/font><\/p>\n

Windows OS support for kernel VA shadow is present: True<\/font><\/p>\n

Windows OS support for kernel VA shadow is enabled: True<\/font><\/p>\n

Windows OS support for PCID performance optimization is enabled: True [not required for security]<\/font><\/p>\n<\/blockquote>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

\"image\"<\/a><\/p>\n

Figure 2: After Windows 10 Security Update and BIOS Update<\/strong><\/font><\/p>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

Figure 3 shows one of the CPU-Z 1.82.1 benchmark run results before the BIOS update, showing a CPU Single Thread score of 373.9, and a CPU Multi Thread score of 1000.2.<\/font><\/p>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

\"image\"<\/a><\/p>\n

Figure 3: After Windows 10 Security Update, but before BIOS Update<\/strong><\/font><\/p>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

Figure 4 shows one of the CPU-Z 1.82.1 benchmark run results after<\/u><\/strong> the BIOS update, showing a CPU Single Thread score of 317.5, and a CPU Multi Thread score of 971.8. That is about a 15.1% reduction in single-threaded CPU performance and a 2.8% reduction in multi-threaded CPU performance, at least on this quick synthetic CPU benchmark.<\/font><\/p>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

\"image\"<\/a><\/p>\n

Figure 4: After Windows 10 Security Update and BIOS Update<\/strong><\/font><\/p>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

Figure 5 shows one of the CrystalDiskMark 6.0.0 benchmark run results before the BIOS update.<\/font><\/p>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

\"image\"<\/a><\/p>\n

Figure 5: After Windows 10 Security Update, but before BIOS Update<\/strong><\/font><\/p>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

Figure 6 shows one of the CrystalDiskMark 6.0.0 benchmark run results after<\/u><\/strong> the BIOS update.<\/font><\/p>\n

<\/font><\/strong><\/p>\n


\n<\/font><\/strong><\/p>\n

<\/font><\/strong><\/p>\n

\"image\"<\/a><\/p>\n

Figure 6: After Windows 10 Security Update and BIOS Update<\/strong><\/font><\/p>\n

<\/font><\/p>\n


\n<\/font><\/p>\n

<\/font><\/p>\n

What these limited synthetic benchmark test results show is that installing the CPU microcode updates (which are a required part of the Spectre variant 2 fix) seems to have a pretty significant effect on single-threaded CPU performance in the CPU-Z benchmark. We also see a very significant effect on random I\/O performance in CrystalDiskMark 6.0.0 using the default test settings with a 4GB test file.<\/font><\/p>\n

Microsoft\u2019s Terry Myerson has a pretty detailed post on this subject<\/font><\/p>\n

\n

Understanding the performance impact of Spectre and Meltdown mitigations on Windows Systems<\/a><\/font><\/p>\n<\/blockquote>\n

Intel has published some client benchmark results for 6th, 7th, and 8th Generation Core processors, as shown here:<\/font><\/p>\n

\n

Intel Security Issue Update: Initial Performance Data Results for Client Systems<\/a><\/font><\/p>\n<\/blockquote>\n

\n


<\/font><\/p>\n


<\/font><\/p>\n<\/blockquote>\n

<\/font><\/strong><\/p>\n


\n<\/font><\/strong><\/p>\n

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

I have a fairly recent vintage HP Spectre x360-13w023dx laptop (slightly over a year old) that has an Intel Core i7-7500U (Kaby Lake-U) processor, 16GB of DDR4 RAM, and a 512GB Samsung PM961 M.2 NVMe SSD that is running Windows 10 Professional Version 1709. Last night, I installed the Windows 10 January 2018 Security Update […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,368,21,24,343],"tags":[366,367],"class_list":["post-1326","post","type-post","status-publish","format-standard","hentry","category-intel","category-kaby-lake","category-microsoft","category-processors","category-security","tag-meltdown","tag-spectre"],"yoast_head":"\nPerformance Effects of Meltdown and Partial Spectre Fixes on Intel Core i7-7500U Laptop - Glenn Berry<\/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\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performance Effects of Meltdown and Partial Spectre Fixes on Intel Core i7-7500U Laptop - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"I have a fairly recent vintage HP Spectre x360-13w023dx laptop (slightly over a year old) that has an Intel Core i7-7500U (Kaby Lake-U) processor, 16GB of DDR4 RAM, and a 512GB Samsung PM961 M.2 NVMe SSD that is running Windows 10 Professional Version 1709. Last night, I installed the Windows 10 January 2018 Security Update […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-09T18:37:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-01-11T21:02:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/01\/image_thumb-1.png\" \/>\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=\"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\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/\",\"name\":\"Performance Effects of Meltdown and Partial Spectre Fixes on Intel Core i7-7500U Laptop - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/01\/image_thumb-1.png\",\"datePublished\":\"2018-01-09T18:37:52+00:00\",\"dateModified\":\"2018-01-11T21:02:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/01\/image_thumb-1.png\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/01\/image_thumb-1.png\",\"width\":644,\"height\":410},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance Effects of Meltdown and Partial Spectre Fixes on Intel Core i7-7500U Laptop\"}]},{\"@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":"Performance Effects of Meltdown and Partial Spectre Fixes on Intel Core i7-7500U Laptop - Glenn Berry","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\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/","og_locale":"en_US","og_type":"article","og_title":"Performance Effects of Meltdown and Partial Spectre Fixes on Intel Core i7-7500U Laptop - Glenn Berry","og_description":"I have a fairly recent vintage HP Spectre x360-13w023dx laptop (slightly over a year old) that has an Intel Core i7-7500U (Kaby Lake-U) processor, 16GB of DDR4 RAM, and a 512GB Samsung PM961 M.2 NVMe SSD that is running Windows 10 Professional Version 1709. Last night, I installed the Windows 10 January 2018 Security Update […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/","og_site_name":"Glenn Berry","article_published_time":"2018-01-09T18:37:52+00:00","article_modified_time":"2018-01-11T21:02:47+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/01\/image_thumb-1.png","type":"","width":"","height":""}],"author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/","name":"Performance Effects of Meltdown and Partial Spectre Fixes on Intel Core i7-7500U Laptop - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/01\/image_thumb-1.png","datePublished":"2018-01-09T18:37:52+00:00","dateModified":"2018-01-11T21:02:47+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/01\/image_thumb-1.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/01\/image_thumb-1.png","width":644,"height":410},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/performance-effects-of-meltdown-and-partial-spectre-fixes-on-intel-core-i7-7500u-laptop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Performance Effects of Meltdown and Partial Spectre Fixes on Intel Core i7-7500U Laptop"}]},{"@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\/1326","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=1326"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1326\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}