Teams, teams, project, more projects, ideas, goals, and all that stuff. I work a regular job like most guys, but for some reason I feel that I have to step beyond that and do more. Maybe it is my desire to shoot for the riches that success can bring, maybe it is the accomplishment of... Continue reading →

Table variables are another “tool belt” item that one must have when really digging into various SQL tasks. Oracle and other real databases also have this capability, but I’m going to, as usual, discuss the Microsoft SQL variant of the table variable for a minute. One scenario that I was faced with was how to... Continue reading →

I think I did this right. I needed bit and byte specific counts for each. It sometimes is useful in today’s age, so I figured I’d post it. It never hurts to know about the underlying fundamentals of the hardware we developers write software to. 1 byte, 8 bits1 MB, 1024 bytes, 8192 bits1 GB,... Continue reading →

Recently I needed to identify a week within a T-SQL Query. First off I figured I would want to know what day it is, then I could easily figure out a week time frame. To verify what day you have selected, use the following code: IF DATENAME(weekday, ‘1/7/07’) = ‘Sunday’ BEGIN SELECT ‘Sunday’END ELSE SELECT... Continue reading →

Over the weekend I made several attempts to download the BlogEngine on CodePlex by Mads Kristenson several times. The problem, was that the site kept timing out. I’m not sure if the local Comcast Service was having another issue or if the site was really down, but either way I wasn’t able to pull it... Continue reading →