After an almost catastrophic 48 hour downtime with my existing hosting provider I decided to move my business, which involved moving a number of websites and their corresponding databases to my new hosting provider.
Now, the thing that I liked about my existing provider was that they supported SQL Server 2014. My new one doesn’t (and neither do a LOT of providers for some reason), so this meant having to downgrade my databases from SQL Server 2014 to SQL Server 2012. Continue reading →
So it’s pretty simple but, for some reason, the posts on MSDN that I initially read didn’t include this small but immensely important step. Continue reading →
A bit of a lengthy title that one but I couldn’t think how to limit it without losing the purpose of the post.
So, this post is all about how to go about exporting CSV data from SQL Server with data encapsulated within double quotes when it is required. Continue reading →
I do a lot of work in SQL Server and one of the things I dislike the most is trying to find all instances of a specific piece of text in Stored Procedures, Functions, Views, Triggers, Constraints etc. Continue reading →
I’ve been making some updates to a web services project recently (I say recently it was actually months ago but for some reason I haven’t managed to publish this post until now) and the time has come to deploy it to a test environment. This in itself brought a few challenges but the one that I want to discuss just now is the issue of including unknown file types in your publication package. Continue reading →
This isn’t something I’d generally blog about but this issue had been causing me problems when connecting to a physical desktop based within my client’s network. Whilst working with the keyboard wouldn’t provide any sort of issue the mouse would be unusable as whenever I moved it the pointer would literally take around 5 seconds to move across the screen. Very annoying. Continue reading →
I started work on a new MVC 5 project today and after working on it for a short while I decided I wanted to change the name of the web project to [ProjectName].WebUI from just [ProjectName]. So, I renamed the project, updated the project namespace and updated all my files to use the new namespace so my solution was now made up of [ProjectName].sln, [ProjectName].WebUI and [ProjectName].WebUI.Tests. All good I thought, but then I went to debug it and got this message:
Multiple types were found that match the controller named ‘Home’. This can happen if the route that services this request (‘{controller}/{action}/{id}’) does not specify namespaces to search for a controller that matches the request. If this is the case, register this route by calling an overload of the ‘MapRoute’ method that takes a ‘namespaces’ parameter.
If, like me, you are currently working on a development PC that doesn’t have access to the internet it can be a pain trying to install and maintain third party packages. I’m a huge fan of NuGet and I thought that as I didn’t have an internet connected machine I wouldn’t be able to connect to it and download my favourite packages via Visual Studio’s Package Manager. I was wrong though as it’s possible to use Visual Studio’s Package Manager to install NuGet packages even when you don’t have an internet enabled development machine Continue reading →