SQL Server SQL Server 2017 Editions & Supported Features on Windows & Linux October 23, 20171040 views0 Share By IG Share Microsoft has released SQL Server 2017 Editions to the public for general availability. Its predecessor, SQL Server 2016 has been widely successful. SQL Server 2016 was a significant upgrade from SQL Server 2014, and we expect the same with SQL Server 2017. Even though SQL Server 2017 is released for both Linux and Windows platforms, the editions remain mostly the same. Check them out! SQL Server 2017 Editions All the significant editions remain unchanged, which is a good thing. It maintains an easy upgrade path for customers willing to upgrade to the new version without much confusion. It is particularly true for Software Assurance (SA) customers who typically get a free upgrade to the next major release. So here they are! Enterprise: Comprehensive, high-end capacities for commanding database and business intelligence essentials. Standard: Core data management and business intelligence abilities for non-critical workloads with minimal IT support. Express: Easy to get started, unrestricted to use for ISV redistribution and embedding. Developer: Free (for MSDN subscribers) version where customers can build, test, and demo apps in non-production environments. All Enterprise Editions are included as usual. The SQL Server 2017 Standard is useful for mid-segment customers, running medium workloads. Some of the most notable features are as follows: End-to-end database security with Always Encrypted Enhanced in-memory performance for all workloads Basic reporting Basic analytics Hybrid scenarios: Stretch Database, backup The SQL Server 2017 Edition is targeted at the top-tier segment where performance is critical. Here are some of its features: Mission critical high availability on both Windows and Linux based servers. Enhanced in-memory performance for both OLTP and Data warehousing workloads. Faster performance with ‘Adaptive-Query‘ Processing Unmatched data security Petabyte-scale data warehousing scalability. End-to-end mobile BI with rich visualizations available on all major platforms including iOS and Android. In-database advanced analytics built-in at scale with R and Python Enhanced hybrid scenarios including Stretch Database, HA, DR, and backup Software Assurance (SA) benefits include unlimited virtualization, Machine Learning (ML) Server for Hadoop, and Power BI Report Server Conclusion SQL Server 2017 Editions for both Linux and Windows is a massive shift for Microsoft. We expect many Enterprise customers to jump on the SQL Server bandwagon with this release. Disclaimer: The Questions and Answers provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0 IG Website Twitter
TSQL How to Effectively split a string using STRING_SPLIT function in SQL server By DataGeekApril 15, 2019
SQL Server SQL Server 2019 System Requirements – Hardware & Software Prereqs In this article, we will be sharing the SQL Server 2019 System Requirements based on ...
Interview Questions T-SQL Performance Tuning on Bulk Load Data in SQL Server 2017 In this article, we are going to talk about a specific scenario where T-SQL Performance ...
SQL Server How To Check & Fix Index Fragmentation on SQL Server via Script & ssms Before we learn to fix Index fragmentation on SQL Server, let us understand why this ...
SQL Server Fixing SQL Server Max Worker Threads: error: 35217, severity: 16, state: 1 If you try fixing SQL Server Max Worker Threads for errors such as: “The thread pool ...