Andy Warren

I started my SQL journey here at SQLServerCentral as one of the founders, helping to build a place to share and learn that continues to thrive under the editorial guidance of my friend Steve Jones. I've done a lot of volunteer work over the years ranging from our local SQL group (oPASS, SQLOrlando) to serving on the Board of Directors of PASS to designing and building the framework of SQLSaturday (which has gone on to produce more than 1000 locally managed events since we started in 2007). These days I manage a DBA team, but over the years I've been a trainer, consultant, contractor, and DBA. I'm rarely present on social media, the best way to contact me is here, LinkedIn, or via email.

All authors

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2004-10-15 (first published: )

9,694 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,318 reads

All authors

Blogs

The Book of Redgate:A Prehistory

By

I’ve covered the values in a number of previous posts on the Book of...

Evidence-bound: what AgentDBA will and won’t link

By

When the evidence names the database, it says so. When it doesn’t, it stops....

Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?

By

Making Data AI-Ready, Part 3 (This is the final article in a three-part series...

Read the latest Blogs

Forums

Four Rules for Adding AI Without Breaking What Already Works

By dbakevlar

Comments posted to this topic are about the item Four Rules for Adding AI...

SQL Server 2025 section missing?

By deubel_m

Hello, the title says it all. Is the SQL Server 2025 section missing?

A design question in a parent child relationship

By eichnerm

I am not sure which is the best way to proceed. I have parent...

Visit the forum

Question of the Day

Hyperscale Replicas III

In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?

See possible answers