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
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
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
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
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
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
Increasing the size of a vmware virtual disk
Adventures in updating the size of the virtual hard disk via VMWare Workstation. Continue reading
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
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
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