SQL Server 2017 Standard 1 user

What’s new in SQL Server 2017

SQL Server 2017 is an important step in making SQL Server a platform where you have a variety of choices: choose between different development languages and data types, between local application or execution in the cloud, and between different operating systems by improving the performance of SQL Server for Linux, Linux-based Docker container 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 core service for storing, processing and backing up data. The database engine provides controlled access and transaction processing to meet the needs of even the most demanding computing applications in your business. Use the Database Engine in relational databases for Online Transactional Processing (OLTP) or Online Analytical (OLAP) data Processing, Analytical Online Processing). This includes creating tables for data storage and database objects, such as indexes, views, and stored procedures for viewing, managing, and backing up data. Use SQL Server Management Studio to manage the database objects and SQL Server Profiler to record server events.

The 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, which are used by the Reporting Services reports and other data visualization tools. A typical workflow involves creating a multi-dimensional / tabular data model and deploying the model as a database with a local SQL Server Analysis Service or Azure Analysis Service server instance. You can also set up periodic data processing and distribute access permissions on data from end-users. When 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 relationships, and translations are supported.

SQL Server Integration Services

Microsoft Integration Services is a platform for building data integration and data transformation solutions at the enterprise level. You can use Integration Services to solve complex business problems by copying or downloading files, sending e-mails in response to events, updating data warehouses, cleaning up data and data mining, managing SQL Server objects and data. The packages can be used alone or in collaboration with other packages to meet complex business needs. Integration Services can retrieve data from a variety of sources, such as XML data files, flat files, and relational data sources to extract, transform and load the data into one or more destinations. Integration Services includes a variety of built-in tasks and transformations, package building tools, and the Integration Services service to run and manage packages. You can use the Graphical Integration Services tools to build solutions without having to write a single line of code. Or you can program the large Integration Services object model to programmatically create packages and code custom tasks and other package objects.