Skip to main content

Posts

Showing posts from September, 2023

SQL server

  Microsoft SQL Server: Microsoft SQL Server is a relational database management system (RDBMS). Applications and tools connect to a SQL Server instance or database, and communicate using Transact-SQL (T-SQL). You can install SQL Server on Windows or Linux, deploy it in a Linux container, or deploy it on an Azure Virtual Machine. SQL Server components and technologies: Database Engine The Database Engine is the core service for storing, processing, and securing data. The Database Engine provides controlled access and transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise.  Integration Services SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including packages that provide extract, transform, and load (ETL) processing for data warehousing. Analysis Services SQL Server Analysis Services (SSAS) is an analytical data platform and toolset for personal, team, and c