Mesh'd!

Posted on Leave a commentPosted in Uncategorized

I've been play­ing around with the Live Mesh tech­ni­cal pre­view for a few weeks now. Once I found this way todis­able UAC prompt­ing with­out dis­abling UAC, I was able to install and use Mesh. So far there's not much more to Live Mesh than file shar­ing and remote con­trol, which makes it a bit of […]

Pivot queries

Posted on Leave a commentPosted in Uncategorized

I stum­bled across the PIVOT key­word while pok­ing through the dynam­ic man­age­ment tables in SQL try­ing to track down some sproc recom­piles. Piv­ots are great for denor­mal­iz­ing data for easy report­ing. OLTP schema is great for quick insert/update/deletes but piec­ing data togeth­er into some­thing use­ful can be a pain. A sim­ple bud­get table that tracks a […]

DTS to SSIS migration

Posted on Leave a commentPosted in Uncategorized

I've been work­ing the past few week­ends on migrat­ing DTS pack­ages off our dying, 8-year old SQL2000 serv­er over to new SSIS pack­ages. The per­for­mance is marked­ly improved, often over 50% faster with SSIS for a sin­gle dat­a­pump task. The DTS-to-SSIS migra­tion wiz­ard is also work­ing remark­ably bet­ter than I expect­ed, even for some of […]

More ANTS Profiler

Posted on Leave a commentPosted in Uncategorized

My pleas were answered (thanks!) and I now have a Pro ver­sion of ANTS Pro­fil­er. I have most­ly focused on mem­o­ry usage over the last week try­ing to track down issues for our client. When the app start­ed up, there was a long delay before we got UI-respon­sive­ness. I fig­ured this was just over­head from […]

Quick Launch keyboard shortcuts

Posted on Leave a commentPosted in Uncategorized

I was try­ing to use a key­board short­cut I set up for Win­dows Key + ` and acci­den­tal­ly fat-fin­gered the 1 instead. To my bewil­der­ment Visu­al Stu­dio launched. I hit it again and got anoth­er instance of VS. Windows+2 launched VMware and Windows+3 launched SQL Man­age­ment Stu­dio. After bum­bling around for a bit, I real­ized […]

Product Pimping (and pleading)

Posted on Leave a commentPosted in Uncategorized

A while back, I got the oppor­tu­ni­ty to test out Hyper­bac, a back­up solu­tion for SQL Serv­er. I love pimp­ing Hyper­bac because it is dirt-cheap and has seam­less inte­gra­tion with SQL 2005. Most third-par­ty back­up prod­ucts required using extend­ed stored procs to do back­ups, which killed my abil­i­ty to use SQL 2005's vast­ly improved main­te­nance […]