The Problem When you move sql logins around servers the logins are created with an SID that uniquely identifies the login. Assume you setup two […]
T-SQL Drop temp table if it exists
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 […]