Error running Ucommerce scratch indexer Illegal duplicate key definitions

We hit an interesting issue indexing the Ucommerce data the other day which had us going for a while.It turns out that when upgrading Ucommerce to 7.0.6, some new payment providers were added to…

Read this article

Drop/Kill all connections to a SQL Database

Every now and again you need to get exclusivity to a database e.g. to do a database restore but someone is connected. You can manually find who it is using EXEC sp_who but that can result in having to…

Read this article

How to: Restore nodes from a SQL backup

We had an odd issue the other day where a bunch of nodes disappeared from one of our Umbraco installs. There didn't appear to be any reason behind why they were gone and the customer assured me that…

Read this article

Download any Umbraco document type’s values as crosstab/Excel table

In a follow up to my post yesterday -How to download Umbraco content properties into a crosstab table this is the follow up SQL Script that makes it even easier to download any Umbraco document type…

Read this article