Friday, 23 November 2018


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 :


  • 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.