{"id":1061,"date":"2019-11-12T09:33:08","date_gmt":"2019-11-12T17:33:08","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=1061"},"modified":"2020-01-30T13:36:53","modified_gmt":"2020-01-30T21:36:53","slug":"query-store-options-in-ssms-18-4","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/","title":{"rendered":"Query Store Options in SSMS 18.4"},"content":{"rendered":"<p>Last week the SQL Server Tools team released a <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms?view=sql-server-ver15\">new version of Management Studio, 18.4<\/a>, and it dropped in the middle of my Query Store full day pre-con on Monday. Those two are related. There were some changes in SSMS 18.4 specific to Query Store, and for a few seconds over lunch I thought about downloading the new version and running it for my afternoon demos. But\u2026I didn\u2019t want to anger the demo Gods, so I stuck with 18.3.<\/p>\n<h1>What\u2019s New?<\/h1>\n<p>The list of features and fixes for each release of SSMS can be found <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/release-notes-ssms?view=sql-server-ver15\">here<\/a>, and for this post I\u2019m interested in the features related to Query Store. Within Management Studio we&#8217;ll create a new database named QS_Settings and turn on Query Store with the default options:<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n\/*\r\n     Of note: I NEVER recommend creating a database\r\n     with this syntax, I am being lazy and just accepting all\r\n     defaults, JUST for demo purposes\r\n*\/\r\nUSE &#x5B;master];\r\nGO\r\nCREATE DATABASE &#x5B;QS_Settings];\r\nGO\r\nALTER DATABASE &#x5B;QS_Settings] SET QUERY_STORE = ON;\r\nGO\r\nALTER DATABASE &#x5B;QS_Settings] SET QUERY_STORE (\r\n     OPERATION_MODE = READ_WRITE\r\n     );\r\nGO\r\n<\/pre>\n<p>If we look at the Query Store page on the Database Properties window, you\u2019ll see some additional entries:<\/p>\n<figure id=\"attachment_1062\" aria-describedby=\"caption-attachment-1062\" style=\"width: 900px\" class=\"wp-caption aligncenter\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-1062\" src=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/Snag_a5d768f-1024x840.png\" alt=\"Query Store options in SSMS 18.4\" width=\"900\" height=\"738\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/Snag_a5d768f-1024x840.png 1024w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/Snag_a5d768f-300x246.png 300w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/Snag_a5d768f-768x630.png 768w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/Snag_a5d768f.png 1312w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><figcaption id=\"caption-attachment-1062\" class=\"wp-caption-text\">Query Store options in SSMS 18.4<\/figcaption><\/figure>\n<p>For comparison, here is a screen shot of the same window in SSMS 18.3:<\/p>\n<figure id=\"attachment_1063\" aria-describedby=\"caption-attachment-1063\" style=\"width: 900px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/183.jpg\"><img decoding=\"async\" class=\"wp-image-1063\" src=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/183-1024x931.jpg\" alt=\"Query Store options in SSMS 18.3 and below\" width=\"900\" height=\"818\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/183-1024x931.jpg 1024w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/183-300x273.jpg 300w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/183-768x698.jpg 768w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/183.jpg 1025w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/a><figcaption id=\"caption-attachment-1063\" class=\"wp-caption-text\">Query Store options in SSMS 18.3 and below<\/figcaption><\/figure>\n<p>There are two options that, previously, you could only modify using T-SQL:<\/p>\n<ul>\n<li>MAX_PLANS_PER_QUERY<\/li>\n<li>WAIT_STATS_CAPTURE_MODE<\/li>\n<\/ul>\n<p>And there is an entirely new section specific to the CUSTOM value for QUERY_CAPTURE_MODE, <a href=\"http:\/\/(https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-in-sql-server-2019-ctp-3-0\/\">which was added in SQL Server 2019<\/a>. In addition, the default values for some settings changed in SQL Server 2019.<\/p>\n<h1>Setting MAX_PLANS_PER_QUERY and WAIT_STATS_CAPTURE_MODE<\/h1>\n<p>When you enable Query Store in any version of SQL Server, by default the value for MAX_PLANS_PER_QUERY is 200. As mentioned in my <a href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-settings\/\">Query Store Settings post<\/a>, I recommend leaving this setting at the default value. The only case where I would change it is if I find that I have queries with more than 200 plans. If you are running SSMS 18.3 or below, or <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/download?view=sql-server-ver15\">Azure Data Studio<\/a> (ADS), you can use:<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nUSE &#x5B;master];\r\nGO\r\nALTER DATABASE &#x5B;QS_Settings] SET QUERY_STORE (\r\n     MAX_PLANS_PER_QUERY = 500\r\n     );\r\nGO\r\n<\/pre>\n<p>When you enable Query Store in SQL Server 2017 or 2019, WAIT_STATS_CAPTURE_MODE is enabled by default (remember that query-level wait statistics were not available in Query Store in SQL Server 2016). When you upgrade to SQL Server 2017 or 2019 from SQL Server 2016, and you have Query Store enabled,\u00a0 WAIT_STATS_CAPTURE_MODE is automatically enabled. If you want to turn it off for some reason, and you\u2019re using SSMS 18.3 or below, or ADS, you can run:<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nUSE &#x5B;master];\r\nGO\r\nALTER DATABASE &#x5B;WideWorldImporters] SET QUERY_STORE (\r\n     WAIT_STATS_CAPTURE_MODE = OFF\r\n     )\r\nGO\r\n<\/pre>\n<p>With SSMS 18.4, you now have the ability to change both options via the UI. In general, I recommend using the T-SQL because then it can go into change control, and you don\u2019t have to worry about altering another setting by mistake.<\/p>\n<h1>CUSTOM Options for QUERY_CAPTURE_MODE<\/h1>\n<p>In SQL Server 2019 we now have the ability to customize queries that are captured based on execution count, total compile CPU time (ms), <strong>OR<\/strong> total execution CPU time (ms), within a defined window of time. This provides much more control than the AUTO option, which excludes queries based on internally-determined thresholds set by Microsoft, which are not documented. The CUSTOM option is a game-changer, as it allows those with ad hoc workloads to use Query Store and minimize the <a href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-performance-overhead\/\">performance overhead<\/a>.<\/p>\n<h2>Changing to CUSTOM<\/h2>\n<p>When upgrading a database from SQL Server 2016 or 2017 to SQL Server 2019, with Query Store already enabled, the value for QUERY_CAPTURE_MODE will not change. To enable and customize the options if you are running SSMS 18.3 or lower, or ADS, you can use:<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nUSE &#x5B;master];\r\nGO\r\nALTER DATABASE &#x5B;QS_Settings] SET QUERY_STORE (\r\n     QUERY_CAPTURE_MODE = CUSTOM,\r\n     QUERY_CAPTURE_POLICY = (\r\n          STALE_CAPTURE_POLICY_THRESHOLD = 1 HOURS, \r\n          EXECUTION_COUNT = 30,\r\n          TOTAL_COMPILE_CPU_TIME_MS = 1000, \r\n          TOTAL_EXECUTION_CPU_TIME_MS = 100)\r\n          )\r\nGO\r\n<\/pre>\n<p>Within SSMS 18.4, when you change QUERY_CAPTURE_MODE to CUSTOM in the UI you will see:<\/p>\n<figure id=\"attachment_1064\" aria-describedby=\"caption-attachment-1064\" style=\"width: 900px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/custom.jpg\"><img decoding=\"async\" class=\"wp-image-1064\" src=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/custom-1024x914.jpg\" alt=\"Options for CUSTOM capture policy\" width=\"900\" height=\"804\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/custom-1024x914.jpg 1024w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/custom-300x268.jpg 300w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/custom-768x686.jpg 768w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/custom.jpg 1206w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/a><figcaption id=\"caption-attachment-1064\" class=\"wp-caption-text\">Options for CUSTOM capture policy<\/figcaption><\/figure>\n<p>At this time, I do not have recommendations, based on data, for these options. I have one customer running SQL Server 2019, and I haven\u2019t heard from many people who are running SQL Server 2019 and have Query Store enabled.\u00a0 Yet. Over time, I am hoping to get better information, but my initial suggestion is that you make a best estimate and then monitor. The default values are a good starting point. The minimum window of time (STALE_CAPTURE_POLICY_THRESHOLD) is one hour, and the default 1 day. Note that the drop-down for this option contains a list of values:<\/p>\n<figure id=\"attachment_1065\" aria-describedby=\"caption-attachment-1065\" style=\"width: 418px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/list.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1065\" src=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/list.jpg\" alt=\"STALE_CAPTURE_POLICY_THRESHOLD drop-down options\" width=\"418\" height=\"152\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/list.jpg 418w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/list-300x109.jpg 300w\" sizes=\"(max-width: 418px) 100vw, 418px\" \/><\/a><figcaption id=\"caption-attachment-1065\" class=\"wp-caption-text\">STALE_CAPTURE_POLICY_THRESHOLD drop-down options<\/figcaption><\/figure>\n<p>Unlike INTERVAL_LENGTH_MINUTES, these are not the only values that you can use. For example, you can set STALE_CAPTURE_POLICY_THRESHOLD to a value not in the list, such as two hours, using T-SQL:<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nUSE &#x5B;master];\r\nGO\r\nALTER DATABASE &#x5B;QS_Settings] SET QUERY_STORE (\r\n     QUERY_CAPTURE_MODE = CUSTOM, \r\n     QUERY_CAPTURE_POLICY = (\r\n          STALE_CAPTURE_POLICY_THRESHOLD = 2 HOURS)\r\n     );\r\nGO\r\n<\/pre>\n<p>The value of 2 HOURS will then appear in the drop-down list going forward, which I find interesting, but that&#8217;s another rabbit hole to explore. Acceptable values for this option range from 1 hour to 7 days. While you can be clever and choose something like 42 hours, think about what window of time is appropriate for a business day, whether it\u2019s an 8-hour day or a 24-hour day because you\u2019re 24&#215;7.<\/p>\n<h2>Thresholds<\/h2>\n<p>For EXECUTION_COUNT, the default value is 30, which is appropriate for an ad hoc workload as most of the time as queries only execute one time. Determining values for TOTAL_COMPILE_CPU_TIME_MS and TOTAL_EXECUTION_CPU_TIME_MS is a bit trickier. The defaults are 1000ms and 100ms, respectively. The settings are milliseconds, but the data in the Query Store table is stored in microseconds; remember this when you\u2019re comparing your settings to what is in Query Store.<\/p>\n<p>Think about the execution time first. Do you have a threshold where if a query requires more than X amount of CPU time, you\u2019re concerned? Maybe 100ms is too low, and 1000ms (1 second) is more appropriate for your environment.<\/p>\n<p>Compilation time is the hardest. I would not recommend setting it below 1000ms until you can look at captured data in Query Store. Understand that both compilation and CPU time are cumulative for these thresholds. If a query executions 5 times (below your EXECUTION_COUNT threshold, but takes 25ms of TOTAL_EXECUTION_CPU_TIME_MS each time, then on that fifth execution it will exceed 100ms and subsequent executions will be captured.<\/p>\n<h1>Summary<\/h1>\n<p>For anyone using SQL Server 2019, I highly recommend using SSMS 18.4, particularly if you use Query Store, or plan on using it. If you\u2019re running SQL Server 2016 or 2017, it\u2019s nice to see those additional settings in the UI, and in general I recommend staying current with releases for all the tools, assuming you don\u2019t have business rules that limit or control what you can install.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last week the SQL Server Tools team released a new version of Management Studio, 18.4, and it dropped in the middle of my Query Store full day pre-con on Monday. Those two are related. There were some changes in SSMS 18.4 specific to Query Store, and for a few seconds over lunch I thought about [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42,46],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Query Store Options in SSMS 18.4 - Erin Stellato<\/title>\n<meta name=\"description\" content=\"In SSMS 18.4 all Query Store options can be viewed and modified via the UI, to make reviewing and changing these values easier.\" \/>\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\/erin\/query-store-options-in-ssms-18-4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Query Store Options in SSMS 18.4 - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"In SSMS 18.4 all Query Store options can be viewed and modified via the UI, to make reviewing and changing these values easier.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-12T17:33:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-30T21:36:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/Snag_a5d768f-1024x840.png\" \/>\n<meta name=\"author\" content=\"Erin Stellato\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Erin Stellato\" \/>\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\/erin\/query-store-options-in-ssms-18-4\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/\",\"name\":\"Query Store Options in SSMS 18.4 - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2019-11-12T17:33:08+00:00\",\"dateModified\":\"2020-01-30T21:36:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"description\":\"In SSMS 18.4 all Query Store options can be viewed and modified via the UI, to make reviewing and changing these values easier.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Query Store Options in SSMS 18.4\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\",\"name\":\"Erin Stellato\",\"description\":\"The SQL Sequel\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\",\"name\":\"Erin Stellato\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"caption\":\"Erin Stellato\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/erin\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Query Store Options in SSMS 18.4 - Erin Stellato","description":"In SSMS 18.4 all Query Store options can be viewed and modified via the UI, to make reviewing and changing these values easier.","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\/erin\/query-store-options-in-ssms-18-4\/","og_locale":"en_US","og_type":"article","og_title":"Query Store Options in SSMS 18.4 - Erin Stellato","og_description":"In SSMS 18.4 all Query Store options can be viewed and modified via the UI, to make reviewing and changing these values easier.","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/","og_site_name":"Erin Stellato","article_published_time":"2019-11-12T17:33:08+00:00","article_modified_time":"2020-01-30T21:36:53+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2019\/11\/Snag_a5d768f-1024x840.png"}],"author":"Erin Stellato","twitter_misc":{"Written by":"Erin Stellato","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/","name":"Query Store Options in SSMS 18.4 - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2019-11-12T17:33:08+00:00","dateModified":"2020-01-30T21:36:53+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"description":"In SSMS 18.4 all Query Store options can be viewed and modified via the UI, to make reviewing and changing these values easier.","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-options-in-ssms-18-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"Query Store Options in SSMS 18.4"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/","name":"Erin Stellato","description":"The SQL Sequel","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158","name":"Erin Stellato","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","caption":"Erin Stellato"},"sameAs":["http:\/\/3.209.169.194\/blogs\/erin"],"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/1061"}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/comments?post=1061"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/1061\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=1061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=1061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=1061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}