I can't believe I forgot about this! I blame it on my crazy school schedule back in the day. In December of 2006, I was asked to contribute a recipe to the Simple-Talk Cookbook. Of course, I gladly obliged. The editor, Claire Brooking, published the very professional-looking cookbook to the opinion section of …

Ow, the other day I was infected by the the Vundo trojan. I believe the trojan came in through an infected webpage and attacked a Java vulnerability on my machine. During the cleanup, I installed a variety of anti-malware software, including Microsoft Windows Defender. Although I don't believe things can be 100% clean …

I'd forgotten about this lil trick. select eUserName from eAttribute GROUP BY eUserName HAVING COUNT( eUserName) > 1

Reference for me. Reference for you. sp_MSforeachtable @command1="EXEC sp_changeobjectowner '?','dbo'"

The other day, I was texting a friend and some guy looked at me and said "Oh hey, 2002 called, it wants its T9 back." Haha, slightly cliche but I laughed anyway. Then I went and bought myself a Blackberry. I totally love it, I won't lie. So I imported my contacts into Outlook from a Sony Ericsson mobile phone …

Seems that Microsoft forgot to add a link to "Save site as Template" for Publishing sites in MOSS 2007, and it appears the problem is not addressed in SP1, either. Makes me wonder if the lack-of-link was intentional. Nevertheless, in order to save any Publishing Site as a template, you must manually append …

For as many times as I have read about sending e-mails using SQL Server triggers, I've rarely come across actual code samples. After someone asked for a "Triggers for Dummies" example in a Facebook SQL group, I created the following example which uses a trigger to alert a manager that an expensive item has …

I'm kinda late on this but arstechnica reports that "Microsoft has opened the source code to the .NET Framework libraries under a read-only reference license. Developers who want to check out the source code need only upgrade to the newly released Visual Studio 2008 to gain access to it." This is something …

Today I attacked my 2008 technical to do list and setup a subversion server for backups/source control. It was actually pretty darn easy in SUSE 10.3. After I got it going, I wondered if I could have it automatically authenticate against my HOME domain. So, using SuSE's menu driven interface YaST, I easily added my …

For those of you who dropped out of college and want to finish your undergrad degree, you may want to consider the online university, Western Governors University. I'm sharing this on my blog because I actually shared the URL with many of my tech friends who dropped out. I found an ad for WGU in some tech magazine …