Why SQL Server 2017
SQL Server 2017 represents an important step in making SQL Server a platform where you have multiple choices: Choose between different development languages and data types, between running locally or in the cloud, and between different operating systems by delivering the power of SQL Server to Linux, Linux-based Docker containers, and Windows. The following summarizes the new features for specific functional areas and provides links with additional details.
SQL Server 2017 database engine
SQL Server 2017 includes many new Database Engine features, enhancements and performance improvements. Database Engine is the core service for storing, processing, and backing up data. Database Engine provides controlled access and fast transaction processing to meet the needs of the most demanding data processing applications in your organization.
Use Database Engine to create relational databases for online transactional processing (OLTP) or online analytical processing (OLAP) data. This includes creating tables for data storage and database objects, such as indexes, views, and stored procedures, for viewing, managing, and saving data. Use SQL Server Management Studio to manage database objects and SQL Server Profiler to record server events.
Analysis Services is an analytical data module in Decision Support and Business Analytics that provides analytical data for business reports and customer applications such as Excel, Power BI, used by the Reporting Services reports and other data visualization tools. A typical workflow includes the creation of a multi-dimensional or tabular data model. Deploy the model as a database using an on-premises SQL Server Analysis Services or Azure Analysis Services server instance, set up and assign recurring data processing to allow permissions to access data from end users. When complete, your semantic data model can be accessed by all customer applications that receive support from Analysis Services as a data source. 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. To learn more about the service and try it for free, head over to Azure Analysis Services.
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, cleansing data and data mining, and managing SQL Server objects and data. The packages can be used alone or together 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 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 packages. You can use the graphical Integration Services 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.
- Licensing per server / CALs required
- Automatic database optimization
- SQL Server Machine Learning services
- Integration Services design platform
- New dynamic management views
- SQL Server 2017 Reporting Services
- No time limit on usage