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…
-
-
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’…