About Me
My name is Muthukkumaran Kaliyamoorthy and my native is M.Uthamasolagan village near Chidambaram. 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. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central.
I like dance, sports, website & Home designing. I’m holding the Microsoft Certified IT Professional and Microsoft Certified Technology Specialist.
I love to help folks. Please feel free to contact me.
Location: India
City: Chennai - Saidapet
Twitter @querymuthu
Email id:infoATsqlserverblogforum.com
October 13th, 2011 - 19:33
Muthu My dear new design looks great!i’m looking forward to read your next blog posts.
vino
October 13th, 2011 - 22:54
Hmmm… Thanks dear. If you want any web design tell me I will do for free 🙂
September 1st, 2015 - 20:48
Hi Muthu,
I really appreciate the way of explanation. I am from non IT background. After reading your blog i really understood everything about backup. Really hats off to you and you have a good future ahead and god bless you. I really need one more help from you..Still i am searching for job. Can you please send me some materials which is easy to understand and also interview questions and answers. I would be great and thankful and i will keep remember you till my death.
Thanks
Kalyan
November 8th, 2011 - 05:54
Nice blog, I really like your post, great point made. I cannot wait to dig into this material and learn from it. I am sure your next information would be very interesting. I am patiently waiting to see more. Wish you all the best! Thanks.
November 8th, 2011 - 21:06
Thanks!
December 1st, 2011 - 18:04
Hi muthu,
Happy to see ur docs. Thanks
December 2nd, 2011 - 10:24
Thanks ajeez.
December 13th, 2011 - 03:57
An Good post with good points.
December 13th, 2011 - 11:09
Thanks Valerie anne.
January 4th, 2013 - 11:50
hi, i am a fresher and i am new to RDBMS.
I appreciate your effort .gr8 job..keep it up…..
March 6th, 2013 - 12:33
I read ur article in SQL SERVER BLOG FORUM…It was really very helpfull 4 me…..
can u just tell wats the procedure to do SQL CERTIFICATION?and also the scope of SCOPE OF SQL DBA….. Hope U reply
Thanks and Regards,
S.PADMA
June 6th, 2013 - 12:05
Hi muthukumar,
this is arun…I am working in one IT concern. i want to be SQL DBA… where i have study SQL DBA. please suggest me.. preferable centers
June 6th, 2013 - 13:39
I am not sure about the training centers. I’ve not done. I suggest you to install SQL freeware express edition and work some small task like DML/DDL, get back to folks for doubts. Do some research on the internet and participate forum. You can definitely lean SQL and become a DBA.
June 16th, 2013 - 12:57
Hey, Muthukkumaran. Your blog is simply awesome. No more words to describe. While i have been wandering in google for SQL Server articles i got ur page. i have read so many blogs but did not get clear information than you with examples. Keep going on.. and please send me some real time issues while we face in interview.
June 24th, 2013 - 19:54
i need to leaen sql server …..
July 13th, 2013 - 12:05
I have gone through your sites.I have one question for u .
i have two database name it as test A ( full recovery model) and test B( bulk logged recovery model).Now i took the backup on two databases.my db size is 1 TB.After some time my both db’s (test a and test B) was crashed.
Now what is position of backup’s can you please let me know.
Thanks
Meghana.
July 16th, 2013 - 20:27
@meghana, If you still able to take a tail log backup you can take that and restore a DB. If not you need to restore from backup. Here is the article and script http://www.sqlserverblogforum.com/2011/07/sql-server-database-backup-restore-steps/
January 3rd, 2014 - 21:01
Hi muthu,
i am sakthi’s friend very good docs…some help i reqd from you i call u tommorow
Thanks
Ganapathy
January 16th, 2014 - 12:48
Hi Dude,
Its Aesome. Recentely i jump to application support to SQL DBA platform … i have lot of doubts and clarification in my min. now i cleared in Recovery types… i want to know about the performance tuning. can you please help me what is performace tuning. and we can do for performance issue ..
March 23rd, 2014 - 13:43
hey muthu
i am new to sqldba. what i need to learn first
March 13th, 2015 - 21:08
Hi,
I am trying to find your latest index fragmentation script for sql server 2000, but I am not able to find it anywhere on the blog. Could you please email this script?
September 21st, 2015 - 09:03
Dear Readers, My mailbox got crashed and I cannot recover the emails. Sorry for the inconvenience and please send me an email to my personal id also.
Muthu
October 27th, 2015 - 14:39
Hi Muthukumar,
Could you please help on peer to peer replectaion. How can i stop all the replecation jobs in existing P2P replcation environment and explain me how add new article to that environment. waiting for your reply
thank u
October 27th, 2015 - 14:41
and the question is for 2008 sql environment.
October 29th, 2015 - 20:59
HI Muthu,
Thanks for your script. I have few requests -hope you can help me.
[1] When i schedule your script it will run on all the databases. Can you let me know the best way to amend so that i can run it on selected databases.
[2] when i schedule this to run from SQL Server agent, how should i call this SP.
My email ID: nani_varaprasad@yahoo.co.in
Many Thanks.
December 6th, 2015 - 21:49
Hi.
Hope you are doing good…!
I would like to do microsoft certificate on DBA, could you please guide me on this.
Thanks…!
January 20th, 2016 - 16:35
Dear Sir,
kindly resolve my database below issue in SQL Server 2008.
database mail show in mail queue (Or “unsent”) and not show in Database logs but same working fine before one week.
Thanks & Regards,
Kailash Singh,
M: 7827492235
March 22nd, 2016 - 13:29
I want check errorlog for every five mins with specific error and i want output with mail.
Could you please help us
Regards,
vasu
June 23rd, 2016 - 14:14
Hi Muthu,
I have an SQL query but once I run the query.. it gives an error declare the scalar variable “@prm_StartDate” & a DB Errorcode=137.
Please advice.
November 18th, 2017 - 18:45
Hi Muthu,
I am from non IT background and working in BPO Non voice from engineering back round. I am trying to switch to IT field and I am interested in SQL/PLSQL. I am going to do it in online. Please suggest me how I can start with. Please help me with your number not in comments through my email.vigneshragunathr@gmail.com. Waiting for your reply.