The Problem I often work in SQL Server with temp tables and they can be a pain when developing as you may have code like […]
LANTorrent seed you torrents from NAS without corruption
The Scenario I have been a long time user of uTorrent. I run it on my laptop that has limited storage, so if you want […]
Clean the Windows Installer Folder
Problem The c:\Windows\Installer folder contains windows .msi installers and .msp patch files that are used when installing and updating software on your windows computer. Over […]
How to make a self extracting archive that runs your setup.exe with 7zip -sfx switch
The scenario When you use the default Microsoft Visual Studio Installer (yes, it is back as an extension for VS 2013 – Visual studio Installer […]
Terrible Performance of SQL Server Linked Server query over WAN
The problem I have a linked server connection between 2 SQL servers approx half the world away. One server resides in Sydney, Australia and the […]
MVC Razor View escape character
The Problem You want to use your model or some code to append a variable inline with a string. Assume you want to create a […]
IIS Express and windows authentication
How to control the IIS Express Authentication settings To set the windows authentication parameters for you MVC applicaiton there are two ways to do this […]
How to activate Windows Server 2012
Issue Windows Server 2012 will not activate when you try to use the UI to activate a license key. Solution Open a command prompt and […]
Azure Web deployment task failed. Make sure that the process (“Web Management Service”) is started on the remote computer.
Issue Recently I was playing around using Azure and Visual Studio 2013. I was attempting to deploy my website to azure using the Publish wizard. […]
SSIS Convert between datetimeoffset and datetime
The Problem I had a sql table that was storing data in a DateTimeOffset(7) datatype, DateDeleted. I was trying to use SSIS to sync the […]