Andy Warren

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

SQLServerCentral Article

Duplicate Key Inserted Error During Replication

If you allow users write access to replicated tables on the subscriber, you can run into cases where a record is inserted on the wrong server - which will result in a replication stopping error if the same primary key is later inserted on the publisher. Find out how to fix it without pushing a new snapshot.

5 (1)

You rated this post out of 5. Change rating

2004-10-15 (first published: )

9,637 reads

SQLServerCentral Article

Are you innovating?

Andy has some examples of not very high tech solutions that involve some technology behind the scenes, but the binding factor was that someone had to see the problem first, and it wasn't one of those show stopper type problems. It's not about SQL, but we think it is on topic.

You rated this post out of 5. Change rating

2004-09-30

5,299 reads

Blogs

Advice I Like: Experience and Aptitude

By

Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...

Plan Time for Self-Development

By

As you begin the new year, if you don't already have time set aside...

BK’s Bookshelf: Never Split the Difference

By

I picked up Never Split the Difference: Negotiating As If Your Life Depended On...

Read the latest Blogs

Forums

Insiders Selling Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Insiders Selling Data

Join 2 tables

By mtz676

Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M ServerA N...

Impact of Not Including Foreign Keys in an SQL Archive Database

By abdalah.mehdoini

Hello everyone, I am about to start a data archiving project that will affect...

Visit the forum

Question of the Day

Quiesce

What does it mean to quiesce a system?

See possible answers