General Guidance for SQL Server on Virtualisation

I have been on about four engagements in a row this year where we are looking at SQL performance on VMWare or Hyper-V. Here is a list of common things that you can do with virtualisation that may adversely affect SQL performance. Most of them also apply to physical environments, for example if you are…


Hidden Network Devices

One annoying thing about working with Hyper-V  is you can end up with lots of “hidden” network devices. For example: a) If you installed using a RIS server and legacy NIC b) If you moved a VHD between servers, the NIC gets a new MAC address and device c) If you use clustering and haven’t…


Taking PowerPivot and Your Domain on the Demo Road

One of the current Technical Limitations of PowerPivot for SharePoint is the fact that the PowerPivot Server must be connected to a domain controller for full functionality. My holy grail has been to get PowerPivot Server working quickly in my humble laptop running Windows Hyper-V R2 – Not so easy when you need to either…

2

The Last SQL Academy in this series goes out in style

The last topic in the series is entitled “SQL 2008 R2 – Next Generation Business Intelligence”. We hope to cover three main improvements in the SQL 2008 R2 release: a) PowerPivot for Excel b) PowerPivot for SharePoint c) Reporting Enhancements As usual we hope for it to have a lot of demos and the more…