HTTPS fails on IIS7.5 after server restart

clive All, Microsoft, Tech Tip

If HTTPS fails to start correctly following a server restart, but HTTP does. Try looking at the binding on the website which https is attached to; the act of looking (and clicking ok) will be enough to get https running again temporarily. But if it fails again on reboot, look at the logs, and in particular for the code 0x8009030d in …

Office 365, Microsoft Exchange, Outlook and Android Calendar Sync

clive All, Microsoft, Tech Tip

My, this is harder than it needs to be. If you are using Office365, and have an address like clive@rectanglered.onmicrosoft.com, one of the big attractions is getting access to Microsoft Exchange’s push based shared calendar system. If you naively try to share a calendar from Office365, you will merely get a readonly copy – no use to anyone. Office365 does …

Fast SQL Server Inserting Data from .NET

clive All, ASP.Net, Development, Microsoft, Rectangle Red, Tech Tip, Uncategorized, VB.Net

Today we needed to insert a large amount (250,000 rows) of automatically generated data into a SQL Server database. Generating the data was very fast, but inserting each line with a SQL Insert statement, painfully slow, even if logging is in Simple Mode in the SQL database. So… we investigated the SQLBulkCopy function in .NET, but this is usually used …

Software Development Job in Stony Stratford, Milton Keynes

clive ASP.Net, Development, Jobs, Microsoft, Milton Keynes, Rectangle Red, Stony Stratford, Uncategorized

Rectangle Red are recruiting as of March 2014 – we are looking for another talented developer to join our growing team. Click here to see the main job specification and advert here and apply. If you’re a prospective job candidate, hello, and welcome! Please look at the main advert above for lots of details about skills we’re looking for, but …

Deep Copying an Object in VB.NET

clive All, ASP.Net, Development, Tech Tip, VB.Net

A curious omission in .NET is the ability to make a deep copy of an object which is independent of the original object – i.e. you can change the copy without changing the original. If you simply copy an object in .NET with assignment, all you are doing is pointing a second variable at the same object in memory, and …

SQL Server Queries – Stripping Extra Characters from the End of a String

clive All, Development, SQL, Tech Tip

Yesterday while implementing a particularly difficult SQL report query, I came across the following question: Given a String ‘This is a test, this is a second test’, is there an easy method (preferably without using CLR) to search and replace the string to remove the word ‘test’ but only if it occurs as the last series of characters in a …

Announcing Rectangle Red’s First iOS App

clive Development, iOS, Milton Keynes, Rectangle Red, Stony Stratford, Uncategorized

Here it is – we’ve finished the app we’d been working on in our spare time; a melodeon simulator for the iPad and iPhone! What’s a melodeon? A form of button accordion, which is played in many different styles around the world – see www.melodeon.net for more (much more) info! Does the world need a new melodeon app? Of course …