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,600 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,298 reads

Blogs

The Ireland and UK DevOps Roadshow

By

We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...

SQL Aggregate Functions: Your Essential Guide & Cheat Sheet

By

SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....

T-SQL Tuesday #174 – My Favorite Interview Question

By

This month is a great topic to me. I think growing and improving your...

Read the latest Blogs

Forums

Creating Statistics on XML

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating Statistics on XML

Managing SQL Agent in Azure Data Studio

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Managing SQL Agent in Azure...

Database design help and tips for a small app used to coach tennis players.

By JB

Hi, I hope this isn't too long of a question- I tried to make...

Visit the forum

Question of the Day

Creating Statistics on XML

I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?

See possible answers