Time to talk about a subject that most DBAs hate, but some DBAs like me have a love-hate relation with it. Replication. Not storage replication or Availability groups. That old workhorse SQL Server data replication. Limit the number of articles per publication: Having to occasionally rebuild replication is a humongous pain in the backside, but…