-->
SQL Clone
SQLServerCentral is supported by Redgate
 
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

Advertisements

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…

Read more

3 comments, 607 reads

Posted in SQL Server Blog Forum on 24 January 2011

How to find the SQL server port number

Advertisements

 

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…

Read more

9 comments, 520 reads

Posted in SQL Server Blog Forum on 19 January 2011

Step by step backup/restore using T-SQL

Advertisements

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 Read more

15 comments, 905 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

0 comments, 1,402 reads

Posted in SQL Server Blog Forum on 7 January 2011