Summary

There are numerous services that make up the whole SQL Server environment, which you can run either on-premise or in the cloud. The core of the SQL Server is a database management system, which stores the data and provides us with the data operation engine, but the data also has to come in the SQL Server and it needs to be analyzed and represented. Therefore, we have companion services, such as Integration Services, which provide us the ETL solution for importing and cleaning the data before storing it on the SQL Server, Analysis Services, which is used for multidimensional modeling and data mining, and Reporting Services, which is a visualization part of the whole stack. No matter whether you choose the on-premise approach or the cloud services, there are always a number of offerings from the SQL Server that you can utilize for data science.