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…

0

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…

0

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…

0