Sql Server Database administration
In this Competitive world, its very crucial the way data is
handled and maintained, as tons and tons of data is getting generated by the
systems and DBA plays a very important role in any project, not only DBA sometimes
even Developers get to wear a hat of the DBA when working alone on their
individual work stations or creating a new tables for their production environment,
In this blog I will be talking about various things we can
do with Sql server as a DBA and will also focus on the issues what the DBA’s face in day
and day out,
so why wait lets get started and see what are the general or basic activities of the DBA in todays world :
if we continue the list is never ending in this ocean of DBA activites , but these remain as the prominent duties of the SQL Server DBA.
- Maintaining the databases and see that there is very minimal to no downtime for any database.
- in the event of disaster , recover the database with almost no to minimal dataloss.
- provide high security to the database by giving the least required privilages to the users.
- monitor the performance of the database and server and tune it as and when required .
- do capacity planning of the database and the disk's
if we continue the list is never ending in this ocean of DBA activites , but these remain as the prominent duties of the SQL Server DBA.
No comments:
Post a Comment