Tags » Windows Server 2008 R2

Hyper-v host can't migrate virtual machines

We finally found the problem that has been plaguing us for years.  The situation is a 3 node 2008 R2 Hyper-V cluster.  When trying to live migrate a virtual machine off of one node to another it fails.   113 more words


How To: Migrate DHCP for Windows Server

Migrating DHCP roles between Windows servers can be painful. I wanted to share my favorite method for doing this. I think it is the least difficult and the most effective way of getting your DHCP services moved to a newer Windows server with ZERO downtime. 448 more words

How To's

Median Strip

SQL Server has a number of aggregate functions including MAX, COUNT and AVG, but if you want to calculate MEDIAN you will be rolling your own, probably with a little help from Google. 1,577 more words


Updating Statistics on Steroids

Updating statistics on large tables can take a while.  A page-compressed warehouse fact table with 19 billion rows, 1000 partitions, a sensible clustered index, and 35 columns occupying in excess of  1TB disk space on my server takes around 22 hours to update its 33 stats objects using the default sample size.  2,686 more words


How to: Migrate Windows file server shares with NTFS permissions

Over the years I have seen so many approaches to migrating Windows file server shares to new servers. Most methods are valid and some are down right brilliant uses of native tools. 1,299 more words

How To's