Registration is still open for SQL Academy on Tuesday 1st December in the usual place (Sandyford, Dublin). For those of you who are new to SQL Academy – the aim is to bring level 300-400 content to SQL professionals in Ireland via half day seminars. The...

On my first week trying to setup PowerPivot I was plagues with an inability to see the sexy new silverlight previews of the mashup’s in SharePoint. The error message was “An Error Occurred while capturing snapshots for this document” To help debug, this...

Using the new “Default Install” option in SQL Server 2008 R2 I managed to get a full instance installed (Tools, Db Engine, SSAS, SSIS) in 18 minutes flat on a Hyper_V guest. Maybe this will become some sort of benchmark test for new servers…

If you are using the new “Gemini Team Site” in SharePoint 2010 (I guess this must be renamed in the Beta-2). You may notice that we can’t add Data Connection Libraries to work with traditional BI sources. This is just because it is not a site feature...

Three common issues integrating office and MOSS when using Server 2008 as a client: 1) Office cannot browse SharePoint 2) Credential Prompts 3) Where has my Network Places Gone   1. Office Cannot Browse SharePoint I’ve seen a few times that office...

Ok, everyone is hopefully aware that Gemini is now renamed to “PowerPivot”. IMO, this technology is set to make a very big impact on the Business Intelligence Industry. Here in Ireland, nice players like Qlikview have been doing very well over traditional...