Mesh’d!

Posted on Leave a commentPosted in Uncategorized

I’ve been playing around with the Live Mesh technical preview for a few weeks now. Once I found this way todisable UAC prompting without disabling UAC, I was able to install and use Mesh. So far there’s not much more to Live Mesh than file sharing and remote control, which makes it a bit of […]

Pivot queries

Posted on Leave a commentPosted in Uncategorized

I stumbled across the PIVOT keyword while poking through the dynamic management tables in SQL trying to track down some sproc recompiles. Pivots are great for denormalizing data for easy reporting. OLTP schema is great for quick insert/update/deletes but piecing data together into something useful can be a pain. A simple budget table that tracks […]

DTS to SSIS migration

Posted on Leave a commentPosted in Uncategorized

I’ve been working the past few weekends on migrating DTS packages off our dying, 8-year old SQL2000 server over to new SSIS packages. The performance is markedly improved, often over 50% faster with SSIS for a single datapump task. The DTS-to-SSIS migration wizard is also working remarkably better than I expected, 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 version of ANTS Profiler. I have mostly focused on memory usage over the last week trying to track down issues for our client. When the app started up, there was a long delay before we got UI-responsiveness. I figured this was just overhead from […]

Quick Launch keyboard shortcuts

Posted on Leave a commentPosted in Uncategorized

I was trying to use a keyboard shortcut I set up for Windows Key + ` and accidentally fat-fingered the 1 instead. To my bewilderment Visual Studio launched. I hit it again and got another instance of VS. Windows+2 launched VMware and Windows+3 launched SQL Management Studio. After bumbling around for a bit, I realized […]

Product Pimping (and pleading)

Posted on Leave a commentPosted in Uncategorized

A while back, I got the opportunity to test out Hyperbac, a backup solution for SQL Server. I love pimping Hyperbac because it is dirt-cheap and has seamless integration with SQL 2005. Most third-party backup products required using extended stored procs to do backups, which killed my ability to use SQL 2005’s vastly improved maintenance […]