{"id":14581,"date":"2015-12-01T11:00:00","date_gmt":"2015-12-01T19:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/"},"modified":"2024-01-22T22:50:22","modified_gmt":"2024-01-23T06:50:22","slug":"get-the-most-out-of-sql-server-2016","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/","title":{"rendered":"Get the most out of SQL Server 2016"},"content":{"rendered":"<p><em>Blog post series to highlight new features and enhancements available with SQL Server 2016.<\/em><\/p>\n<p>Data, and the ability to extract actionable intelligence from it, is driving transformation in how we do business today. With SQL Server 2016, it\u2019s never been easier to capture, transform, mash-up, analyze and visualize any data, of any size, at any scale in its native format. Plus, you can do all of this while using familiar tools, languages and frameworks in a trusted environment, both on-premises and in the cloud \u2014 with what Corporate Vice President of Microsoft\u2019s Data Group Joseph Sirosh calls \u201c<a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/10\/28\/sql-server-2016-everything-built-in?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">the best SQL Server release in history<\/a>.\u201d\u00a0SQL Server comes packed with powerful built-in features.<\/p>\n<p><strong>In our upcoming SQL Server 2016 post series, kicking off December 3, 2015, you can learn about our new technologies, discover best practices, and gain product insights from the engineers who built it. Our engineers are lined up to share specifics from their area of expertise.<\/strong><\/p>\n<p>The series will cover:<\/p>\n<ul>\n<li>\n<strong>App and data performance features:<\/strong> Discover enhancements of In Memory OLTP and real-time Operational Analytics.<\/li>\n<li>\n<strong>Data security features:<\/strong> Learn about Always Encrypted technology, an industry-first that helps protect data at rest and in motion, on-premises and in the cloud.<\/li>\n<li>\n<strong>Business intelligence:<\/strong> Gain insights into rich visualizations as we cover SQL Server 2016\u2019s BI capabilities and additions, including the upcoming release of Mobile BI resulting from our Datazen acquisition.<\/li>\n<li>\n<strong>Big Data and analytics:<\/strong> Uncover ways to use Advanced Analytics, including a walk-through of how to use R, the popular Big Data scientist language which is now a part of SQL Server. We\u2019ll also provide details on PolyBase, which allows you to extract value from unstructured and structured data using your existing T-SQL skills.<\/li>\n<li>\n<strong>Hybrid and cloud:<\/strong> Learn about SQL Database, backup improvements and Stretch Database, which enables stretching a single database between on-premises and Azure.<\/li>\n<\/ul>\n<p>Read the current posts from this blog series:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/03\/sql-server-2016-advanced-capabilities-without-expensive-add-ons?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">SQL Server 2016: Advanced Capabilities without Expensive Add-Ons<\/a><\/li>\n<li><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/08\/speeding-up-business-analytics-using-in-memory-technology?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Speeding up Business Analytics using In-Memory Technology<\/a><\/li>\n<li><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/09\/real-time-operational-analytics-using-in-memory-technology?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Real-Time Operational Analytics Using In-Memory Technology<\/a><\/li>\n<li><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/speeding-up-transactions-with-in-memory-oltp?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Speeding up Transactions with In-Memory OLTP in SQL Server 2016 and Azure SQL Database<\/a><\/li>\n<li><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/15\/enhanced-always-on-availability-groups-in-sql-server-2016?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Enhanced Always On Availability Groups in SQL Server 2016<\/a><\/li>\n<li><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/16\/tuning-workload-performance-with-query-store?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Tuning Workload Performance with Query Store<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/01\/05\/json-in-sql-server-2016-part-1-of-4\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">JSON in SQL Server 2016: Part 1 of 4<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/01\/06\/json-in-sql-server-2016-part-2-of-4\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">JSON in SQL Server 2016: Part 2 of 4<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/01\/07\/json-in-sql-server-2016-part-3-of-4\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">JSON in SQL Server 2016: Part 3 of 4<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/01\/08\/json-in-sql-server-2016-part-4-of-4\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">JSON in SQL Server 2016: Part 4 of 4<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/01\/11\/effortlessly-analyze-data-history-using-temporal-tables-2\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Effortlessly Analyze Data History Using Temporal Tables<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/01\/14\/data-security-sql-server-2016-and-your-business\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Data security, SQL Server 2016, and your business<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/01\/21\/limiting-access-to-data-using-row-level-security\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Limiting access to data using Row-Level Security<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/01\/25\/use-dynamic-data-masking-to-obfuscate-your-sensitive-data\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Use Dynamic Data Masking to obfuscate your sensitive data<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/02\/04\/keeping-up-with-the-data-needs-of-the-business-with-sql-server-2016\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Keeping up with the data needs of the business with SQL Server 2016<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/03\/16\/enable-business-insights-for-everyone-with-sql-server-2016-part-1\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Enable business insights for everyone with SQL Server 2016: Part 1<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/03\/17\/enable-business-insights-for-everyone-with-sql-server-2016-part-2\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Enable business insights for everyone with SQL Server 2016: Part 2<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/03\/22\/decisions-the-speed-of-thought-with-sql-server-2016\/\">Decisions @ the speed of thought with SQL Server 2016<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/03\/22\/expanding-the-data-footprint-of-sql-server-2016-with-polybase\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Expanding the data footprint of SQL Server 2016 with PolyBase<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/03\/29\/in-database-advanced-analytics-with-r-in-sql-server-2016\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">In-database Advanced Analytics with R in SQL Server 2016<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/04\/05\/security-and-flexibility-with-sql-server-2016s-hybrid-cloud-solutions\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Security and flexibility with SQL Server 2016\u2019s hybrid cloud solutions<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/04\/07\/deliver-modern-reports-with-sql-server-2016-reporting-services\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Deliver modern reports with SQL Server 2016 Reporting Services<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/04\/13\/keep-data-virtually-forever-with-stretch-database-in-sql-server-2016\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Keep data virtually forever with Stretch Database in SQL Server 2016<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/04\/19\/sql-server-2016-cloud-backup-and-restore-enhancements\/?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">SQL Server 2016 cloud backup and restore enhancements<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-14851\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png\" alt=\"Try SQL Server 2016 RC\" width=\"300\" height=\"57\" srcset=\"\"><\/a><\/p>\n<p>Have questions? Join the discussion of the new SQL Server 2016 capabilities at <a href=\"https:\/\/social.msdn.microsoft.com\/Forums\/sqlserver\/en-US\/home?forum=SQLServer2016Preview?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">MSDN<\/a> and <a href=\"http:\/\/stackoverflow.com\/nocaptcha?s=5a374126-5bd0-4db0-ad9f-a0af06e68e7e?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">StackOverflow<\/a>. If you run into an issue or would like to make a suggestion, you can let us know using <a href=\"https:\/\/connect.microsoft.com\/SQLServer?wt.mc_id=WW_CE_DM_OO_BLOG_NONE\">Microsoft\u2019s Connect tool<\/a>. We look forward to hearing from you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Blog post series to highlight new features and enhancements available with SQL Server 2016. Data, and the ability to extract actionable intelligence from it, is driving transformation in how we do business today.<\/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":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2424],"topic":[2451,2475],"coauthors":[2487],"class_list":["post-14581","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-best-practices","topic-big-data","topic-oltp-database-management","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-4-1593580446-456","review-flag-alway-1593580309-407","review-flag-never-1593580314-843","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Get the most out of SQL Server 2016 - 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\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get the most out of SQL Server 2016 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Blog post series to highlight new features and enhancements available with SQL Server 2016. Data, and the ability to extract actionable intelligence from it, is driving transformation in how we do business today.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/\" \/>\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=\"2015-12-01T19:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png\" \/>\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=\"2 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\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Get the most out of SQL Server 2016\",\"datePublished\":\"2015-12-01T19:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/\"},\"wordCount\":554,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/\",\"name\":\"Get the most out of SQL Server 2016 - 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\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png\",\"datePublished\":\"2015-12-01T19:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get the most out of SQL Server 2016\"}]},{\"@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":"Get the most out of SQL Server 2016 - 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\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/","og_locale":"en_US","og_type":"article","og_title":"Get the most out of SQL Server 2016 - Microsoft SQL Server Blog","og_description":"Blog post series to highlight new features and enhancements available with SQL Server 2016. Data, and the ability to extract actionable intelligence from it, is driving transformation in how we do business today.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-12-01T19:00:00+00:00","article_modified_time":"2024-01-23T06:50:22+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png","type":"","width":"","height":""}],"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":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Get the most out of SQL Server 2016","datePublished":"2015-12-01T19:00:00+00:00","dateModified":"2024-01-23T06:50:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/"},"wordCount":554,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/","name":"Get the most out of SQL Server 2016 - 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\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png","datePublished":"2015-12-01T19:00:00+00:00","dateModified":"2024-01-23T06:50:22+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2016\/03\/DPI-Blog_RC_Button1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/01\/get-the-most-out-of-sql-server-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Get the most out of SQL Server 2016"}]},{"@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"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/14581","targetHints":{"allow":["GET"]}}],"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=14581"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/14581\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=14581"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=14581"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=14581"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=14581"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=14581"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=14581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}