Microsoft SQL Server is a RDMS software ppackage developed by Microsoft. Its a database, so its primary function is to store and retrieve data as requested by other applications.
A DBMS package is a complex set of Software Programs that Controls the organization, storage and modifying and retrieval of data in a database:
· It contains collection of data.
· Set of programs to access those data.
· A complete definition of the database structure and constrain.
Overview of Microsoft SQL Server and Version Details.
9.0
|
2005
|
SQL Server 2005
|
Yukon
|
10.0
|
2008
|
SQL Server 2008
|
Katmai
|
10.25
|
2010
|
SQL Azure DB
|
CloudDB
|
10.5
|
2010
|
SQL Server 2008 R2
|
Kilimanjaro (aka KJ)
|
11.0
|
2012
|
SQL Server 2012
|
Denali
|
Database users:
1.Database Administrator:
· Database is one of the many primary resources that are used by many people in an organization.
· DBMS and related software are the secondary resources. Administrating this secondary resources is the primary responsibility of a Database administrator.
· He has the complete authority to access and monitoring a database .
· He is responsible for for creating modifying and maintain the database
· He grant permission to the users of the database .
· He defines procedure to recover database
Other users
2.Database designer
3.End Users
Ok Now Lets work on everyday work of a DBA. As in current world role of DBA is evolving very fast.
you can be taking care of Application and then will be called as application DBA. Your databases can be hosted in cloud in various cloud technologies for microsoft its Azure . Then you will be called as Cloud DBA and many more but if I drill down we all DB administrator gets few common issues which i will discuss as those comes under everyday tasks for most dba's.
Ok Now Lets work on everyday work of a DBA. As in current world role of DBA is evolving very fast.
you can be taking care of Application and then will be called as application DBA. Your databases can be hosted in cloud in various cloud technologies for microsoft its Azure . Then you will be called as Cloud DBA and many more but if I drill down we all DB administrator gets few common issues which i will discuss as those comes under everyday tasks for most dba's.
Please let us know did it help....
To have more understanding of SQL server below links can help:
<a href="http://www.quackit.com/sql_server/tutorial/%22%3ESQL Server Tutorial</a> from Quackit.com
No comments:
Post a Comment
http://www.facebook.com/?ref=logo#!/SqlServer2008Tutorial