Using Dynamic Values in XMLA

XMLA

A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values to XMLA for a backup script. The popular answer at the time I saw it was to dynamiclly create and drop a SQL job to run the script… Read more

Undocumented Gotchas of Transactional Replication

Gotcha - Norelco commercial (1977)

This discussion started on Twitter via the #sqlhelp hash tag. The question that was asked is, “What are the undocumented gotchas of Transactional Replication? #SQLHelp”. I responded with several things that came to mind. I thought these would be good… Read more