{"id":8481,"date":"2016-06-28T12:25:53","date_gmt":"2016-06-28T10:25:53","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/"},"modified":"2016-06-28T12:25:53","modified_gmt":"2016-06-28T10:25:53","slug":"sql-server-2016-query-store-retrieve-query-that-doesnt-appear","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/","title":{"rendered":"SQL Server 2016 \u2013 Query Store: retrieve query that doesn\u2019t appear!"},"content":{"rendered":"

For our event SQL Server 2016 in September, I am studying the new functionality Query Store.
\nMy colleague David Barbarin<\/a> have written few months ago about Query Store and how it\u2019s working.<\/a><\/p>\n

Simple SELECT Query<\/strong><\/h3>\n

To begin, I execute a simple SELECT on a table with 3 different methods:<\/p>\n

SELECT * FROM QS_test;\nexec sp_executesql N'SELECT * FROM QS_test'\nEXEC sp_GetQS_test;\n<\/pre>\n
The “sp_GetQS_test” is a stored procedure with the select statement.
\nI created a little query with specific DMVs for Query Store to analyze the query:<\/p>\n
SELECT  qsqt.query_text_id,qsqt.query_sql_text,qsq.query_id,qsq.query_hash,\n   qsq.query_parameterization_type_desc,qsq.initial_compile_start_time,\n   qsq.last_compile_start_time,qsq.last_execution_time,qsq.avg_compile_duration,\n   qsp.query_id,qsp.plan_id,qsrs.execution_type_desc\n  FROM sys.query_store_query_text qsqt\n  inner join sys.query_store_query qsq on qsq.query_text_id=qsqt.query_text_id\n  inner join sys.query_store_plan qsp on qsp.query_id=qsq.query_id \n  inner join sys.query_store_runtime_stats qsrs on qsrs.plan_id=qsp.plan_id   \n  WHERE query_sql_text='SELECT * FROM QS_test';<\/pre>\n
\"QS_01\"<\/a>
\nAs you can see in the result, all 3 queries are present with the same query text (‘SELECT * FROM QS_test’) in the query store.<\/p>\n
SELECT Query with a Where clause<\/strong><\/h3>\n
I continue my test with a select and a where clause:<\/p>\n
  SELECT * FROM QS_test WHERE rid=5<\/pre>\n
I run my query to find the query in the query store:
\n\"QS_02\"<\/a>
\nAnd, Oh surprise, no query found! The query does not appear in the query store\u2026.
\nI rerun my query without the where clause to see if I find something:
\n\"QS_03\"<\/a>
\nThe result give me a query written differently:
\n(@1 tinyint)SELECT * FROM [QS_test] WHERE [rid]=@1<\/p>\n
This query goes through a parametrization and to retrieve this information we use a new function in SQL Server 2016: fn_stmt_sql_handle_from_sql_stmt<\/a><\/strong><\/p>\n
Function sys.fn_stmt_sql_handle_from_sql_stmt<\/strong><\/h3>\n
This function give us the SQL handle for the query
\n\"QS_04\"<\/a>
\nAfter, I add the function in my query to find it in the Query Store:<\/p>\n
SELECT\u00a0 qsqt.query_text_id,qsqt.query_sql_text,qsq.query_id,qsq.query_hash,\n\nqsq.query_parameterization_type_desc,qsq.initial_compile_start_time,qsq.last_compile_start_time,\n\nqsq.last_execution_time,qsq.avg_compile_duration,qsp.query_id,qsp.plan_id,qsrs.execution_type_desc\n\nFROM sys.query_store_query_text qsqt\n\ninner join sys.query_store_query qsq on qsq.query_text_id=qsqt.query_text_id\n\ninner join sys.query_store_plan qsp on qsp.query_id=qsq.query_id\n\ninner join sys.query_store_runtime_stats qsrs on qsrs.plan_id=qsp.plan_id\n\nCROSS APPLY sys.fn_stmt_sql_handle_from_sql_stmt('SELECT * FROM QS_test WHERE rid=5',NULL) fsshfss\n\nWHERE qsqt.statement_sql_handle=fsshfss.statement_sql_handle;<\/pre>\n
\"QS_05\"<\/a><\/p>\n
It\u2019s done, I retrieve the query thanks to this new function.
\nYou can notice that I use the statement_sql_handle column and not the query_sql_text column in the clause where.<\/p>\n
I have tested with query_sql_text column and you can see here the error that I get\u2026
\n\"QS_06\"<\/a>
\nThe query_sql_text from the function is SQL_Latin1_General_CP1_CI_AS and both my database and my instance are using French_CI_AS. This is not hopeless\u2026
\nThen, if you want to use the query with query_sql_text, you just need just to precise the collation with the keyword COLLATE
\n\"QS_07\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
For our event SQL Server 2016 in September, I am studying the new functionality Query Store. My colleague David Barbarin have written few months ago about Query Store and how it\u2019s working. Simple SELECT Query To begin, I execute a simple SELECT on a table with 3 different methods: SELECT * FROM QS_test; exec sp_executesql […]<\/p>\n","protected":false},"author":15,"featured_media":8489,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,368,48],"tags":[49,688,51,566],"type_dbi":[],"class_list":["post-8481","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-development-performance","category-technology-survey","tag-microsoft","tag-query-store","tag-sql-server","tag-sql-server-2016"],"acf":[],"yoast_head":"\nSQL Server 2016 \u2013 Query Store: retrieve query that doesn\u2019t appear! - dbi Blog<\/title>\n<meta name=\"description\" content=\"Select with clause where in a Qurey store is hide.\" \/>\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.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 \u2013 Query Store: retrieve query that doesn\u2019t appear!\" \/>\n<meta property=\"og:description\" content=\"Select with clause where in a Qurey store is hide.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-28T10:25:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/QS_01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"725\" \/>\n\t<meta property=\"og:image:height\" content=\"343\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016 \u2013 Query Store: retrieve query that doesn\u2019t appear!\",\"datePublished\":\"2016-06-28T10:25:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/\"},\"wordCount\":348,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/QS_01-1.png\",\"keywords\":[\"Microsoft\",\"query store\",\"SQL Server\",\"SQL Server 2016\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Development & Performance\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/\",\"name\":\"SQL Server 2016 \u2013 Query Store: retrieve query that doesn\u2019t appear! - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/QS_01-1.png\",\"datePublished\":\"2016-06-28T10:25:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"Select with clause where in a Qurey store is hide.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/QS_01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/QS_01-1.png\",\"width\":725,\"height\":343},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016 \u2013 Query Store: retrieve query that doesn\u2019t appear!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2016 \u2013 Query Store: retrieve query that doesn\u2019t appear! - dbi Blog","description":"Select with clause where in a Qurey store is hide.","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.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 \u2013 Query Store: retrieve query that doesn\u2019t appear!","og_description":"Select with clause where in a Qurey store is hide.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/","og_site_name":"dbi Blog","article_published_time":"2016-06-28T10:25:53+00:00","og_image":[{"width":725,"height":343,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/QS_01-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016 \u2013 Query Store: retrieve query that doesn\u2019t appear!","datePublished":"2016-06-28T10:25:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/"},"wordCount":348,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/QS_01-1.png","keywords":["Microsoft","query store","SQL Server","SQL Server 2016"],"articleSection":["Database Administration & Monitoring","Development & Performance","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/","name":"SQL Server 2016 \u2013 Query Store: retrieve query that doesn\u2019t appear! - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/QS_01-1.png","datePublished":"2016-06-28T10:25:53+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"Select with clause where in a Qurey store is hide.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/QS_01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/QS_01-1.png","width":725,"height":343},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-query-store-retrieve-query-that-doesnt-appear\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016 \u2013 Query Store: retrieve query that doesn\u2019t appear!"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=8481"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8481\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8489"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8481"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}