• DBA

    SQLskills Master Immersion Events 2011 competition

    SQLskills Master Immersion Events 2011 competition         I have completed engineering and my native is M.Uthamasolagan (village near chidambaram ). I have started my career as SQL server DBA with my brother’s Rajakrishnan Rajadurai support. To be frank I am not good in English and so I feared to work during the initial time. My senior DBA Roshan Joe Joseph helped and encouraged me a lot. Now I love to work with SQL server because of SQL community helpers.   I have started a blog three months back and now my interest in writing  blogs  has increased tremendously because, I got a good local SQL server team. When I write…

  • DBA

    How to find the SQL server port number

      One day I got a call from my junior DBA. She asked me, how can I find out the port number for a particular server? Then our conversation started, Me: I asked a question to her what version of SQL server is that. Junior DBA: Its SQL server 2005 Me: I told her to check the configuration manager. Start –> all programs –> Microsoft SQL server 2005 –> Configuration Tools –> SQL server Configuration Manager.   Junior DBA: I don’t have direct remote access. (MSTSC) Me: After that, I told to check the SQL error log by using T-SQL     SP_readerrorlog 0,1,'listening','server' Junior DBA: I didn’t see ‘’listening’…

  • Backup/Restore

    Step by step backup/restore using T-SQL

    This article mainly for SQL server learners, who is going to become a DBA, in this article I am going to explain the backup and restore using T-SQL. =======================make sure you got the following information, see the example in the bottom DB size – Sp_helpdb ‘Dbname’ – 80 GB Source DB latest backup date and availability – Check the backup history and check backup is available in drive – Yes Destination DB latest backup date and availability – Optional (latest backup available ) Can we overwrite destination with or without backup – Check with the requester – Yes, overwrite take a backup before =======================   Why I choose the T-SQL…