About Us
This website is run by 4 DBAs who are originally from Chennai, INDIA and now are settled in different parts of the world. The one thing that united all 4 of us is SQL server.
Deepak Rangarajan
Deepak has 5 years of work experience in database administration, design, development and performance tuning of relational databases and data warehouses. Currently he is pursuing his Masters in Information Systems from Carnegie Mellon University, Pittsburgh.
Deepak is awarded as MVP (Most valuable professional) for his contributions towards SQL Server. He is an active participant and moderator in MSDN SQL Server forum. Deepak is an MCTS certified professional and has been awarded with Level 3 and Level 4 certifications by Japanese Language Proficiency Test JLPT. Deepak possess strong leadership skills experience by serving as the Chapter Leader of Professional Association for SQL Server (PASS) in Chennai which has around 50 members.
He is passionate about solving business problems using his technical skills and hence he is very much interested in the field of Technology Consulting in Information Management.
He blogs at http://deepakrangarajan.blogspot.com and can be reached at deepak.rangarajan@gmail.com
Credentials:
MCTS (SQL Server 2005)
MCITP (SQL Server 2008)
Leksshmanan
Leksshmanan – Predominantly known as LEXX / LEKS holds a Bachelors degree in Electrical and Electronics Engineering and is currently doing his Masters program in Computer & Information Sciences . LEKS is in the industry for 5+ years and works for one of the Government Department in New Zealand. He is a active participant & Answerer in MSDN forums.
Credentials:
MCTS (SQL Server 2005)
Sugesh Kumar
Sugesh hails from Chennai. He holds a Bachelors Engineering degree in Computer Science and Engineering. He has experience of over 5 years and has been associated with SQL Server since then. He started his professional journey as a PeopleSoft DBA with SQL Server as Back end. With more and more interest towards SQL Server, he now works as a full time SQL Server DBA. Currently he works for one among the TOP 10 IT services provider company in USA.
Credentials:
MCDBA
BrainBench certified in SQL Server 2000, Windows xp, Windows 2000
Vidhya Sagar
Vidhya Sagar has graduated in Electronics & communication engineering from Anna Varsity, Chennai in 2006. Immediately he started his career as a SQL SERVER DBA with one of the fortune listed company and he later moved to another MNC in 2008.
He has completed MCITP certification for both SQL SERVER 2005 and 2008 and he helps his community by maintaining his own blogs on SQL and answering in forums like MSDN, SQL-ARTICLES and etc. He is also a regular speaker at Chennai SQL user groups and Tech days conducted by Microsoft. Apart from SQL SERVER, Vidhya also spends his time on latest arrivals in Electronics stuffs and reads a lot on it as well. He also has experience in PHP , MySQL , .Net and Joomla.
Credentials:
MCTS (SQL Server 2005)
MCITP (SQL Server 2005)
MCITP (SQL Server 2008)
ITIL V3 Foundation
Amit Bhatt
| #
Hi Deepak,
Thanks for such a nice article.
You missed one thing to add in code:
@article = ‘all’,
Hence the script will be like this:
EXEC sp_addsubscription
@publication = ‘mypublication’,
@article = ‘ALL’,
@subscriber = ‘Subscriberservername’,
@destination_db = ‘mydestinationdbname’,
@reserved=’Internal’
Error 18486 | Platformblog
| #
[...] SQL-Articles » Troubleshooting Login failed Error 18456This is one of the infamous error message (and number) that most of the DBAs …. 18486. Login failed for user ‘%.*ls’ because the account is currently locked out. [...]
Setting and Changing Collation – SQL Server 2008 « Blog
| #
[...] to sql-articles.comRead more: http://sql-articles.com/articles/dba/how-to-change-server-collation-in-sql-server-2008/#ixzz1pu2S8XW… Like this:LikeBe the first to like this [...]
VidhyaSagar
| #
Naveen,
I’ll check this out and get back to you.
balakiran
| #
Thanks man, Very simple & easy to understand !!!!