MicroSoft SQL server

default port 1433

lifecycle

5 years in mainstream support

• Mainstream support includes functional, performance, scalability, and security updates

5 years in extended support

• Extended support includes only security updates.

Multi-tenant: Instance

named instances (Oracle PDB)

• You can install multiple named instances on the same host, each with its own configuration (port, mssql server version, collations, startup options) and security settings (service accounts)
• SQL Server uses the SQL Server Browser service to dynamically assign ports to named instances

default instance (Oracle CDB)

Legacy download

2017 developer

Download SQL Server Management Studio (SSMS) 20.1

SQL Server Integration Services (SSIS)

a component of the Microsoft SQL Server used to perform data integration.

• tags: data migration, workflow apps, data warehouse, ETL
• initial released with Microsoft SQL Server 2005, replacing Data Transformation Services (DTS)
• Developers tasked with creating or maintaining SSIS packages use SQL Server Data Tools - Business Intelligence