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 summarises the innovations 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. The 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 even the most demanding data processing applications in your organisation.
Use the 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 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 customer applications such as Excel, Power BI, used by Reporting Services reports and other data visualisation tools. A typical workflow includes the creation of a multi-dimensional or tabular data model. Deploying the model as a database using an on-premises SQL Server Analysis Services or Azure Analysis Services server instance, setting up and assigning recurring data processing to allow permissions to access data from end users. When complete, your semantic data model can be accessed by all client 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, go 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 in conjunction 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 contains 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 programme 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 optimisation
- SQL Server Machine Learning Services
- Integration Services Design Platform
- New dynamic management views
- SQL Server 2017 Reporting Services
- No time limit on usage