Monthly Archives: January 2010

Adding Articles to and Dropping Articles from Existing Publications

Posted on January 27, 2010 by Vinay

While checking on the forum found many questions about how to add/drop articles from existing replication. so though of blogging on it. Everyone should follow this (must read) which is the base/reference for this blog . >>Snapshot/Transactional Replicaiton:- Adding Articles:- … Continue reading →

Posted in Add/remove, Replication | Tagged | Leave a comment

Whats new in Sql server 2008 r2

Posted on January 26, 2010 by Vinay

I blog a series of blogs on whats new where I tried to brief about whats new in sql server versions compare to earlier version till sql server 2008, this blog is continue to that for whats new in sql server … Continue reading →

Posted in Imp dates, Whats New | Tagged , | Leave a comment

Deadlock part 1 -brief.

Posted on January 21, 2010 by Vinay

I already shared some of the great links for deadlock in my earlier blog here got a question for my interview what is deadlock?, so would like to brief about it, following description would be deadlock by simple transactions which … Continue reading →

Posted in DeadLock, General, What I learned today | Tagged | Leave a comment

Rename Distribution job

Posted on January 19, 2010 by Vinay

Whenever we create a replication (transaction replication) whether it is from Wizard or script, the respective agent (log reader, distributor and snapshot) job created automatically with their default naming conversion as Snapshot Agent: [PublisherServerName]-PublisherDB-PublisherDB- [# of time replication script/wizard run … Continue reading →

Posted in Others, Replication | Tagged | Leave a comment

Error Numbers

Posted on January 19, 2010 by Vinay

Everyone wants to know the list of error numbers present in sql server. Today found a very interesting site( another great site -added in my fevorites list for reference). http://www.sql-server-helper.com/tips/index.aspx above link shows at the bottom list of sql server … Continue reading →

Posted in General, What I learned today | Tagged | Leave a comment

Error Log Part 2

Posted on January 18, 2010 by Vinay

I already discussed the steps of server starts which log info at error logs here, In this blog I would like to share the information we can get from error log. Error Log  contains: Version of Sql server Version of  … Continue reading →

Posted in Error Log, General | Tagged , | Leave a comment

MySQL to SQL Server Migration

Posted on January 15, 2010 by Vinay

Free MySQL to SQL Server Migration Tool Available for Download From Microsoft this is for sql server 2005 and sql server 2008 http://www.microsoft.com/downloads/details.aspx?FamilyID=c6f14640-da22-4604-aaaa-a45de4a0cd4a&displaylang=en http://www.microsoft.com/downloads/details.aspx?FamilyID=c6f14640-da22-4604-aaaa-a45de4a0cd4a&displaylang=en for Migration from MySql to MS Sql server 2000 use below information. http://technet.microsoft.com/en-us/library/cc966396.aspx I also blog … Continue reading →

Posted in Free Stuff, Migration, Software, Tool | Tagged | Leave a comment

Microsoft Release end dates -2

Posted on January 13, 2010 by Vinay

I blog here lastly about Microsoft Sql server 2000 support has already expired. Just want to update further on this that Microsoft SQL Server 2005 Service Pack 2 is already expired (January 12, 2010) and SQL Server 2008 RTM will expire … Continue reading →

Posted in Imp dates | Tagged | Leave a comment

New Blog Location

Posted on January 9, 2010 by Vinay

Hi Friends.   Thanx for your support. for this year onwords I will be bloging on my own website….   Hope to see you there   http://rdbmsexperts.com/Blogs     Thanx. Vinay   http://rdbmsexperts.com/Blogs/http://vinay-thakur.spaces.live.com/blog/http:\www.twitter.com\thakurvinay  

Posted in Computers and Internet | Leave a comment

My own site for blogging

Posted on January 8, 2010 by Vinay

Hi Eveyone. Now on I will be bloging on this site…. Thanx. Vinay http://rdbmsexperts.com/Blogs/ http://vinay-thakur.spaces.live.com/ twitter @thakurvinay

Posted in General | Tagged | Leave a comment