Installing PowerPivot for SharePoint

Installing and Configuring PowerPivot has been painful for me – Partly because I managed to dive in and not read the readme.txt and release notes 😉 The three things I did wrong and have learned are: – “Standalone” SharePoint option is not supported as this uses network service accounts. (see below why) – Domain accounts…

0

SQL Academy – Performance Tuning & Optimisation

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 target audience is folk who already have experience with…

0

The Gemini/PowerPivot Gallery View

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 – powerPivot has a log file located here: [SystemDrive]:\Program Files\Common Files\Microsoft Shared\Web…

3

New Install Option for SQL 2008 R2

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…

1

Data Connection Libraries missing in SharePoint 2010

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 enabled by default. You can just go into…

1

Integrating Office and SharePoint in Windows 2008

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 2007 or 2010 when installed on Windows 2008 or 2008R2 will not by…

2

Good Power Pivot / Gemini Resources

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 BI tools. The Beta 1 (or CTP2) was invite only ;-), so you…

0

SQL Academy (Dublin, Ireland)– Advanced SQL Configuration

I’m helping deliver a series of advanced seminars for Microsoft TechNet Ireland. The SQL Academy aims to bring level 300-400 advanced content to practising SQL Server professionals in Ireland with the opportunity to bring any questions to a supposed expert in the field 😉 The first session in on Advanced Configuration. We picked this topic…

2

Tools for SQL Discovery

For anyone looking to find out how many SQL Servers they have deployed, and gain insight into resources used or performance – here is a selection of tools I have been using a lot on projects.  Ok System Centre isn’t free, but sometimes I am lucky enough to find it is already installed before we…

1

Paul Randal and Kimberly Tripp at SQL Ireland Users Group in Sept

Paul Randal and Kimberly Tripp are presenting at the SQL Ireland users group on the 23rd September. They were here last year and it was fully booked, with many people not able to get in, so I’d be very surprised if it wasn’t a packed house again. You can book this FREE event at the…

0