Microsoft SQL Server 2017 Standard

Microsoft SQL Server 2017 Standard

What’s new in SQL Server 2017

SQL Server 2017 represents an important step in making SQL Server a platform where you have more choices: Choose between different development languages and data types, between running locally or in the cloud, and between different operating systems by providing the power of SQL Server to Linux, Linux-based Docker containers and Windows.

SQL Server 2017 database engine

SQL Server-2017 includes many new database engine features, enhancements and performance improvements. The Database Engine is the central service for storing, processing and backing up data. The Database Engine provides controlled access and fast transaction processing to meet the needs of the most demanding data processing applications in your organisation. Use the Database Engine to create relational databases for OLTP (Online Transactional Processing) or OLAP (Online Analytical Processing) data. This includes the creation of tables for storing data and database objects, such as indexes, views and stored procedures, for visualising, managing and saving data. Use SQL Server Management Studio to manage database objects and SQL Server Profiler to log server events.

Analysis Services

Analysis Services is an analytical data module in Decision Support and Business Analytics that provides analytical data for business reports and client applications such as Excel, Power BI, used by Reporting Services reports and other data visualisation tools. A typical workflow includes creating a multidimensional/tabular data model and distributing the model as a database using a local instance of SQL Server Analysis Service or Azure Analysis Service. Likewise, recurring data processing can be set up and permissions distributed to access the data by end users. Once completed, your semantic data model can be claimed as a data source by all client applications supported by Analysis Services. Analysis Services is now available in the cloud and as an Azure service. Azure Analysis Services supports tabular models with compatibility level 1200 or higher. DirectQuery, partitions, row-level security, bi-directional relations and translations are supported.

SQL Server Integration Services

Microsoft Integration Services is a platform for building enterprise-wide data integration and transformation solutions. Integration Services are used to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, data cleansing and data mining, and managing SQL Server objects and data. The packages can be used alone or in combination with other packages to meet complex business needs. Integration Services can extract and transform data from a variety of sources, such as XML data files, flat files and relational data sources, and then load the data into one or more objects. Integration Services includes a variety of built-in tasks and transformations, tools to create packages, and the Integration Services service to execute and manage packages. You can use Integration Services’ graphical tools to create solutions without writing a single line of code. Or you can programme Integration Services’ rich object model to create packages programmatically and code custom tasks and other package objects.

System requirements:

Operating system: Windows 8 and higher, Windows Server 2012 and higher, Linux and higher.
Processor: at least one x64 processor with 1.4 GHz (2.0 GHz recommended)
Memory: at least 1 GB (4 GB recommended)
Hard disk space: 6 GB
Graphics card: Super VGA card, resolution of at least 800 x 600 px