Category Archives: Uncategorized

DQS Services in Denali

Interesting article about the upcoming Data Quality Services feature in Denali. It’s worth mentioning, as it’s very similar to the Data Quality Control system that I developed (with a little inspiration from my friend) for our current data mart. In … Continue reading

Posted in Uncategorized | Leave a comment

T-SQL Alter Statement Quirk

To answer a recent question to the PSSUG user group e-mail, I put together a post instead of trying to answer via e-mail. First, the question: I have a staging table. Stage_id identity Stage_File_Name nvarchar(100) AllData nvarchar(max) I load a … Continue reading

Posted in Uncategorized | Leave a comment

T-SQL Creativity

This article has little to do with useful t-sql applications – since to me, minesweeper is meant for a mouse. However, it really demonstrates a fun use of t-sql. Minesweeper in T-SQL

Posted in Uncategorized | Tagged , | Leave a comment

WordPress 3.0.1 upgrade hung!

Just in case anyone’s site gets hung on an upgrade, this is a great tip to get out of maintenance mode. Stuck WordPress Fix I have no idea what caused the issue – I have two WordPress sites with identical … Continue reading

Posted in Uncategorized | Leave a comment

Thought of the day

I was doing some research for a project and stumbled across this gem. I did a quick search for a source, but only found variations on a theme. People don’t want to buy a quarter-inch drill. They want a quarter-inch … Continue reading

Posted in Uncategorized | Leave a comment

Outside the Box Thinking

I had a problem to solve recently, and essentially it boiled down to a need to do multiple pivots in one statement. After playing with it for a little while and not quite getting it the way I wanted, I … Continue reading

Posted in Uncategorized | Leave a comment

Increasing the size of a vmware virtual disk

Adventures in updating the size of the virtual hard disk via VMWare Workstation. Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Getting back on the horse…

It’s been three weeks since I spent much time thinking about this site, mostly due to the distractions of starting a new gig and learning a whole new system. I know I’m not the first to think or say… type… … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Two Weeks Notice & New Employment

I recently accepted a new position at another¬†organization. You can check it out on my resume online. It’s been a bit of a whirlwind experience for me, since my former employer had done a lot for me over the years. … Continue reading

Posted in Uncategorized | Leave a comment

Tooting my own horn: Pass Blog Directory

Not that it’s the largest accomplishment in the world, but I was recently added to the PASS Blog Directory. I have been trolling that list for tips and tricks to use in our production environment at work long before I … Continue reading

Posted in Uncategorized | Leave a comment