I read all the Internet debates about how it might or it might not and I can confirm that I tried it and it didn't work. The server runs the host OS, SuSE Linux 64-bit, beautifully but it totally craps out when a 64-bit guest OS install is attempted. EM64T doesn't do VT so.. if that's what you're looking for, start …

Recently, I wanted to see if my ex in DC was reading my blog so I ran my referer log against an outdated copy of the MaxMind GeoIP locator database. I figured the database could use some updating so I ran the ImportMaxMindGeoIP.vbs script I posted awhile back, and much like in real life, I received an "Access …

OK, I realize this is my fifth blog post in two days after a seven month blog posting deficit. Is it obvious I'm procrastinating? Well, I am, but writing blog entries is way easier than studying. Apparently, my brain is fed up with learning what Microsoft recommends I do with SQL Server 2005. So until it decides to …

I've always been slightly jealous of PostgreSQL's network data types, speficially, it's IPv4-supporting cidr type. I wondered if Microsoft would ever implement a similar type (I'm still wondering) but until they do, I'll work with the ghetto I've got: User-Defined Datatypes, which were introduced in SQL Server 2005. …

When I first moved back to Louisiana, I bought a car that fulfilled a few of my childhood dreams. It's an Audi A4 2.0T with rims, tint, sport suspension, BOOM and a Pioneer touch-screen iPod-compatible/GPS-enabled stereo system. I'm such a teenage kid. Haha. Anyway, what's even better is that I'm able to have a …

Before I start, I thought I would mention that I've always thought there was something a little suspicious about simple-talk.com. I couldn't quite put my finger on it, but.. ok for instance, one of their bloggers, "Phil Factor" (FILLFACTOR -- get it?), kinda freaks me out. Maybe it's his avatar. …

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'"