{"id":1683,"date":"2019-08-25T18:19:40","date_gmt":"2019-08-26T01:19:40","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1683"},"modified":"2020-08-04T17:09:09","modified_gmt":"2020-08-05T00:09:09","slug":"glenns-tech-insights-for-august-25-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/","title":{"rendered":"Glenn&rsquo;s Technical Insights For August 25, 2019"},"content":{"rendered":"<p><span style=\"font-size: small;\"><em>(Glenn\u2019s Technical Insights\u2026<\/em> used to be part of our bi-weekly <\/span><a href=\"https:\/\/www.sqlskills.com\/join-the-sqlskills-insider-community\/\"><span style=\"font-size: small;\">newsletter<\/span><\/a><span style=\"font-size: small;\"> but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server). <\/span><\/p>\n<p><span style=\"font-size: small;\">It also can just be technically related items that I find interesting.<\/span><\/p>\n<h2><span style=\"font-weight: bold; font-size: medium;\">SQL Server 2019 Release Candidate<\/span><\/h2>\n<p><span style=\"font-size: small;\">On August 21, 2019, Microsoft <a href=\"https:\/\/cloudblogs.microsoft.com\/sqlserver\/2019\/08\/21\/sql-server-2019-release-candidate-is-now-available\/\" target=\"_blank\" rel=\"noopener noreferrer\">announced the availability<\/a> of the first public release candidate of <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-2019\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server 2019<\/a>. I find it interesting that Microsoft just called this \u201cSQL Server 2019 Release Candidate\u201d rather than Release Candidate 1 like they have done with previous versions of SQL Server. That sort of implies that there won\u2019t be any more public release candidates before GA.<\/span><\/p>\n<p><span style=\"font-size: small;\">The looming question is when SQL Server 2019 will actually go GA. The conventional wisdom is that it will happen during the first week of November, while <a href=\"https:\/\/www.microsoft.com\/en-us\/ignite\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Ignite<\/a> (and <a href=\"https:\/\/www.pass.org\/summit\/2019\/Home.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">PASS Summit 2019<\/a>) are happening. It will probably be Wednesday, November 6, 2019, during the Day 1 Keynote Session at the PASS Summit. That is my guess.<\/span><\/p>\n<p><span style=\"font-size: small;\">Regardless of that, I think SQL Server 2019 is going to be a worthwhile release that should help convince more organizations to finally upgrade from their legacy versions of SQL Server. <\/span><\/p>\n<blockquote><p><span style=\"font-size: small;\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/what-s-new-in-sql-server-ver15?view=sqlallproducts-allversions\" target=\"_blank\" rel=\"noopener noreferrer\">What\u2019s New in SQL Server 2019<\/a><\/span><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-size: small;\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/sql-server-ver15-release-notes?view=sqlallproducts-allversions\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server 2019 Preview Release Notes<\/a><\/span><\/span><\/p><\/blockquote>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.mssqltips.com\/tipimages2\/5744_sql-server-2019-overview.004.png\" alt=\"See the source image\" \/><\/p>\n<p><span style=\"font-size: small;\"><strong>Figure 1: Top Ten Reasons to Choose SQL Server 2019<\/strong><\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<h2><span style=\"font-size: medium;\"><span style=\"font-weight: bold;\">August 2019 Release of Azure Data Studio<\/span><\/span><\/h2>\n<p><span style=\"font-size: small;\">On August 15, 2019, <a href=\"https:\/\/cloudblogs.microsoft.com\/sqlserver\/2019\/08\/15\/the-august-release-of-azure-data-studio-is-now-available\/\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft released the August 2019 version<\/a> of <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/download?view=sql-server-2017\" target=\"_blank\" rel=\"noopener noreferrer\">Azure Data Studio<\/a>, which is version 1.10. Microsoft continues to maintain a monthly release cycle for Azure Data Studio. In my mind, this probably means that you should start using Azure Data Studio at least enough so that you are familiar with it. <\/span><\/p>\n<p><span style=\"font-size: small;\">I think it is going to be a tough \u201cask\u201d for Microsoft to get veteran DBAs to completely switch to Azure Data Studio rather than using SSMS for most of their daily work. They would probably deny that is even their intent. At the same time, if SSMS is only updated every several months, and if Azure Data Studio continues to get new features to the point where it is seen as more useful than SSMS, then it may eventually become inevitable.<\/span><\/p>\n<p><span style=\"font-size: small;\">Don\u2019t get me wrong, I am not hostile to Azure Data Studio. In fact, I plan on using it to present <a href=\"https:\/\/www.pass.org\/summit\/2019\/Learn\/SessionDetails.aspx?name=dr-dmv-s-troubleshooting-toolkit&amp;sid=92675\" target=\"_blank\" rel=\"noopener noreferrer\">Dr. DMV\u2019s Troubleshooting Toolkit at the PASS Summit 2019<\/a>. I plan on building a SQL Notebook for that.<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/08\/image-6.png\"><img fetchpriority=\"high\" decoding=\"async\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/08\/image_thumb-6.png\" alt=\"image\" width=\"602\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><span style=\"font-size: small;\"><strong>Figure 2: Azure Data Studio<\/strong><\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>(Glenn\u2019s Technical Insights\u2026 used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server). It also can just be technically related items that I find interesting. [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[432],"tags":[433],"class_list":["post-1683","post","type-post","status-publish","format-standard","hentry","category-glenns-technical-insights","tag-glenns-tech-insights"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Glenn&rsquo;s Technical Insights For August 25, 2019 - Glenn Berry<\/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\/glenn\/glenns-tech-insights-for-august-25-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Glenn&rsquo;s Technical Insights For August 25, 2019 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"(Glenn\u2019s Technical Insights\u2026 used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server). It also can just be technically related items that I find interesting. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-26T01:19:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-05T00:09:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mssqltips.com\/tipimages2\/5744_sql-server-2019-overview.004.png\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/\",\"name\":\"Glenn&rsquo;s Technical Insights For August 25, 2019 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mssqltips.com\/tipimages2\/5744_sql-server-2019-overview.004.png\",\"datePublished\":\"2019-08-26T01:19:40+00:00\",\"dateModified\":\"2020-08-05T00:09:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/#primaryimage\",\"url\":\"https:\/\/www.mssqltips.com\/tipimages2\/5744_sql-server-2019-overview.004.png\",\"contentUrl\":\"https:\/\/www.mssqltips.com\/tipimages2\/5744_sql-server-2019-overview.004.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Glenn&rsquo;s Technical Insights For August 25, 2019\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Glenn&rsquo;s Technical Insights For August 25, 2019 - Glenn Berry","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\/glenn\/glenns-tech-insights-for-august-25-2019\/","og_locale":"en_US","og_type":"article","og_title":"Glenn&rsquo;s Technical Insights For August 25, 2019 - Glenn Berry","og_description":"(Glenn\u2019s Technical Insights\u2026 used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server). It also can just be technically related items that I find interesting. [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/","og_site_name":"Glenn Berry","article_published_time":"2019-08-26T01:19:40+00:00","article_modified_time":"2020-08-05T00:09:09+00:00","og_image":[{"url":"https:\/\/www.mssqltips.com\/tipimages2\/5744_sql-server-2019-overview.004.png","type":"","width":"","height":""}],"author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/","name":"Glenn&rsquo;s Technical Insights For August 25, 2019 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mssqltips.com\/tipimages2\/5744_sql-server-2019-overview.004.png","datePublished":"2019-08-26T01:19:40+00:00","dateModified":"2020-08-05T00:09:09+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/#primaryimage","url":"https:\/\/www.mssqltips.com\/tipimages2\/5744_sql-server-2019-overview.004.png","contentUrl":"https:\/\/www.mssqltips.com\/tipimages2\/5744_sql-server-2019-overview.004.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-august-25-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Glenn&rsquo;s Technical Insights For August 25, 2019"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=1683"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1683\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}