In this article I demonstration
on SQL Server Services.
SQL Server provide 5 type of services,
1] Database Engine.
2]Analysis Service.
3]Reporting Service.
4]Compact Edition.
5] Integration Services.
SQL Server contains two database.
A)OLTP(Online Transaction
Processing):-
This
database contains Normalized data i.e.redudency or data Repetition will be less
or duplicate data will be less.
B)OLAP(ON-LINE Analytical Processing):-
It contains demoralized data i.e. redundancy
will be there .this database will be used in analysis server or data
warehousing.
Lets learn all these things in details.
1)Database Engine :-
It is default
server type .it is used to store managed
and to access the data from Database.
2)Analysis Services :-
It is used to
create cubes .it is used to show data in multiple dimention and used to show
data in hierarchical view or preview and used to display KPIS (Key Performance Indicator)and used to apply translation in
translation default language is English
U.S.
3)Reporting Services :-
Reporting
Services is a reporting tool used to generate reports in various formats.
A]Standard
:-
It is used to show the
report in the form of List.
B]AD-Hoc
:-
It is used to create report
template or Report model and when it is used by client it will be necessary
changes and will be used.
c]Embedded:-
the reports will be given
to development team they will integrate in DOTNET Project.
4]Compact
Edition :-
It is used to developed
mobile application.
5]Integration
Services :-
It is used to convert data from one format to
another.SQL Server tables can be convert into oracle,MYSQL ,MS Access table and
we can convert “table” to “textfile” or
“textfile” to “table”.in this 27 transaformation can be done.it is called as
ETL(Extract Transform Load)Tool.
If
you want to learn more Details on MSBI
then read my next article,
If
you have any query then frankly leave mail me dotnetbyabhipatil@gmail.com
For more article visit my blog
http://dotnetbyabhipatil.blogspot.in
Abhijit Patil is a Founder of Dotnetbyabhipatil ,he Passionate on Technology ,He have 3 Award on dotnetspider Including Golden. He got 2nd Time MVP(Most Valuable Professional) award at Delhi International Conference on C# Corner. also Chapter Lead of C# Corner Pune Chapter.
ConversionConversion EmoticonEmoticon