Sign in Subscribe

Insights

Sharing our knowledge, experience and insights

Search the blog

More articles

How to: Remove all users from the ASP.Net Membership database by application name

A while ago I wrote about How to: Remove users from the ASP.Net membership database which showed you how to remove a single user from the ASP.Net membership database from SQL Management Studio. That's great when you're deleting one or two users but what

Calculating what an employee will cost you

As people are now looking to employ I thought it would be helpful to overview the general costs involved with employing someone in the UK and how you can factor that back to an hourly charge. Some Assumptions 1. As most of my readers are within the IT industry, I&

SQL Server: Warning: Fatal error 823 occurred at date / time Note the error and time, and contact your system administrator.

We were contacted the other day by a client with issues selecting data from one of their tables after a recent server crash (not running on our servers or a site that we were involved in developing). The issue was easy enough to recreate as you just needed to select

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 into Excel. This SQL Script is fairly simple, basically what it does is it

Download Umbraco content properties into a crosstab table

Have you ever needed to get a download of your Umbraco content nodes in a cross-tab query e.g. download contact form data from Doc2Form? Using Umbraco's Contour product makes this a breeze but what about older systems? Thankfully, it's not actually that difficult. We have

Retrieve the customer's last address when logging into uCommerce

Probably one of the most common features of an ecommerce systems is to "retrieve my details" when logging in -after all that's why you create an account with the seller isn't it? Out of the box, uCommerce has XSLT to retrieve the customer'

Delete all UCommerce baskets older than x days

After my last UCommerce post on how to delete test orders and baskets from UCommerce, Søren suggested I extended the delete all baskets code to take into account when it was created. As my last code was relating to deleting test orders/baskets (and so would want to get rid

Deleting test orders and baskets from uCommerce

Although Søren has posted a helpful post on how to delete entire purchase orders from the database here, we needed something a little less “all or nothing” so put the below together. Delete a specific order id --Delete purchaseorders and associated data based on order id DECLARE @OrderNumber nvarchar(50)

Developer Pitfall: When to call it quits on a problem

We’ve all done it, you’ve run into a problem while developing which you bash at for a few hours and before you know it, you’ve lost the day, not got anywhere and feel completely frustrated. What’s more, is it’s usually something so screamingly obvious and/

Getting started with uCommerce

I thought seeing as uCommerce is now an actual product I would start to overview an install/configuration of uCommerce assuming no prior knowledge of uCommerce. Firstly, let me start of by saying that once you've got your head around uCommerce and some of it's complexities,