Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server Blog Forum

My name is Muthukkumaran Kaliyamoorthy and I am living in India (Chennai). I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server, and I’m specialized in Administration and Performance tuning.

Archives: January 2011

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…

Read more

3 comments, 183 reads

Posted in SQL Server Blog Forum on 24 January 2011

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

Read more

9 comments, 164 reads

Posted in SQL Server Blog Forum on 19 January 2011

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…

Read more

15 comments, 250 reads

Posted in SQL Server Blog Forum on 10 January 2011

Happy moments in 2010

Happy moments in 2010

Hi all wish you a happy new year.
I know it’s a late post anyway I am going to share my 2010 happy moments.
My happy moments:

I have joined one of the MNC and started writing a blog, articles, reading books and following some other… Read more

34 comments, 313 reads

Posted in SQL Server Blog Forum on 7 January 2011