• 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 about a…

  • 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. Why I choose the T-SQL instead of GUI? Below are reasons, I have seen a number of articles and blogs shows the GUI. Anyone can use the GUI to restore the database, if they don’t well in SQL. Again most of the DBAs hasn’t used the command and they don’t know the T-SQL syntax to restore the database. I recommend using the T-SQL to restore the database because it’s the greatest tool when you are migrating a huge number of databases (Not…