Finally we arrive at the thrilling conclusion to my push notifications miniseries. This time we will actually push a notification to a device we have previously recorded. Posts in the series: Code on the device – This will handle everything you need to put into your wp7 app Code on the server – This will [...]

This is the second part in the mini series that is taking us through the steps of setting up push notifications for your windows phone 7 app. Posts in the series: Code on the device – This will handle everything you need to put into your wp7 app Code on the server – This will [...]

If you need to split a string using a delimiter in SQL, but want certain sections wrapped in quotes to ignore the delimiter, fear not, as I have a quick and easy answer. Here’s how you use it: In SQL: SELECT * FROM dbo.SplitQuoteSafe(‘"Test","Stuff, that, has commas","ok",24.45,,yes’, ‘,’) In Linq: var words = from w [...]

SuperQ is much like the Queue Storage for Windows Azure, except it automatically creates a local db instead of using the cloud. It is also self-polling, so all you need is a callback method and you’re ready to go. This allows you to create quick and easy task schedulers and background worker processes. Step #1 [...]

You can quickly and securely encrypt data in SQL Server 2005+ by using the native Symmetric Keys functionality. The most common encryption algorithms symmetric key encryption supports are Des, Triple Des, RC4 128bit, AES 128bit and AES 256bit. Setup your database To create a symmetric key, we first need to setup our database with a [...]