Fun with broken SQL Replication

Recently I’ve spent some time debugging some issues with a client site. One problem that came up during this work (which, sadly wasn’t actually the problem I was looking for) was a set of errors from SQL Replication appearing in the Sitecore logs. In keeping with my previous ranting about keeping your Sitecore logs as error free as possible I spent some time working out how to solve this.

Since I’d not looked at databases at this sort of level for some considerable time, I’m writing down some notes for my future self, next time I have to worry about this sort of thing… Continue reading

Advertisements

Development environments with PowerShell DSC – Part 4

After MongoDB last week, next on my list of stuff we might want to automate in our dev environments is SQL Server. There’s a good story around automating installs here, as Microsoft have supported this for some time. And there’s also a good story around installing it via DSC. I’ve taken most of my inspiration from this blog post, and pulled it into the install framework I’ve been working on. Thanks to Colin Dembovsky for his work here – as there wasn’t that much that I found I needed to change to get everything working for me. Continue reading