{"id":6405,"date":"2025-01-12T19:47:35","date_gmt":"2025-01-12T19:47:35","guid":{"rendered":"https:\/\/tech-setup.com\/?post_type=product&#038;p=6405"},"modified":"2025-01-12T19:47:35","modified_gmt":"2025-01-12T19:47:35","slug":"sql-server-2016-standard","status":"publish","type":"product","link":"https:\/\/tech-setup.com\/?product=sql-server-2016-standard","title":{"rendered":"SQL Server 2016 Standard"},"content":{"rendered":"<h1 id=\"whats-new-in-sql-server-2016\">What&#8217;s new in SQL Server 2016<\/h1>\n<p>With SQL Server 2016, you can build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in, from in-memory performance and advanced security to in-database analytics. The SQL Server 2016 release adds new security features, querying capabilities, Hadoop and cloud integration, R analytics and more, along with numerous improvements and enhancements.<\/p>\n<p>This page provides summary information and links to more detailed SQL Server 2016 what&#8217;s new information for each SQL Server component.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/media\/sql-server-2016.png?view=sql-server-ver16\" alt=\"SQL Server 2016\" data-linktype=\"relative-path\" \/><\/p>\n<p><strong>Try SQL Server today!<\/strong><\/p>\n<ul>\n<li>Download the\u00a0<strong>free<\/strong>\u00a0<a href=\"https:\/\/www.microsoft.com\/sql-server\/sql-server-downloads\" data-linktype=\"external\"><strong>SQL Server newest edition!<\/strong><\/a>.<\/li>\n<li>Download the latest version of\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms?view=sql-server-ver16\" data-linktype=\"relative-path\">SQL Server Management Studio (SSMS)<\/a>.<\/li>\n<li>Have an Azure account? Spin up a\u00a0<a href=\"https:\/\/azuremarketplace.microsoft.com\/marketplace\/apps\/microsoftsqlserver.sql2017-ws2019?tab=Overview\" data-linktype=\"external\">Virtual Machine with SQL Server 2016 already installed<\/a>.<\/li>\n<\/ul>\n<div class=\"heading-wrapper\" data-heading-level=\"h2\">\n<h2 id=\"sql-server-2016-database-engine\" class=\"heading-anchor\">SQL Server 2016 Database Engine<\/h2>\n<\/div>\n<ul>\n<li>You can now configure\u00a0<strong>multiple tempDB<\/strong>\u00a0database files during SQL Server installation and setup.<\/li>\n<li>New\u00a0<strong>Query Store<\/strong>\u00a0stores query texts, execution plans, and performance metrics within the database, allowing easy monitoring and troubleshooting of performance issues. A dashboard shows which queries consumed the most time, memory or CPU resources.<\/li>\n<li><strong>Temporal tables<\/strong>\u00a0are history tables which record all data changes, complete with the date and time they occurred.<\/li>\n<li>New built-in\u00a0<strong>JSON support<\/strong>\u00a0in SQL Server supports JSON imports, exports, parsing and storing.<\/li>\n<li>New\u00a0<strong>PolyBase<\/strong>\u00a0query engine integrates SQL Server with external data in Hadoop or Azure Blob storage. You can import and export data as well as executing queries.<\/li>\n<li>The new\u00a0<strong>Stretch Database<\/strong>\u00a0feature lets you dynamically, securely archive data from a local SQL Server database to an Azure SQL database in the cloud. SQL Server automatically queries both local and remote data in the linked databases.<\/li>\n<li><strong>In-memory OLTP:<\/strong>\n<ul>\n<li>Now supports FOREIGN KEY, UNIQUE and CHECK constraints, and native compiled stored procedures OR, NOT, SELECT DISTINCT, OUTER JOIN, and subqueries in SELECT.<\/li>\n<li>Supports tables up to 2TB (up from 256GB).<\/li>\n<li>Has columnstore index enhancements for sorting and Always On Availability Group support.<\/li>\n<\/ul>\n<\/li>\n<li>New security features:\n<ul>\n<li><strong>Always Encrypted:<\/strong>\u00a0When enabled, only the application that has the encryption key can access the encrypted sensitive data in the SQL Server 2016 database. The key is never passed to SQL Server.<\/li>\n<li><strong>Dynamic Data Masking:<\/strong>\u00a0If specified in the table definition, masked data is hidden from most users, and only users with UNMASK permission can see the complete data.<\/li>\n<li><strong>Row Level Security:<\/strong>\u00a0Data access can be restricted at the database engine level, so users see only what is relevant to them.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div class=\"heading-wrapper\" data-heading-level=\"h2\">\n<h2 id=\"sql-server-2016-analysis-services-ssas\" class=\"heading-anchor\">SQL Server 2016 Analysis Services (SSAS)<\/h2>\n<\/div>\n<p>SQL Server 2016 Analysis Services provides improved performance, authoring, database management, filtering, processing, and much more for tabular model databases based on the\u00a0<strong>1200 compatibility level<\/strong>.<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/machine-learning\/what-s-new-in-sql-server-machine-learning-services?view=sql-server-ver16\" data-linktype=\"relative-path\">SQL Server R Services<\/a><\/strong>\u00a0integrate the R programming language, used for statistical analysis, into SQL Server.<\/li>\n<li>New\u00a0<strong>Database Consistency Checker (DBCC)<\/strong>\u00a0runs internally to detect potential data corruption issues.<\/li>\n<li><strong>Direct Query<\/strong>, which queries live external data rather than importing it first, now supports more data sources, including Azure SQL, Oracle and Teradata.<\/li>\n<li>There are numerous new\u00a0<strong>DAX (Data Access Expressions) functions<\/strong>.<\/li>\n<li>New\u00a0<strong><a href=\"https:\/\/learn.microsoft.com\/en-us\/dotnet\/api\/microsoft.analysisservices.tabular\" data-linktype=\"absolute-path\">Microsoft.AnalysisServices.Tabular<\/a><\/strong>\u00a0namespace manages tabular mode instances and models.<\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/dotnet\/api\/\" data-linktype=\"absolute-path\">Analysis Services Management Objects (AMO)<\/a>\u00a0is re-factored to include a second assembly,\u00a0<strong>Microsoft.AnalysisServices.Core.dll<\/strong>.<\/li>\n<\/ul>\n<p>See\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/analysis-services\/what-s-new-in-analysis-services\" data-linktype=\"absolute-path\">Analysis Services Engine (SSAS)<\/a>.<\/p>\n<div class=\"heading-wrapper\" data-heading-level=\"h2\">\n<h2 id=\"sql-server-2016-integration-services-ssis\" class=\"heading-anchor\">SQL Server 2016 Integration Services (SSIS)<\/h2>\n<\/div>\n<ul>\n<li>Support for\u00a0<strong>Always On Availability Groups<\/strong><\/li>\n<li><strong>Incremental package deployment<\/strong><\/li>\n<li><strong>Always Encrypted<\/strong>\u00a0support<\/li>\n<li>New\u00a0<strong>ssis_logreader<\/strong>\u00a0database-level role<\/li>\n<li>New\u00a0<strong>custom logging level<\/strong><\/li>\n<li><strong>Column names for errors<\/strong>\u00a0in the data flow<\/li>\n<li>New\u00a0<strong>connectors<\/strong><\/li>\n<li>Support for the\u00a0<strong>Hadoop file system (HDFS)<\/strong><\/li>\n<\/ul>\n<p>See\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/integration-services\/what-s-new-in-integration-services-in-sql-server-2016?view=sql-server-ver16\" data-linktype=\"relative-path\">Integration Services (SSIS)<\/a>.<\/p>\n<div class=\"heading-wrapper\" data-heading-level=\"h2\">\n<h2 id=\"sql-server-2016-master-data-services-mds\" class=\"heading-anchor\">SQL Server 2016 Master Data Services (MDS)<\/h2>\n<\/div>\n<ul>\n<li><strong>Derived hierarchy improvements<\/strong>, including support for recursive and many-to-many hierarchies<\/li>\n<li><strong>Domain-based attribute<\/strong>\u00a0filtering<\/li>\n<li><strong>Entity syncing<\/strong>\u00a0for sharing entity data between models<\/li>\n<li>Approval workflows via\u00a0<strong>changesets<\/strong><\/li>\n<li><strong>Custom indexes<\/strong>\u00a0to improve query performance<\/li>\n<li>New\u00a0<strong>permission levels<\/strong>\u00a0for improved security<\/li>\n<li>Redesigned\u00a0<strong>business rules management<\/strong>\u00a0experience<\/li>\n<\/ul>\n<p>See\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/master-data-services\/what-s-new-in-master-data-services-mds?view=sql-server-ver16\" data-linktype=\"relative-path\">Master Data Services (MDS)<\/a>.<\/p>\n<div class=\"heading-wrapper\" data-heading-level=\"h2\">\n<h2 id=\"sql-server-2016-reporting-services-ssrs\" class=\"heading-anchor\">SQL Server 2016 Reporting Services (SSRS)<\/h2>\n<\/div>\n<p>Microsoft has thoroughly revamped Reporting Services in this release.<\/p>\n<ul>\n<li>New\u00a0<strong>web Report Portal<\/strong>\u00a0with KPI feature<\/li>\n<li>New\u00a0<strong>Mobile Report Publisher<\/strong><\/li>\n<li><strong>Redesigned report rendering engine<\/strong>\u00a0that supports HTML5<\/li>\n<li>New treemap and sunburst\u00a0<strong>chart types<\/strong><\/li>\n<\/ul>\n<p>See\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/reporting-services\/what-s-new-in-sql-server-reporting-services-ssrs?view=sql-server-ver16\" data-linktype=\"relative-path\">Reporting Services (SSRS)<\/a>.<\/p>\n<div class=\"heading-wrapper\" data-heading-level=\"h2\">\n<h2 id=\"related-content\" class=\"heading-anchor\">Related content<\/h2>\n<\/div>\n<ul>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/install-sql-server?view=sql-server-ver16\" data-linktype=\"relative-path\">SQL Server setup<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/sql-server-2016-release-notes?view=sql-server-ver16\" data-linktype=\"relative-path\">SQL Server 2016 Release Notes<\/a><\/li>\n<li><a href=\"https:\/\/www.microsoft.com\/licensing\/docs\/view\/SQL-Server\" data-linktype=\"external\">SQL Server Licensing Resources and Documents<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/editions-and-components-of-sql-server-2016?view=sql-server-ver16\" data-linktype=\"relative-path\">Editions and supported features of SQL Server 2016<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/install\/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver16\" data-linktype=\"relative-path\">Hardware and Software Requirements for Installing SQL Server 2016<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/install-sql-server-from-the-installation-wizard-setup?view=sql-server-ver16\" data-linktype=\"relative-path\">Install SQL Server 2016 from the Installation Wizard<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/install-sql-server-servicing-updates?view=sql-server-ver16\" data-linktype=\"relative-path\">Setup and Servicing Installation<\/a><\/li>\n<li><a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/06\/30\/sql-powershell-july-2016-update\/\" data-linktype=\"external\">New SQL PowerShell module<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<ul>\n<li>Delivery: Instant Digital Delivery<\/li>\n<li>Region: World Wide<\/li>\n<li>Devices: 1 Device<\/li>\n<li>Operating System: Windows<\/li>\n<li>Payments: Secure and SSL \u2013 Encrypted<\/li>\n<\/ul>\n<p>Your product will be available immediately and sent to your mail after the purchase.<\/p>\n","protected":false},"featured_media":6406,"comment_status":"open","ping_status":"closed","template":"","meta":[],"pwb-brand":[],"product_brand":[],"product_cat":[45],"product_tag":[],"class_list":{"0":"post-6405","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-windows","8":"first","9":"instock","10":"sale","11":"virtual","12":"purchasable","13":"product-type-simple"},"brands":[],"_links":{"self":[{"href":"https:\/\/tech-setup.com\/index.php?rest_route=\/wp\/v2\/product\/6405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech-setup.com\/index.php?rest_route=\/wp\/v2\/product"}],"about":[{"href":"https:\/\/tech-setup.com\/index.php?rest_route=\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/tech-setup.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6405"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tech-setup.com\/index.php?rest_route=\/wp\/v2\/media\/6406"}],"wp:attachment":[{"href":"https:\/\/tech-setup.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6405"}],"wp:term":[{"taxonomy":"pwb-brand","embeddable":true,"href":"https:\/\/tech-setup.com\/index.php?rest_route=%2Fwp%2Fv2%2Fpwb-brand&post=6405"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/tech-setup.com\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_brand&post=6405"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/tech-setup.com\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_cat&post=6405"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/tech-setup.com\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_tag&post=6405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}