=> What is SQL Server ?
------------------------------------------------------------------------------
SQL Server is a Client/Server relational database used to store large amount of data or information . SQL Server will works in stand alone computer and will works in any network.
Networks are classified into three types.
1) Intranet (Local Area Network (LAN))
2) Extranet (Metropolitan Area Network (MAN))
3) Internet (Wide Area Network (WAN))
SQL Server can be used as back end tool or software for any .net project or application. It is used to store and manage the data related to application or projects.
=> Server type in SQL Server
------------------------------------------------------------------
There are several type of Server in SQL.
1. Database Engine:
-----------------------
It is default server type. It is used to store ,Manage and to access the data from database. It will work with online transaction processing database. This server contains normalized data and it is used for current data store.
2. Analysis Services :
--------------------------
It is used to work with data warehouse. It is used to maintain the data related to old business. It will work with online analytical process. this database contains de-normalized data and used to maintain historical data which is for 10-15 years.
3. Reporting Services :
---------------------------
It is reporting tool used to generate reports in various formats. It can contain report tittle, date & time , page number, Sub total,Grand total etc. And report can be exported to other formats like MS-excel, MS-Word, PDF etc.
Type of reports:
--------------------
a) Standard
It is used to display report in a form of list.
b) Ad-hoc Report
It is a report model on report template and the client can used the report only after necessary changes are made according to their requirement.
c) Embedded reports
These are integrated in projects. it can be windows application or website.
4. Integration Services:
----------------------------
It is used to transform or used to convert the data from one format to another format. It is used to convert SQL server tables to oracle, My SQL & Ms-Access tables.
In IS(Integrated Services) 27 transformation or conversion can be done and it is called ETL(Extract Transformation Load) tool.
System database in SQL Server
---------------------------------------------------------------------------------
1. master :
------------
It is used to perform user and administrative task in sql server. And used to manage sql server i.e the programmer which are used to works with sql server will be in master database.
2. Model :
------------
It is the template for new database on the properties of model database, New database will be created.
3. Msdb : (Microsoft database)
-----------
It is used to store job history. job history will contain the SQL commands executed by the user will be store in job history. it is used for data recovery.
4. tempdb : (temporary database)
---------------------------------------
when ever SQL server is started then tempdb will be created and when SQL server or management studio is closed then it will be deleted. It will exist as long as work with SQL server . It is used to store temporary tables and temporary stored procedure.
Database Architecture
---------------------------------------------------------
SQL server can contain 32767 databases. In database architecture every database will contains two files.
No comments:
Post a Comment