SQL Server Consulting & Remote DBA Service<\/a>.<\/p>\n![\"\"\/](\"http:\/\/feeds.feedburner.com\/~r\/JohnSterrettsBlog\/~4\/2yLQmK1C_lk\")
<\/p>\n","protected":false},"excerpt":{"rendered":"
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your code go faster without any code changes! We have been testing SQL Server 2019 for months and hope you enjoy these features as much as we […]<\/p>\n","protected":false},"author":1,"featured_media":74891,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[8,5],"tags":[],"jetpack_publicize_connections":[],"yoast_head":"\n
5 Game Changers with SQL Server 2019 - ProcureSQL Data Architect as a Service<\/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:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 Game Changers with SQL Server 2019\" \/>\n<meta property=\"og:description\" content=\"Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your code go faster without any code changes! We have been testing SQL Server 2019 for months and hope you enjoy these features as much as we […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"ProcureSQL Data Architect as a Service\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ProCureSQL\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-05T22:06:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/procuresql.com\/wp-content\/uploads\/2019\/12\/5-game-changers-with-sql-server-2019-1.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"1\" \/>\n\t<meta property=\"og:image:height\" content=\"1\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"author\" content=\"JohnSterrett\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@procuresql\" \/>\n<meta name=\"twitter:site\" content=\"@procuresql\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"JohnSterrett\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/\"},\"author\":{\"name\":\"JohnSterrett\",\"@id\":\"https:\/\/procuresql.com\/#\/schema\/person\/94536206d50e40005754b2fe7eb055b5\"},\"headline\":\"5 Game Changers with SQL Server 2019\",\"datePublished\":\"2019-11-05T22:06:24+00:00\",\"dateModified\":\"2019-11-05T22:06:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/\"},\"wordCount\":81,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/procuresql.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/procuresql.com\/wp-content\/uploads\/2019\/12\/5-game-changers-with-sql-server-2019-1.gif\",\"articleSection\":[\"Data Architecture\",\"Performance Tuning\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/\",\"url\":\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/\",\"name\":\"5 Game Changers with SQL Server 2019 - ProcureSQL Data Architect as a Service\",\"isPartOf\":{\"@id\":\"https:\/\/procuresql.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/procuresql.com\/wp-content\/uploads\/2019\/12\/5-game-changers-with-sql-server-2019-1.gif\",\"datePublished\":\"2019-11-05T22:06:24+00:00\",\"dateModified\":\"2019-11-05T22:06:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#primaryimage\",\"url\":\"https:\/\/procuresql.com\/wp-content\/uploads\/2019\/12\/5-game-changers-with-sql-server-2019-1.gif\",\"contentUrl\":\"https:\/\/procuresql.com\/wp-content\/uploads\/2019\/12\/5-game-changers-with-sql-server-2019-1.gif\",\"width\":1,\"height\":1},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/procuresql.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 Game Changers with SQL Server 2019\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/procuresql.com\/#website\",\"url\":\"https:\/\/procuresql.com\/\",\"name\":\"Data Architect as a Service\",\"description\":\"Managing All Your Data, Cloud and Application Needs\",\"publisher\":{\"@id\":\"https:\/\/procuresql.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/procuresql.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/procuresql.com\/#organization\",\"name\":\"ProcureSQL\",\"url\":\"https:\/\/procuresql.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/procuresql.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/procuresql.com\/wp-content\/uploads\/2024\/04\/cropped-cropped-Untitled-design-52.png\",\"contentUrl\":\"https:\/\/procuresql.com\/wp-content\/uploads\/2024\/04\/cropped-cropped-Untitled-design-52.png\",\"width\":150,\"height\":56,\"caption\":\"ProcureSQL\"},\"image\":{\"@id\":\"https:\/\/procuresql.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ProCureSQL\/\",\"https:\/\/x.com\/procuresql\",\"https:\/\/www.instagram.com\/procuresql\",\"https:\/\/www.linkedin.com\/company\/procure-sql\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/procuresql.com\/#\/schema\/person\/94536206d50e40005754b2fe7eb055b5\",\"name\":\"JohnSterrett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/procuresql.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e21f222fc6d01ca840cabf017e2ddd02?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e21f222fc6d01ca840cabf017e2ddd02?s=96&d=mm&r=g\",\"caption\":\"JohnSterrett\"},\"sameAs\":[\"https:\/\/procuresql.com\"],\"url\":\"https:\/\/procuresql.com\/blog\/author\/johnsterrett\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"5 Game Changers with SQL Server 2019 - ProcureSQL Data Architect as a Service","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:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/","og_locale":"en_US","og_type":"article","og_title":"5 Game Changers with SQL Server 2019","og_description":"Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your code go faster without any code changes! We have been testing SQL Server 2019 for months and hope you enjoy these features as much as we […]","og_url":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/","og_site_name":"ProcureSQL Data Architect as a Service","article_publisher":"https:\/\/www.facebook.com\/ProCureSQL\/","article_published_time":"2019-11-05T22:06:24+00:00","og_image":[{"width":1,"height":1,"url":"https:\/\/procuresql.com\/wp-content\/uploads\/2019\/12\/5-game-changers-with-sql-server-2019-1.gif","type":"image\/gif"}],"author":"JohnSterrett","twitter_card":"summary_large_image","twitter_creator":"@procuresql","twitter_site":"@procuresql","twitter_misc":{"Written by":"JohnSterrett"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#article","isPartOf":{"@id":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/"},"author":{"name":"JohnSterrett","@id":"https:\/\/procuresql.com\/#\/schema\/person\/94536206d50e40005754b2fe7eb055b5"},"headline":"5 Game Changers with SQL Server 2019","datePublished":"2019-11-05T22:06:24+00:00","dateModified":"2019-11-05T22:06:24+00:00","mainEntityOfPage":{"@id":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/"},"wordCount":81,"commentCount":0,"publisher":{"@id":"https:\/\/procuresql.com\/#organization"},"image":{"@id":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/procuresql.com\/wp-content\/uploads\/2019\/12\/5-game-changers-with-sql-server-2019-1.gif","articleSection":["Data Architecture","Performance Tuning"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/","url":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/","name":"5 Game Changers with SQL Server 2019 - ProcureSQL Data Architect as a Service","isPartOf":{"@id":"https:\/\/procuresql.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#primaryimage"},"image":{"@id":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/procuresql.com\/wp-content\/uploads\/2019\/12\/5-game-changers-with-sql-server-2019-1.gif","datePublished":"2019-11-05T22:06:24+00:00","dateModified":"2019-11-05T22:06:24+00:00","breadcrumb":{"@id":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#primaryimage","url":"https:\/\/procuresql.com\/wp-content\/uploads\/2019\/12\/5-game-changers-with-sql-server-2019-1.gif","contentUrl":"https:\/\/procuresql.com\/wp-content\/uploads\/2019\/12\/5-game-changers-with-sql-server-2019-1.gif","width":1,"height":1},{"@type":"BreadcrumbList","@id":"https:\/\/procuresql.com\/blog\/2019\/11\/05\/5-game-changers-with-sql-server-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/procuresql.com\/"},{"@type":"ListItem","position":2,"name":"5 Game Changers with SQL Server 2019"}]},{"@type":"WebSite","@id":"https:\/\/procuresql.com\/#website","url":"https:\/\/procuresql.com\/","name":"Data Architect as a Service","description":"Managing All Your Data, Cloud and Application Needs","publisher":{"@id":"https:\/\/procuresql.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/procuresql.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/procuresql.com\/#organization","name":"ProcureSQL","url":"https:\/\/procuresql.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/procuresql.com\/#\/schema\/logo\/image\/","url":"https:\/\/procuresql.com\/wp-content\/uploads\/2024\/04\/cropped-cropped-Untitled-design-52.png","contentUrl":"https:\/\/procuresql.com\/wp-content\/uploads\/2024\/04\/cropped-cropped-Untitled-design-52.png","width":150,"height":56,"caption":"ProcureSQL"},"image":{"@id":"https:\/\/procuresql.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ProCureSQL\/","https:\/\/x.com\/procuresql","https:\/\/www.instagram.com\/procuresql","https:\/\/www.linkedin.com\/company\/procure-sql"]},{"@type":"Person","@id":"https:\/\/procuresql.com\/#\/schema\/person\/94536206d50e40005754b2fe7eb055b5","name":"JohnSterrett","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/procuresql.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e21f222fc6d01ca840cabf017e2ddd02?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e21f222fc6d01ca840cabf017e2ddd02?s=96&d=mm&r=g","caption":"JohnSterrett"},"sameAs":["https:\/\/procuresql.com"],"url":"https:\/\/procuresql.com\/blog\/author\/johnsterrett\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/procuresql.com\/wp-content\/uploads\/2019\/12\/5-game-changers-with-sql-server-2019-1.gif","_links":{"self":[{"href":"https:\/\/procuresql.com\/wp-json\/wp\/v2\/posts\/74890"}],"collection":[{"href":"https:\/\/procuresql.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/procuresql.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/procuresql.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/procuresql.com\/wp-json\/wp\/v2\/comments?post=74890"}],"version-history":[{"count":0,"href":"https:\/\/procuresql.com\/wp-json\/wp\/v2\/posts\/74890\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/procuresql.com\/wp-json\/wp\/v2\/media\/74891"}],"wp:attachment":[{"href":"https:\/\/procuresql.com\/wp-json\/wp\/v2\/media?parent=74890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/procuresql.com\/wp-json\/wp\/v2\/categories?post=74890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/procuresql.com\/wp-json\/wp\/v2\/tags?post=74890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}