The Problem Sometimes you may need to write dynamic SQL. One example is writing query for running over linked server connections. You might write something […]
Windows 8.1 Upgrade and SSD optimisation warning
Be warned. When you upgrade from windows 8 to windows 8.1 it is actually a complete windows update equivalent to going from windows 7 to […]
Citrix has stopped responding Windows 8.1, wfcrun32.exe
The problem Upgrade your computer to windows 8.1 and upon logging in you get an application crash from Citrix, wcfrun32.exe. The solution You need to […]
Slow Login on HyperV – Please wait for the local session manager
The problem A HyperV Virtual Machine that I had been using for over 1 year suddenly started slowing down when logging in via remote desktop. […]
CKEditor HTML view greyed out
The Problem When running CKEditor (3.6.4 for ASP.NET) the editor loads but the HTML view is greyed out. Switch to source mode and the HTML […]
SSRS – Default Date Parameter not showing
The Problem I have an SSRS Report with a default date parameter. The default date parameter appears grayed out and does not allow me to […]
PayPalMerchantSDK, integrate paypal into your mvc 4 website
The following outlines some of the things that I have learned whilst trying to integrate a PayPal payment gateway into the MVC 4.0 website. Installation […]
SSIS 2012 Project Deployment – Set CheckpointFile with Parameters
The Problem SSIS in SQL Server 2012 now supports a “Project Deployment” model. Adding things like Connection Strings is relatively intuitive. I want to use […]
Post Deployment Script, 72006: Fatal scripting error: Incorrect syntax was encountered while parsing
The Problem You create a post deployment script, with a statement like; [sql] :r .\Static Data\Insert Seed Values.sql [/sql] The system throws an error and […]
SSDT generate script throws an “object not set to an instance of an object” error
The Issue I created a Visual Studio Database project by scripting the code directly off the server in question. When I then try to publish […]