What is Microsoft SQL Server
SQL Server is a relational database engine from Microsoft that has supported business applications for decades. Over time the Microsoft SQL Server relational database management system (RDBMS) has grown to include several new technologies including the items listed below. SQL Server 2022 is the latest version.
SQL Server Relational Engine – Data storage, management and real-time query processing
SQL Server Agent – Scheduling and notification engine that ships with the relational engine
SQL Server Integration Services (SSIS) – Export, import, transformation and loading of data
SQL Server Reporting Services (SSRS) – Report authoring, management and delivery toolset
SQL Server Analysis Services (SSAS) – Build, manage, analyze, aggregate and roll-up data for Business Intelligence
Power BI – Reporting tool with both desktop and cloud based options
SQL Server Management Studio (SSMS) – Administration and development tool for SQL Server