> Code Storage: developing tool

Code Storage

A Technical blog for those who want to gain knowledge about SQL,MySQL,Data Science and real time query

Responsive Ads Here

Advertisement

Showing posts with label developing tool. Show all posts
Showing posts with label developing tool. Show all posts

Wednesday, April 28, 2021

SEVER TYPE IN SSMS ( Sql Server Managment studio)

When you install the SQL Server management studio and then you want to connect with the SQL Server then there are four types of SQL servers are there, and what is the work of that four types of SQL servers. when we have to use that server. let's see what are they:-
  1. Database Engine
  2. Analysis Services
  3. Reporting Services
  4. Integration Services     

  1. Database Engine:- It is a core component of the database engine here core means the main component of the SQL Server management studio. there are have some purposes to use this database engine. the first purpose is to store the data or table which means rows and columns. the second one is processing means after storing the data we have to perform some operations like insert, delete, update. and the third one is security means to provide security to our data.
  2. Analysis Services:- It is an MSBI Tool (business intelligence management tool) and we have to use this tool in the data warehousing for the data storing purpose. Analysis services have to convert the data from 2D( two dimensional ) or tables (rows & columns) to the 3D(three dimensional) formate means graphical formate.
  3. Reporting Services:- It is also called MSBI Tool or SSRS (SQL Server reporting services).reporting services to store the report or document about the company businesses. To use the reporting services can export the data from database engine to the other platform like (MS Word, MS Excel), etc. When you need to export the data from a database to another platform you can use reporting services.
  4. Integration Services:- It is also called MSBI Tool or SSIS (SQL Server integration services). Integration services are used to converting database tables for another database understandable format. This means if you are working in SQL Server database and then you want to convert into another database like the oracle at that time use the integration services.

Tuesday, April 28, 2020

SQL Server Type? Microsoft SQL Server Management Studio

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
SSAS, SSRS , SSIS tools we called as a MSBI Tools to intreat with MSBI tool we need a developing tool that developing tool is a BIBS.

2.Business Intelligence tool studio
To interact with database engine we need a developing tools that developing tool is SSMS.
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:


  1. Store          : Tables formate (Row & Column)
  2. processing : Perform some operation ( Insert,Update,Delete)
  3. 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.



SEVER TYPE IN SSMS ( Sql Server Managment studio)

When you install the SQL Server management studio and then you want to connect with the SQL Server then there are four types of SQL servers ...