Ramblings about missing time … and #PowerPivot sneak peek!

Wow, I just checked and its been more than a month since I did my last blog post!  So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But I do have a good excuse!  Really! Oh, and for those of you patient enough to read to the end, I do have an interesting sneak peek for you 🙂 RTM… aaaaaaahhhhhh!! RTM is driving me nuts…but then again, Dave Wickert (PowerPivotGeek) has been handling…

Rate this:

Pros/Cons of deploying #SSIS with the SQL engine server

I was asked a pretty good question recently on what are the pros and cons of deploying SQL Server Integration Services packages on the same server that has your SQL Engine Server as well.  While we covered a lot in Top 10 SQL Server Integration Services Best Practices, we never really addressed this issue specifically – so let’s do it: Advantages of placing SSIS and SQL on the same server: You can use the SQL Server Destination instead of OLE DB which allows you to load data into SQL faster. You remove network as a bottleneck for insertion of data…

Rate this:

More great PowerPivot resources!

As you already may know, we have a couple of forums for PowerPivot at: SQL Server 2008 R2 PowerPivot for Excel SQL Server 2008 R2 PowerPivot for SharePoint Dave Wickert with his PowerPivotGeek.com site has also created two new sections: Reported Problems section which compiles the different issues concerning PowerPivot for SharePoint installations and Troubleshooting section which complies different Troubleshooting issues concerning PowerPivot for SharePoint installations. Please do not forget that the all four PowerPivot for SharePoint installation guides can be found here as well.   Rob Collie has also put together: The Great PowerPivot FAQ where you can see…

Rate this:

Handling Cross-forest deployments

In many corporate or external-facing SharePoint deployments, it becomes necessary to develop multiple forests or domains to handle different users.  A great explaination of this concept can be found in the SharePoint Team’s blog on Support for Cross-forest deployments.    The basic idea here is that you have two domains, e.g. DomainA and DomainB.  DomainA has your SharePoint servers and you want to be able to add users from DomainB to be allowed access to your site.  An example would be to use the People-Picker on your SharePoint site and you want to add DomainBUser1.  This can work if there…

Rate this:

Failed to provision the SharePoint Central Administration Web Application

In this situation, I ended up getting the error message: Failed to provision the SharePoint Central Administration Web Application   My setup is a Windows Server 2008 Enteprise x64 box with SQL Server 2008 – attempting to configure my recently installed SharePoint 2007.  That should have done the trick but I ended up getting the above error message anyways.  After some additional research, it became apparent that my IIS 7.0 installation was incorrect.  And once I fixed that, I was good to go.   So thanks to Jonas Nilsson on the linked thread below for identifying that IIS was the…

Rate this: