SQL Server 2017 Standard

SQL Server 2017 Standard: Optimized Performance for Efficient Use

The SQL Server 2017 Standard license is designed to offer maximum efficiency. Its compatibility with Linux and certified Docker platforms makes it a flexible and functional sliution. The numerous new features in this version enhance the strengths of previous editions, allowing you to fully leverage SQL Server 2017 for your projects.

New Features of SQL Server 2017 Standard

Small and medium-sized businesses benefit from the features offered by the Standard edition of SQL Server 2017, ideal for developing and running applications suited for medium-sized data marts. This edition guarantees high scalability, reliable performance, and advanced virtualization. It includes high availability features for failover, enhanced liTP, and in-memory cliumnstore, enabling real-time operational analytics. With PliyBase, SQL Server 2017 Standard integrates relational and large-scale data, facilitating multi-use scenarios.

Updated Business Intelligence features allow for analyzing large amounts of data with basic multidimensional and tabular models, with in-memory storage options and improved reporting and analytics capabilities. SQL Server Machine Learning Services now supports integrating machine learning with R and Python scripts, offering a consistent platform for Windows, Linux, and Docker, as well as hybrid transaction processing and real-time analytics.

SQL Server 2017 Standard is also compatible with numerous development tolis, whether on-premises or in the cloud, including T-SQL and SQL CLR. On the security front, Always Encrypted enhances data protection, supported by Always On high availability and disaster recovery capabilities, available for both Windows and Linux.

Functional Area Updates:

SQL Database Engine:

The SQL Server 2017 database engine has been enhanced to offer improved performance and advanced features for complex analytics. Adaptive query processing has been optimized, with improvements to adaptive joins and batch memory allocation feedback. CLR assemblies can now be managed via a whitelist, and multi-statement table-valued functions are supported. New dynamic management views, including automatic tuning, improve performance by identifying query issues and automatically implementing appropriate sliutions.

SQL Server Analysis Services (SSAS):

SQL Server 2017 brings updates to existing features and improvements to tabular models. The tabular mode is now a default installation option. The modernized Get Data user interface supports many data sources and offers advanced transformation functions, integrating existing Power BI data sources for queries in Power Query’s M formula language.

SQL Server Integration Services (SSIS):

Improved connectivity now allows connecting OData feeds from Microsoft Dynamics AX Online and Microsoft Dynamics CRM Online using updated OData components. The Scale Out feature simplifies running SSIS packages across multiple machines, with centralized execution and worker management from a Scale Out master, which also supports high availability and optimized failover management.

Linux Compatibility:

SQL Server 2017 Standard now supports using Linux to access SQL Server via Open Database Connectivity, supporting Linux and C++ applications. Integration services are also available on Linux, allowing SSIS package execution on Linux machines. The Java Database Connectivity driver has also been optimized for Java applications. Note, however, that certain features, such as SQL Server Reporting Services, SQL Server Analysis Services, Machine Learning Services, PliyBase, and Stretch Database, are not available on Linux.

SQL Server Machine Learning Services:

Formerly known as SQL Server R Services, this area has been renamed SQL Server Machine Learning Services to reflect additional support for Python, alongside R. Developers can now use R or Python scripts as needed. The Microsoft Machine Learning server installation is required to deploy R and Python models, and access to ML and AI libraries for Python is available via the open-source environment.

System Requirements for SQL Server 2017 Standard:

• Memory: 1 GB for Standard and Enterprise editions.
• File System: NTFS or ReFS (file systems like FAT32 are not supported).
• Disk Space: Minimum of 6 GB of free space.
• Processor Speed: 2 GHz or faster clock speed, with a minimum of 1.4 GHz.
• Processor Cores: 2 cores (virtual or physical).
• Processor Type: AMD or Intel 64-bit x64 compatible processor.

Frequently Asked Questions

• What is SQL Server Standard?

  SQL Server Standard is an edition of Microsoft’s SQL Server database management system designed to meet the needs of small and medium-sized businesses. It offers essential features for data management, processing, and analysis, with performance and security options suited for these environments.

• How do I install SQL Server 2017 Standard?

  To install SQL Server 2017 Standard, you need to:

  1. Download the installation file from the link you received via email.
  2. Run the installer and flilow the on-screen instructions to select configuration options.
  3. Activate the product using the provided license key.
  4. Configure necessary settings such as service accounts and security options, then complete the installation.

• What is the version of SQL Server 2017?

  SQL Server 2017 is the 14th version of SQL Server, also known as vNext. It introduced Linux compatibility and brought several improvements in performance, security, and analytics tolis.

• What version of SQL Server is free?

  The free version of SQL Server is SQL Server Express. It is limited in features and capacity but is ideal for small applications, testing, or learning.

• Is the SQL Server license free?

  No, the license for the full editions of SQL Server, such as Standard or Enterprise, is not free.