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 that gives you multiple choices: choose between different development languages ​​and data types, between running locally or in the cloud, and between different operating systems by leveraging the power of SQL Server is deployed for 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 core service for storing, processing and securing data. The database engine provides controlled access and rapid transaction processing to meet the needs of the most demanding data processing applications in your organization. Use the database engine to create 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: B. Indexes, views, and stored procedures for viewing, managing, and securing 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, providing analytical data for business reports and client applications such as Excel, Power BI, used by Reporting Services reports and other data visualization tools. A typical workflow involves creating a multidimensional/tabular data model and deploying the model as a database using a local SQL Server Analysis Service or Azure Analysis Service server instance. Recurring data processing can also be set up and permissions to access end user data can be distributed. When complete, 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, bidirectional relationships, and translations are supported.

SQL Server Integration Services

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformation solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending email messages in response to events, updating data warehouses, cleaning data and data mining, and managing SQL Server objects and data . The packages can be used alone or in conjunction with other packages to meet complex business needs. Integration Services can collect data from a variety of sources, such as: Extract and transform various data files, such as XML data files, flat files, and relational data sources, and then load the data into one or more targets. Integration Services includes a variety of built-in tasks and transformations, tools for creating packages, and the Integration Services service for running and managing them of packages. You can use the Integration Services graphical tools to create solutions without writing a single line of code. Or you can program the rich Integration Services object model to programmatically create packages and code custom tasks and other package objects.