What's XQuery? It's a language backed by the W3C to standardize querying XML. Why XQuery? Microsoft started offering support for it in SQL Server 2000 and in SQL Server 2005, extended it with more support with the introduction of the XML data type column. It's fast, it's compact, and you don't need to add 10 million trivial columns. You just add one XML column and stick raw XML in there. It's that easy, a caveman can do it. Here's more information about Microsoft and XQuery. So what's the bad news? It's yet another language to learn and the syntax is

For those who have never used the TinyMCE WYSIWYG pluggin, it's one of the industry's best kept secret; add this pluggin to your website, and you've got an instant Microsoft Word-like interface that supports pretty much all the different browsers and it's variations. Some of the things I've taken advantage of include creating custom toolbar buttons and leveraging their compressor paradigm to keep the scripts lightweight. Pretty neat indeed. Now with that said, I've come across one issue which wasn't very clear initially on how to solve, because it had long been a bug since it's predecessor versions; I was

Ever open up the SQL Server Configuration Manager and receive this message? I have; and an initial google search bring up a bevy of solutions. Unfortunately, the first several offerings did not solve my problem -- which prompted me to dig a little deeper. Apparently, I had corrupted my WMI repository somewhere along the line; and after some reading, the WMI can be corrupted after multiple restores of a database... which I'm definitely guilty of. So the solution? rebuild the WMI. Piece of cake, right? Luckily, I stumbled across this blog link which detail these instructions (which can be batched

We made plans for our Microsoft Convention a little too late, so we ended up staying a 50 dollar a night motel in the Ghetto. Think of "My Name is Earl"  when you see these photos. Even the locals are nice and friendly!