 |
| SQL SERVER TYPE IN SSMS |
In SQL server,server is a also called services why because every services act like server.there are some type of SQL server.
 |
| 1.Server type |
 |
| 2.Business Intelligence tool studio |
 |
| 3.SSMS |
1.Database Engine:
- It is core component of SQL server ( core server).The core is nothing but main server.
- The purpose of using database engine:
- Store : Tables formate (Row & Column)
- processing : Perform some operation ( Insert,Update,Delete)
- Security : To data
2.Analysis services (SSAS):
- It is a MSBI tool and this MSBI tool use for data warehousing the purpose of storing the data.
- Database engine is store the data in two dimensional but they want to convert into three dimensional thats why we use analysis services.
- When ever we want to convert our 2D formate to 3D formate then we use the analysis services.
3.Reporting services (SSRS):
- Reporting is nothing but document to store some information and we need to document.
- To store the business related document then we use the reporting services.
- When ever we export the data from database that time we need a SSRS tool.
4.Intregration services (SSIS):
- When ever we need to send information or data from one database to another database at that time we need the intregration services.
- For this we need MSBI tool then it will converting from database tables in another database understandable formate.
