BeejBlog


Personal ramblings of a lifelong tinkerer
  • PowerShell f’in rocks!

    By Beej
    Main Microsoft landing page for PowerShell… download and install it!!  (if you’re running Windows Server 2008, it’s already loaded) Out of the box executing PowerShell scripts is completely disabled for security… there’s a couple immediate tasks to enable… Go find the PowerShell icon and fire it up… Vista (booo hiss!)... [Read More]
  • SQL Server "CHECKSUM()"

    By Beej
    Absolutely crazy I hadn’t run across this little gem yet… could’ve used that bugger to get out of a couple jams.  e.g. eliminating heavily duplicated xml blobs that represent incoming supply chain events/transactions.  The BOL has a couple examples to get your juices flowing.  e.g. Run it on a column... [Read More]
    Tags:
  • Volume Shadow Copy Service is Pretty Cool

    By Beej
    (at least in Windows 2008) More specifically the “Previous Versions” functionality that leverages this service. To cut to the chase, I didn’t realize that you could browse into whole folders worth of snapshots… screenshot below says it all… Notice that there’s a funky “localhostdrive$@GMT…” syntax for getting at the old... [Read More]
    Tags: