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 […]
Google Hangouts showing phone number not contact name
The Problem I recently upgrade my phone and am using “Google Hangouts” as the default SMS client. Some of my contacts appear with their phone […]
SQL Server Enable User
The problem You have a SQL Login created for your account usr_test Everything appears fine, but you cannot connect. When you look in the users […]
SQL Sever DB Mail Logs
If you use SQL Server Database mail sometimes you will have trouble and you want to see a log of all the emails that have […]
WordPress 3.8 – update plugins prompting for FTP Login
The Problem After upgrading to WordPress 3.8, trying to update plugins fails with the prompt for FTP login credentials. The error message reads: “To perform […]
Visual Studio SQLCompare does not Compare SQLCMD Variables correctly
The problem When using the Visual Studio SQL Compare to compare your database schema to your physical database it returns heaps of false positives, where […]
exec sp_executesql nvarchar(max) truncating at 4000 characters
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 […]