{"id":5022,"date":"2019-11-23T14:59:14","date_gmt":"2019-11-23T22:59:14","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=5022"},"modified":"2019-11-24T12:24:36","modified_gmt":"2019-11-24T20:24:36","slug":"the-curious-case-of-the-failing-sql-server-2019-install","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/","title":{"rendered":"The Curious Case of&#8230; the failing SQL Server 2019 install"},"content":{"rendered":"<p style=\"text-align: justify;\"><em>(The Curious Case of\u2026<\/em>\u00a0used to be part of our bi-weekly\u00a0<a href=\"https:\/\/www.sqlskills.com\/join-the-sqlskills-insider-community\/\" target=\"_blank\" rel=\"noopener noreferrer\">newsletter<\/a>\u00a0but we decided to make it a\u00a0regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.)<\/p>\n<p style=\"text-align: justify;\">This time the Curious Case is about something that happened to me: a failing SQL Server 2019 install.<\/p>\n<p style=\"text-align: justify;\">I have a brand new Windows 10 laptop that I use solely for teaching, as the HDMI and SVGA connectors on my main laptop somehow have bad connections to the motherboard after a few years of traveling around the world. On the new laptop I have SQL Server 2017, and now that SQL Server 2019 RTM has shipped, and I&#8217;ve finished teaching for the year, I set out to install 2019 side-by-side with 2017 so I can move my teaching environment to 2019 and work on demos of the new features pertinent to what I teach.<\/p>\n<p style=\"text-align: justify;\">Thinking this would be a smooth process, I kicked off the install wizard, went through it, hit go, and walked away. I came back half an hour later to see that all install steps had failed. I thought maybe it was some dependency issue, so did it all again, hit go and watched. Almost instant failure again.<\/p>\n<p style=\"text-align: justify;\">The setup summary had this really unhelpful summary:<\/p>\n<pre class=\"brush: plain; gutter: false; title: ; toolbar: true; wrap-lines: true; notranslate\" title=\"\">\r\nOverall summary:\r\nFinal result: Failed: see details below\r\nExit code (Decimal): -2068643839\r\nStart time: 2019-11-23 14:27:14\r\nEnd time: 2019-11-23 14:30:28\r\nRequested action: Install\r\n\r\nSetup completed with required actions for features.\r\nTroubleshooting information for those features:\r\nNext step for sql_inst_java: Use the following information to resolve the error, and then try the setup process again.\r\nNext step for sql_inst_mpy: Use the following information to resolve the error, and then try the setup process again.\r\nNext step for sql_inst_mr: Use the following information to resolve the error, and then try the setup process again.\r\nNext step for AdvancedAnalytics: Use the following information to resolve the error, and then try the setup process again.\r\nNext step for SQLEngine: Use the following information to resolve the error, and then try the setup process again.\r\nNext step for Replication: Use the following information to resolve the error, and then try the setup process again.\r\nNext step for SNAC_SDK: Use the following information to resolve the error, and then try the setup process again.\r\n<\/pre>\n<p style=\"text-align: justify;\">So I dug in to the <em>Detail.txt<\/em> file in <em>C:\\Program Files\\Microsoft SQL Server\\150\\Setup Bootstrap\\Log\\20191123_142713<\/em> and eventually found the first thing that failed:<\/p>\n<pre class=\"brush: plain; gutter: false; title: ; toolbar: true; wrap-lines: true; notranslate\" title=\"\">\r\n(01) 2019-11-23 14:30:23 Slp: Running Action: Install_sqlncli_Cpu64_Action\r\n(01) 2019-11-23 14:30:23 Slp: SetFeaturePropsModifyInstallAction for sqlncli_Cpu64 \r\n(01) 2019-11-23 14:30:23 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine \r\n(01) 2019-11-23 14:30:23 Slp: Sco: Attempting to open registry subkey \r\n(01) 2019-11-23 14:30:23 Slp: Sco: Attempting to open registry subkey SOFTWARE\\Microsoft\\Microsoft SQL Server\\RefCount\\SNAC11\r\n(01) 2019-11-23 14:30:23 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine \r\n(01) 2019-11-23 14:30:23 Slp: Sco: Attempting to open registry subkey \r\n(01) 2019-11-23 14:30:23 Slp: Sco: Attempting to open registry subkey SOFTWARE\\Microsoft\\VisualStudio\\14.0\r\n(01) 2019-11-23 14:30:23 Slp: Sco: Attempting to get registry value InstallDir\r\n(01) 2019-11-23 14:30:23 Slp: Checkpoint: PREINSTALL_SQLNCLI_CPU64_ACTION\r\n(01) 2019-11-23 14:30:23 Slp: Sco: Waiting for service 'msiserver' to accept the stop request.\r\n(01) 2019-11-23 14:30:23 Slp: Sco: Attempting to open SC Manager\r\n(01) 2019-11-23 14:30:23 Slp: Sco: Attempting to open service handle for service msiserver\r\n(01) 2019-11-23 14:30:23 Slp: Invoking QueryServiceStatus Win32 API\r\n(01) 2019-11-23 14:30:23 Slp: Sco: Attempting to close service handle for service msiserver\r\n(01) 2019-11-23 14:30:23 Slp: Sco: Attempting to close SC Manager\r\n(01) 2019-11-23 14:30:23 Slp: Target package: &quot;E:\\1033_ENU_LP\\x64\\setup\\x64\\sqlncli.msi&quot;\r\n(01) 2019-11-23 14:30:23 Slp: InstallPackage: MsiInstallProduct returned the result code 1602.\r\n(01) 2019-11-23 14:30:23 Slp: No retry-able MSI return code detected.\r\n(01) 2019-11-23 14:30:23 Slp: ExecuteActionWithRetryHelper.Failed actionToExecute is 'Install_sqlncli_Cpu64_Action', stack trace    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.&lt;&gt;c__DisplayClass2_0.&lt;ExecuteActionWithRetryHelper&gt;b__0()\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.&lt;&gt;c__DisplayClass2_0.&lt;ExecuteActionWithRetryHelper&gt;b__0()\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.&lt;&gt;c__DisplayClass2_0.&lt;ExecuteActionWithRetryHelper&gt;b__0()\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.&lt;&gt;c__DisplayClass2_0.&lt;ExecuteActionWithRetryHelper&gt;b__0()\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Chainer.Setup.Setup.RunRequestedWorkflow()\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Chainer.Setup.Setup.Run(String&#x5B;] args)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Chainer.Setup.Setup.Start(String&#x5B;] args)\r\n(01) 2019-11-23 14:30:23 Slp:    at Microsoft.SqlServer.Chainer.Setup.Setup.Main()\r\n(01) 2019-11-23 14:30:23 Slp: Error: Action &quot;Install_sqlncli_Cpu64_Action&quot; failed during execution.\r\n<\/pre>\n<p style=\"text-align: justify;\">And this caused everything else to fail.<\/p>\n<p style=\"text-align: justify;\">I went to Control Panel and looked in Apps and Features, and found Microsoft SQL Server 2012 Native Client. Thinking this was likely the issue, I de-installed it and ran 2019 setup again. Bingo! No problems this time.<\/p>\n<p style=\"text-align: justify;\">I did a bit of poking around online and\u00a0it&#8217;s a known issue that&#8217;s described in the 2019 release notes &#8211; see <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/SQL-Server-Support\/SQL-Server-2019-Installation-Error-An-error-occurred-for-a\/ba-p\/998033\" target=\"_blank\" rel=\"noopener noreferrer\">this Microsoft blog post<\/a>.<\/p>\n<p style=\"text-align: justify;\">PS Don&#8217;t forget to install the <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/4517790\/servicing-update-for-sql-server-2019-rtm\" target=\"_blank\" rel=\"noopener noreferrer\">GDR hotf<\/a>ix after installing 2019!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>(The Curious Case of\u2026\u00a0used to be part of our bi-weekly\u00a0newsletter\u00a0but we decided to make it a\u00a0regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) This time the [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[117],"tags":[],"class_list":["post-5022","post","type-post","status-publish","format-standard","hentry","category-sql-server-2019"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The Curious Case of... the failing SQL Server 2019 install - 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\/the-curious-case-of-the-failing-sql-server-2019-install\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Curious Case of... the failing SQL Server 2019 install - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"(The Curious Case of\u2026\u00a0used to be part of our bi-weekly\u00a0newsletter\u00a0but we decided to make it a\u00a0regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) This time the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-23T22:59:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-24T20:24:36+00:00\" \/>\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=\"6 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\/the-curious-case-of-the-failing-sql-server-2019-install\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/\",\"name\":\"The Curious Case of... the failing SQL Server 2019 install - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2019-11-23T22:59:14+00:00\",\"dateModified\":\"2019-11-24T20:24:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Curious Case of&#8230; the failing SQL Server 2019 install\"}]},{\"@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":"The Curious Case of... the failing SQL Server 2019 install - 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\/the-curious-case-of-the-failing-sql-server-2019-install\/","og_locale":"en_US","og_type":"article","og_title":"The Curious Case of... the failing SQL Server 2019 install - Paul S. Randal","og_description":"(The Curious Case of\u2026\u00a0used to be part of our bi-weekly\u00a0newsletter\u00a0but we decided to make it a\u00a0regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) This time the [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/","og_site_name":"Paul S. Randal","article_published_time":"2019-11-23T22:59:14+00:00","article_modified_time":"2019-11-24T20:24:36+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/","name":"The Curious Case of... the failing SQL Server 2019 install - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2019-11-23T22:59:14+00:00","dateModified":"2019-11-24T20:24:36+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/the-curious-case-of-the-failing-sql-server-2019-install\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"The Curious Case of&#8230; the failing SQL Server 2019 install"}]},{"@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\/5022","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=5022"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/5022\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=5022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=5022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=5022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}