Posts

A Case of the Haves: Should I Get My Degree and/or Microsoft Certification?
Dec 16, 2008 · 3 min read ·
Share on:
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 …
Read More
SQL Server: Creating a User-Defined Data Type from Scratch
Dec 16, 2008 · 3 min read ·
Share on:
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. …
Read More
iTunes Alternative: Songbird is to iTunes What Firefox is to IE
Dec 15, 2008 · 3 min read ·
Share on:
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 …
Read More
SQL Server: Free Yet Noteworthy E-book Package from Red Gate Software/Simple-talk.com
Dec 15, 2008 · 3 min read ·
Share on:
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. …
Read More
The Simple-Talk Cookbook: A Cookbook for Geeks by Geeks
Dec 15, 2008 · 1 min read ·
Share on:
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 …
Read More
MS Defender Error: "Mallware Signeture Download" Appears Legitimate (Unfortunately).
Dec 14, 2008 · 2 min read ·
Share on:
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 …
Read More
T-SQL: Find Duplicates Without Using JOIN
May 15, 2008 · 1 min read ·
Share on:
I'd forgotten about this lil trick.
select eUserName from eAttribute GROUP BY eUserName HAVING COUNT( eUserName) > 1

Read More
SQL Server: Change the Owner of All Tables to "dbo"
May 8, 2008 · 1 min read ·
Share on:
Reference for me. Reference for you.
sp_MSforeachtable @command1="EXEC sp_changeobjectowner '?','dbo'"

Read More
VBScript: Clean Up Imported SIM Card Contacts in Outlook
Apr 11, 2008 · 2 min read ·
Share on:
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 …

Read More
SharePoint: Save Publishing Site as Template in MOSS 2007
Mar 23, 2008 · 1 min read ·
Share on:
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 …

Read More
- 27
- 28
- 29
- 30
- 31