Microsoft SQL Server
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDMS). This is a system that will manage data in a structured two dimensional tabular structure, very similar to a spread sheet, such as Microsoft Office Excel. We refer to the structure as two dimensional tabular structure because your data is organized in a table structure consisting of field names and field values.
What is SQL?
SQL is an industry wide acronym used for Structural Query Language. So what does this really mean? This means that it as a standardized language for relational database management systems (RDMS) that they should adhere to and to perform the following:
- query data out of the database (DB) table or view
- add data to the database (DB) table
- update data to the database (DB) table or view
- remove data from a database (DB) table
What does Microsoft SQL Server bring to the table?
Microsoft SQL Server consist of the following modules based on the version of Microsoft SQL Server you are running:
- Microsoft SQL Server (MSSQL): This is the main component to manage and store your data.
- Microsoft SQL Server Reporting Services (SSRS): This is a management system to store and modify reports based on the data stored in MSSSQL.
- Microsoft SQL Integration Services (SSIS): This an integration management system store and maintain maintenance jobs, and integrating into and to various systems or data sources.
- Microsoft SQL Analysis Services (SSAS): This is the system that will allow you to create data warehouses for business intelligence (BI) interaction and reporting.
Read more on the Microsoft website here.