Monthly Archives: January 2010

Adding Articles to and Dropping Articles from Existing Publications

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

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.

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

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

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). 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

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

Free MySQL to SQL Server Migration Tool Available for Download From Microsoft this is for sql server 2005 and sql server 2008 for Migration from MySql to MS Sql server 2000 use below information. I also blog … Continue reading

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

Microsoft Release end dates -2

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

Hi Friends.   Thanx for your support. for this year onwords I will be bloging on my own website….   Hope to see you there     Thanx. Vinay\\thakurvinay  

Posted in Computers and Internet | Leave a comment

My own site for blogging

Hi Eveyone. Now on I will be bloging on this site…. Thanx. Vinay twitter @thakurvinay

Posted in General | Tagged | Leave a comment