{"id":518,"date":"2011-08-05T00:25:19","date_gmt":"2011-08-05T00:25:19","guid":{"rendered":"\/blogs\/jonathan\/post\/Running-Paule28099s-nonclustered-index-count-survey-against-multiple-instances.aspx"},"modified":"2013-01-03T01:48:26","modified_gmt":"2013-01-03T06:48:26","slug":"running-pauls-nonclustered-index-count-survey-against-multiple-instances","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/","title":{"rendered":"Running Paul\u2019s nonclustered index count survey against multiple instances"},"content":{"rendered":"<p>Paul put up a new survey today titled <a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/survey-nonclustered-index-counts-code-to-run\/\">Survey: nonclustered index counts (code to run)<\/a>.&#160; If you\u2019d like to run the query for this survey against multiple SQL Servers at once using PowerShell here is the script to do it:<\/p>\n<blockquote>\n<pre><span style=\"color: #008000\">#<\/span><span style=\"color: #008000\"> Load the Snapins for SqlServer if they aren't currently loaded <\/span><span style=\"color: #008000\">\r\n<\/span><span style=\"color: #0000ff\">if<\/span><span style=\"color: #000000\">((<\/span><span style=\"color: #5f9ea0; font-weight: bold\">Get-PSSnapin<\/span><span style=\"color: #000000\"> <\/span><span style=\"font-style: italic; color: #5f9ea0\">-Name<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #800000\">SqlServerCmdletSnapin100<\/span><span style=\"color: #000000\"> <\/span><span style=\"font-style: italic; color: #5f9ea0\">-ErrorAction<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #800000\">SilentlyContinue<\/span><span style=\"color: #000000\">) <\/span><span style=\"color: #ff0000\">-eq<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #800080\">$null<\/span><span style=\"color: #000000\">)  \r\n{    <\/span><span style=\"color: #5f9ea0; font-weight: bold\">Add-PSSnapin<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #800000\">SqlServerCmdletSnapin100<\/span><span style=\"color: #000000\">    }\r\n\r\n<\/span><span style=\"color: #0000ff\">if<\/span><span style=\"color: #000000\">((<\/span><span style=\"color: #5f9ea0; font-weight: bold\">Get-PSSnapin<\/span><span style=\"color: #000000\"> <\/span><span style=\"font-style: italic; color: #5f9ea0\">-Name<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #800000\">SqlServerProviderSnapin100<\/span><span style=\"color: #000000\"> <\/span><span style=\"font-style: italic; color: #5f9ea0\">-ErrorAction<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #800000\">SilentlyContinue<\/span><span style=\"color: #000000\">) <\/span><span style=\"color: #ff0000\">-eq<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #800080\">$null<\/span><span style=\"color: #000000\">)  \r\n{      <\/span><span style=\"color: #5f9ea0; font-weight: bold\">Add-PSSnapin<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #800000\">SqlServerProviderSnapin100<\/span><span style=\"color: #000000\">    }\r\n\r\n\r\n<\/span><span style=\"color: #800080\">$Query<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #ff0000\">=<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #800000\">&quot;<\/span><span style=\"color: #800000\">IF EXISTS (SELECT * FROM msdb.sys.objects WHERE [name] = 'SQLskillsPaulsIndexCounts')\r\n    DROP TABLE msdb.dbo.SQLskillsPaulsIndexCounts;\r\nGO\r\nCREATE TABLE msdb.dbo.SQLskillsPaulsIndexCounts (\r\n    BaseType CHAR (10),\r\n    IndexCount SMALLINT);\r\nGO \r\n\r\nEXEC sp_MSforeachdb \r\n    N'IF EXISTS (SELECT 1 FROM (SELECT DISTINCT [name] \r\n    FROM sys.databases WHERE [state_desc] = ''ONLINE''\r\n        AND [database_id] &gt; 4\r\n        AND [name] != ''pubs''\r\n        AND [name] != ''Northwind''\r\n        AND [name] != ''distribution''\r\n        AND [name] NOT LIKE ''ReportServer%''\r\n        AND [name] NOT LIKE ''Adventure%'') AS names WHERE [name] = ''?'')\r\nBEGIN\r\nUSE [?]\r\nINSERT INTO msdb.dbo.SQLskillsPaulsIndexCounts\r\nSELECT ''Heap'', COUNT (*)-1\r\nFROM sys.objects o\r\nJOIN sys.indexes i\r\n    ON o.[object_id] = i.[object_id]\r\nWHERE o.[type_desc] IN (''USER_TABLE'', ''VIEW'')\r\n    AND o.[is_ms_shipped] = 0\r\n    AND EXISTS (\r\n        SELECT *\r\n        FROM sys.indexes\r\n        WHERE [index_id] = 0\r\n            AND [object_id] = o.[object_id])\r\nGROUP BY i.[object_id];\r\n\r\nINSERT INTO msdb.dbo.SQLskillsPaulsIndexCounts\r\nSELECT ''Clustered'', COUNT (*)-1\r\nFROM sys.objects o\r\nJOIN sys.indexes i\r\n    ON o.[object_id] = i.[object_id]\r\nWHERE o.[type_desc] IN (''USER_TABLE'', ''VIEW'')\r\n    AND o.[is_ms_shipped] = 0\r\n    AND EXISTS (\r\n        SELECT *\r\n        FROM sys.indexes\r\n        WHERE [index_id] = 1\r\n            AND [object_id] = o.[object_id])\r\nGROUP BY i.[object_id];\r\nEND';\r\nGO \r\n\r\nSELECT DISTINCT [BaseType], [IndexCount] AS [NCIndexes], COUNT (*) AS [TableCount]\r\nFROM msdb.dbo.SQLskillsPaulsIndexCounts\r\nGROUP BY [BaseType], [IndexCount]\r\nORDER BY [BaseType], [IndexCount];\r\nGO \r\n\r\nDROP TABLE msdb.dbo.SQLskillsPaulsIndexCounts;\r\nGO<\/span><span style=\"color: #800000\">&quot;<\/span><span style=\"color: #000000\">\r\n\r\n<\/span><span style=\"color: #008000\">#<\/span><span style=\"color: #008000\"> To use a text file list of servers, place each server name on a separate line in the file<\/span><span style=\"color: #008000\">\r\n#<\/span><span style=\"color: #008000\"> then uncomment the following line to read the list from the text file and comment out the<\/span><span style=\"color: #008000\">\r\n#<\/span><span style=\"color: #008000\"> listed declaration for the servers<\/span><span style=\"color: #008000\">\r\n<\/span><span style=\"color: #000000\">\r\n<\/span><span style=\"color: #008000\">#<\/span><span style=\"color: #008000\">$servers = get-content &quot;serverlist.txt&quot;<\/span><span style=\"color: #008000\">\r\n<\/span><span style=\"color: #000000\">\r\n<\/span><span style=\"color: #008000\">#<\/span><span style=\"color: #008000\"> To specify a list of servers, place each server name in double quotes separated by a comma<\/span><span style=\"color: #008000\">\r\n#<\/span><span style=\"color: #008000\"> multiple lines are allowed.<\/span><span style=\"color: #008000\">\r\n<\/span><span style=\"color: #800080\">$ServerList<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #ff0000\">=<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #800000\">&quot;<\/span><span style=\"color: #800000\">AlwaysOnLab1<\/span><span style=\"color: #800000\">&quot;<\/span><span style=\"color: #000000\">, <\/span><span style=\"color: #800000\">&quot;<\/span><span style=\"color: #800000\">AlwaysOnLab2<\/span><span style=\"color: #800000\">&quot;<\/span><span style=\"color: #000000\">, <\/span><span style=\"color: #800000\">&quot;<\/span><span style=\"color: #800000\">AlwaysOnLab3<\/span><span style=\"color: #800000\">&quot;<\/span><span style=\"color: #000000\">\r\n\r\n<\/span><span style=\"color: #0000ff\">foreach<\/span><span style=\"color: #000000\"> (<\/span><span style=\"color: #800080\">$CurrentServer<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #0000ff\">in<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #800080\">$ServerList<\/span><span style=\"color: #000000\">) \r\n{ \r\n    \r\n    Invoke-Sqlcmd -Server <\/span><span style=\"color: #800080\">$CurrentServer<\/span><span style=\"color: #000000\"> -Database <\/span><span style=\"color: #800000\">&quot;<\/span><span style=\"color: #800000\">master<\/span><span style=\"color: #800000\">&quot;<\/span><span style=\"color: #000000\"> -Query <\/span><span style=\"color: #800080\">$Query<\/span><span style=\"color: #000000\"> \r\n}\r\n<\/span><\/pre>\n<\/blockquote>\n<p>There are two different ways to feed the server list into the above script, either as a file or as an array of comma separated server names.<\/p>\n<p>Enjoy and don\u2019t forget to post your results back on Paul\u2019s original post as a comment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Paul put up a new survey today titled Survey: nonclustered index counts (code to run).&#160; If you\u2019d like to run the query for this survey against multiple SQL Servers at once using PowerShell here is the script to do it: # Load the Snapins for SqlServer if they aren&#8217;t currently loaded if((Get-PSSnapin -Name SqlServerCmdletSnapin100 -ErrorAction [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[],"class_list":["post-518","post","type-post","status-publish","format-standard","hentry","category-powershell"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Running Paul\u2019s nonclustered index count survey against multiple instances - Jonathan Kehayias<\/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\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Running Paul\u2019s nonclustered index count survey against multiple instances - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"Paul put up a new survey today titled Survey: nonclustered index counts (code to run).&#160; If you\u2019d like to run the query for this survey against multiple SQL Servers at once using PowerShell here is the script to do it: # Load the Snapins for SqlServer if they aren&#039;t currently loaded if((Get-PSSnapin -Name SqlServerCmdletSnapin100 -ErrorAction [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2011-08-05T00:25:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-01-03T06:48:26+00:00\" \/>\n<meta name=\"author\" content=\"Jonathan Kehayias\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan Kehayias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"Running Paul\u2019s nonclustered index count survey against multiple instances\",\"datePublished\":\"2011-08-05T00:25:19+00:00\",\"dateModified\":\"2013-01-03T06:48:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\\\/\"},\"wordCount\":96,\"commentCount\":1,\"articleSection\":[\"Powershell\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\\\/\",\"name\":\"Running Paul\u2019s nonclustered index count survey against multiple instances - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"datePublished\":\"2011-08-05T00:25:19+00:00\",\"dateModified\":\"2013-01-03T06:48:26+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Powershell\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/powershell\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Running Paul\u2019s nonclustered index count survey against multiple instances\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\",\"name\":\"Jonathan Kehayias - The Rambling DBA\",\"description\":\"The Rambling DBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/?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\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\",\"name\":\"Jonathan Kehayias\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"caption\":\"Jonathan Kehayias\"},\"sameAs\":[\"http:\\\/\\\/3.209.169.194\\\/blogs\\\/jonathan\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Running Paul\u2019s nonclustered index count survey against multiple instances - Jonathan Kehayias","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\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/","og_locale":"en_US","og_type":"article","og_title":"Running Paul\u2019s nonclustered index count survey against multiple instances - Jonathan Kehayias","og_description":"Paul put up a new survey today titled Survey: nonclustered index counts (code to run).&#160; If you\u2019d like to run the query for this survey against multiple SQL Servers at once using PowerShell here is the script to do it: # Load the Snapins for SqlServer if they aren't currently loaded if((Get-PSSnapin -Name SqlServerCmdletSnapin100 -ErrorAction [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/","og_site_name":"Jonathan Kehayias","article_published_time":"2011-08-05T00:25:19+00:00","article_modified_time":"2013-01-03T06:48:26+00:00","author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"Running Paul\u2019s nonclustered index count survey against multiple instances","datePublished":"2011-08-05T00:25:19+00:00","dateModified":"2013-01-03T06:48:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/"},"wordCount":96,"commentCount":1,"articleSection":["Powershell"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/","name":"Running Paul\u2019s nonclustered index count survey against multiple instances - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"datePublished":"2011-08-05T00:25:19+00:00","dateModified":"2013-01-03T06:48:26+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/running-pauls-nonclustered-index-count-survey-against-multiple-instances\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Powershell","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/powershell\/"},{"@type":"ListItem","position":3,"name":"Running Paul\u2019s nonclustered index count survey against multiple instances"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/","name":"Jonathan Kehayias - The Rambling DBA","description":"The Rambling DBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/?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\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c","name":"Jonathan Kehayias","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","caption":"Jonathan Kehayias"},"sameAs":["http:\/\/3.209.169.194\/blogs\/jonathan"]}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/518","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/comments?post=518"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/518\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}