SQL Server 2005 | “Product level is insufficient”
The following error kept popping up when trying to import data from a flat file source […]
Visual Studio | No source code available for the current location
Whilst trying to debug a Stored Procedure, the following error prompted: There is no source code […]
SQL Server 2005 | Copy Database Diagrams
Next is the code to copy database diagrams from one database to another (tested on SQL […]
Convert String to GUID | Quickie
To convert a string to GUID you have to do the following: string text = “6937e459-f1bd-4a20-ab10-28ff0010c15b”; […]
Get a Double Random Number | Quick Tip
This is useful since the Random() object can only export a double number between 0.0 and […]
Convert degrees to minutes for Google Maps in Excel
Normal Formula =”N” & INT(H2) & ” ” & ROUND(((H2 – INT(H2)) * 60), 6) Advanced […]
Mime Types
Was searching for the flash content mime type and found this list of all the mime […]
Set Negative and Zero Formatting in String.Format
Apart from setting the format you want the string to be shown, the format parameter in […]