Author Archive

T-SQL: setting decimal value always rounds up or down

May 3, 2012

Forgive my brevity on this post but I am writing to you today from my cell phone. You may run into the problem I just had and I wanted to let you know what the issue was and how I solved it. Suppose you have the following code: DECLARE @decimalValue1 decimal = 5 DECLARE @decimalValue2 [...]

Tags: ,
Posted in Programming, Snippets No Comments »

Microsoft Releases Roslyn Project, Open Compiler API

October 22, 2011

This is amazing. Microsoft has made the inner workings of their IL compiler open to everyone by exposing the inner workings through an API. As the Overview describes, they’ve rewritten the IL compiler in managed code and in doing so have un-boxed the black box that was once the best IL compiler for Windows. It [...]

Tags: , , , ,
Posted in Geektopia, Programming 1 Comment »

How to alter table column to increase varchar size

August 16, 2011

The top results in a general search through Google for keywords in the title of this post will return results which will not work with SQL server. Some suggest using the ALTER tablename MODIFY column syntax for which SQL Server does not support MODIFY. In order to change the size of a varchar column (or [...]

Tags: , , , , ,
Posted in Programming, Snippets No Comments »

myIP: A robust command line tool for retrieving local and remote IP addresses

May 13, 2011

In usual fashion I sat down the other day and tried to come up with a useful tool I could quickly code. After about a week of coding and testing I’ve come up with a simple command line tool that will retrieve and display both v4 and v6 IP address information for one or more [...]

Tags: , , ,
Posted in Downloads, Snippets, Source Code 2 Comments »