September 2008 - Posts

• Aggregating Aggregates and UNION vs. UNION ALL

  Sometimes you need to aggregate the results of multiple queries. There are several ways to accomplish this (a CTE is particularly elegant). I decided on the following solution because it provides instruction in aggregates, aliases, and when to use UNION Read More... Posted Tuesday, September 23, 2008 11:39 AM by John Paul Cook | 3 Comments

• Moving Virtual Machines to Hyper-V

  The best tool for converting virtual machines to Hyper-V is System Center Virtual Machine Manager 2008, which is available in October 2008. It has a physical to virtual (P2V) tool that works quite well. Unfortunately, it has to be installed on a domain Read More... Posted Sunday, September 21, 2008 9:26 AM by John Paul Cook | 0 Comments