{"id":16265,"date":"2016-06-29T13:15:38","date_gmt":"2016-06-29T20:15:38","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=16265"},"modified":"2024-01-22T22:52:23","modified_gmt":"2024-01-23T06:52:23","slug":"sql-server-2016-broader-access-better-reporting-faster-analytics","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/","title":{"rendered":"SQL Server 2016: Broader access, better reporting, faster analytics"},"content":{"rendered":"<p>We want to make it easier for businesses to use their data. Otherwise, what\u2019s the point? In SQL Server 2016 you\u2019ll find a virtual tool chest full of features, all with one primary goal: unlocking your data and helping you create new ways of analyzing, visualizing and sharing it.\n<\/p>\n<h2>Building data-rich biz apps<\/h2>\n<p>The advent of machine learning and natural language processing made it easier to analyze unstructured data. The challenge was effectively integrating it with structured data, leading to more meaningful discoveries.<\/p>\n<p>Enter SQL Server PolyBase, a feature in SQL Server 2014 that was specific to the Microsoft Analytics Platform System, through which you could access data in a Hadoop Distributed File System. With SQL Server 2016 we cut the strings, making it possible to query data in Hadoop, as well as Azure Blob Storage. Now you can combine the results of your findings with relational data stored in SQL Server.<\/p>\n<p>But that\u2019s just the beginning. PolyBase becomes a data-rich foundation upon which to build powerful business applications. It dynamically creates columnar tables for your structured data, parallelizes the extraction of data from Hadoop and Azure\u2014even pushing data to Hadoop clusters for additional processing.<\/p>\n<p>Meanwhile, on the front end users can continue using their apps, consuming data and discovering new insights, all without needing to understand the finer points of data base management.<\/p>\n<p>You can install PolyBase in one of two ways: using the SQL Server Installation Wizard or from the command-prompt window. See below for an example of the installation script.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"padding-top: 0px;padding-left: 0px;padding-right: 0px;border-width: 0px\" title=\"Installing PolyBase\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Installing-PolyBase.jpg\" alt=\"Installing PolyBase\" width=\"480\" height=\"96\" border=\"0\" srcset=\"\"><\/p>\n<p>Subsequently, you\u2019ll also need to configure to PolyBase to connect either to Hadoop or Azure Blog Storage, using one of the following values:<\/p>\n<ul>\n<li>0\u2003Disable Hadoop connectivity<\/li>\n<li>1\u2003Hortonworks HDP 1.3 on Windows Server and blob storage<\/li>\n<li>2\u2003Hortonworks HDP 1.3 on Linux<\/li>\n<li>3\u2003Cloudera CDH 4.3 on Linux<\/li>\n<li>4\u2003Hortonworks HDP 2.0 on Windows Server and blob storage<\/li>\n<li>5\u2003Hortonworks HDP 2.0 on Linux<\/li>\n<li>6\u2003Cloudera 5.1 on Linux<\/li>\n<li>7\u2003Hortonworks 2.1 and 2.2 on Linux, Hortonworks 2.2 on Windows Server and blob storage<\/li>\n<\/ul>\n<p>To achieve optimum app performance, even when dealing with larger datasets, consider creating a PolyBase scale-out group. PolyBase scale-out groups include one or more compute nodes, each of which includes a database engine and database movement service, as well as a head node that includes the SQL Server database engine, the PolyBase engine service and the PolyBase movement service. The following diagram gives you a better sense of how PolyBase scale-out groups can keep the data flowing.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"padding-top: 0px;padding-left: 0px;padding-right: 0px;border: 0px\" title=\"Polybase scale out groups\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Polybase-scale-out-groups.png\" alt=\"Polybase scale out groups\" width=\"610\" height=\"500\" border=\"0\" srcset=\"\"><\/p>\n<h2>Advanced analytics, at scale<\/h2>\n<p>For the first time, SQL Server 2016 gives you the ability to work directly with R, introducing a range of new capabilities around advanced analytics, data exploration and modeling.<\/p>\n<p>SQL Server R Services provides a platform for developing intelligent applications that uncover new insights. You can use the rich and powerful R language and the many open source packages to create models and generate predictions using your SQL Server data. Because SQL Server R Services integrates the R language with SQL Server, you can keep analytics close to the data and eliminate the costs and security risks associated with data movement.<\/p>\n<p>With SQL Server R Services you can tap into the robust capabilities of R and combine them with a comprehensive set of SQL Server tools and technologies that offer superior performance, security, reliability and manageability. You can deploy R solutions using convenient, familiar tools, and your production applications can call the R runtime and retrieve predictions and visuals using Transact-SQL. With Enterprise Edition, you also get the Scale R libraries to overcome R\u2019s inherent performance and scale limitations.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"padding-top: 0px;padding-left: 0px;padding-right: 0px;border-width: 0px\" title=\"SQL Server R Services\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/SQL-Server-R-Services.jpg\" alt=\"SQL Server R Services\" width=\"610\" height=\"253\" border=\"0\" srcset=\"\"><\/p>\n<p>To store a procedure you must first serialize it as a hexadecimal string, which is sent to the server and stored in a varbinary(max) column. Check out the sample script:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"padding-top: 0px;padding-left: 0px;padding-right: 0px;border-width: 0px\" title=\"Storing an R procedure\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Storing-an-R-procedure.jpg\" alt=\"Storing an R procedure\" width=\"480\" height=\"227\" border=\"0\" srcset=\"\"><\/p>\n<h2>Making data mobile<\/h2>\n<p>These days, there is so much that can be done with a smart phone and an Internet connection. As such, SQL Server 2016 Reporting Services has made it easier to build concise and consumable mobile reports. And with the Power BI mobile apps you can view, interact with and share data through the Power BI dashboard and SQL Server Reporting Services web portal. Check out this <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/documentation\/powerbi-power-bi-apps-for-mobile-devices\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\" target=\"_blank\" rel=\"noopener\">Power BI blog post<\/a> for the unique capabilities of Power BI for iOS, Power BI app for Android phones and Power BI mobile app for Windows 10.<\/p>\n<p>With the <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/confirmation.aspx?id=50400&amp;wt.mc_id=WW_CE_DM_OO_BLOG_NONE\" target=\"_blank\" rel=\"noopener\">Mobile Report Publisher<\/a> you can create reports based on shared data sources. An extensive array of charts, gauges, grids and other visuals help users gain greater clarity when consuming data via their mobile device. And with navigator elements, users can filter data based on time, date, location or other pre-determined values.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"padding-top: 0px;padding-left: 0px;padding-right: 0px;border-width: 0px\" title=\"SQL Server Mobile Report Publisher\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/SQL-Server-Mobile-Report-Publisher.jpg\" alt=\"SQL Server Mobile Report Publisher\" width=\"610\" height=\"405\" border=\"0\" srcset=\"\"><\/p>\n<p>When designing a report, the Mobile Report Publisher optimizes the report for mobile devices and automatically populates it based on simulated data, allowing you to review with your business user, find the right layout before you connect the report to the data. Once ready, you can import data either from a local file, or from a report server. The first time you select the report server, the \u201cConnect to a Server\u201d prompt appears, at which point you\u2019ll need to enter the following information:<\/p>\n<ul>\n<li>In the Server Address Box: &lt;servername&gt;\/reports, where servername is the name of the server hosting Reporting Services.<br \/>\n<strong>NOTE:<\/strong> If the report server is not configured to use Secure Socket Layer, clear the Use Secure Connection box.<br \/>\n<strong>NOTE:<\/strong> If the data set uses a database login, or if you want to use a different Windows account, clear the Use Current Windows Account box and supply the appropriate credentials.<\/li>\n<\/ul>\n<h2>Summary<\/h2>\n<p>SQL Server 2016 offers a range of new features that transform information into insight and help your employees to make more decisive and strategic decisions, wherever they are. To learn more about the features in SQL Server 2016, download the <a href=\"https:\/\/info.microsoft.com\/Introducing-SQL-Server-2016-eBook.html?wt.mc_id=US_CE_DM_OO_BLOG_&amp;ls=&amp;lsd=\">SQL Server 2016 e-book<\/a>, or visit the\u00a0 <a href=\"https:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server\/?wt.mc_id=US_CE_DM_OO_BLOG_&amp;ls=&amp;lsd=\">SQL Server 2016 product page<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We want to make it easier for businesses to use their data. Otherwise, what\u2019s the point? In SQL Server 2016 you\u2019ll find a virtual tool chest full of features, all with one primary goal: unlocking your data and helping you create new ways of analyzing, visualizing and sharing it. Building data-rich biz apps The advent<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2424],"topic":[],"coauthors":[],"class_list":["post-16265","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-best-practices"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server 2016: Broader access, better reporting, faster analytics - Microsoft SQL Server Blog<\/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.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: Broader access, better reporting, faster analytics - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We want to make it easier for businesses to use their data. Otherwise, what\u2019s the point? In SQL Server 2016 you\u2019ll find a virtual tool chest full of features, all with one primary goal: unlocking your data and helping you create new ways of analyzing, visualizing and sharing it. Building data-rich biz apps The advent\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-29T20:15:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:52:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Installing-PolyBase.jpg\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2016: Broader access, better reporting, faster analytics\",\"datePublished\":\"2016-06-29T20:15:38+00:00\",\"dateModified\":\"2024-01-23T06:52:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/\"},\"wordCount\":972,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Installing-PolyBase.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/\",\"name\":\"SQL Server 2016: Broader access, better reporting, faster analytics - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Installing-PolyBase.jpg\",\"datePublished\":\"2016-06-29T20:15:38+00:00\",\"dateModified\":\"2024-01-23T06:52:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Installing-PolyBase.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Installing-PolyBase.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: Broader access, better reporting, faster analytics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2016: Broader access, better reporting, faster analytics - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: Broader access, better reporting, faster analytics - Microsoft SQL Server Blog","og_description":"We want to make it easier for businesses to use their data. Otherwise, what\u2019s the point? In SQL Server 2016 you\u2019ll find a virtual tool chest full of features, all with one primary goal: unlocking your data and helping you create new ways of analyzing, visualizing and sharing it. Building data-rich biz apps The advent","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2016-06-29T20:15:38+00:00","article_modified_time":"2024-01-23T06:52:23+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Installing-PolyBase.jpg"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2016: Broader access, better reporting, faster analytics","datePublished":"2016-06-29T20:15:38+00:00","dateModified":"2024-01-23T06:52:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/"},"wordCount":972,"commentCount":6,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Installing-PolyBase.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/","name":"SQL Server 2016: Broader access, better reporting, faster analytics - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Installing-PolyBase.jpg","datePublished":"2016-06-29T20:15:38+00:00","dateModified":"2024-01-23T06:52:23+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Installing-PolyBase.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/06\/Installing-PolyBase.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/29\/sql-server-2016-broader-access-better-reporting-faster-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: Broader access, better reporting, faster analytics"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/16265"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=16265"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/16265\/revisions"}],"predecessor-version":[{"id":49619,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/16265\/revisions\/49619"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=16265"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=16265"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=16265"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=16265"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=16265"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=16265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}