We will first start with SQL Server Integration Services. SQL Server analysis will be covered later. We will also be discussing Reporting Services, Power BI Report Server and machine learning services.
SQL Server Services and their use with data science
SQL Server Integration Services
SQL Server Integration Services (SSIS) was first introduced with SQL Server 2005, which was a major release, where Microsoft revised most of the Sybase code into Microsoft code. Numerous changes did happen in the background of the SQL Server and three main business intelligence services were introduced, SSIS being one of them. The concept of integration service used with SQL Server was, however, introduced with SQL Server 7.0, known as Data...
