Author Archives: Simon Collis

Why is my stored proc slow in .Net?

I was writing a stored procedure the other day and trying to make it run faster. The problem was that it ran in under a second in SQL Server Management Studio, but then took over thirty seconds when running from … Continue reading

Posted in Development | Tagged , | Leave a comment

What does “&amp” mean?

Sometimes, when you’re using Twitter or Facebook, you’ll see something like this: Had a great lunch today with Alice &amp Bob to discuss the new project And at first that reads fine. But halfway through there’s “&amp”, which doesn’t make … Continue reading

Posted in WWW | Tagged , , , | Leave a comment

Top 5 free word processors

Microsoft Word is the world’s most popular word processing package. And while it’s mature, robust and capable, these days it costs an annual subscription to use it. So what happens if you don’t have the money? Or maybe your computer … Continue reading

Posted in Applications | Leave a comment

What is an .ipa file?

An .ipa file is an application for installation on an Apple iOS device, such as an iPhone, iPad, or iPod Touch. Underneath, an ipa file is actually a ZIP file, so if you want to see what is inside it, … Continue reading

Posted in File formats | Tagged , | Leave a comment

How to convert a test project to a normal class library

Sometimes you make mistakes. One of the ones I make most often while using Visual Studio is creating a new project of the wrong type. Usually, creating using just the same one I usually created. And just now, I added … Continue reading

Posted in Development | Tagged , | Leave a comment