Archive | April 2010

SQL Server R2 RTM

SQL Server 2008 R2 officially RTM’d.

I’ve been working with the SQL CTP and SharePoint Beta, and the BI story is pretty incredible.  Here’s a quote that’s pretty accurrate (it’s not as easy as they make it sound, but the BI capabilities are still pretty impressive).

With the release of SQL Server 2008 R2, Microsoft is introducing powerful new managed self-service BI capabilities, bridging the gap between IT professionals and end users by leveraging familiar tools such as Microsoft Excel 2010 and Microsoft SharePoint Server 2010. With the new BI technology named PowerPivot, end users can bring data from virtually anywhere and manipulate large datasets with ease while still enabling IT to monitor and manage user-generated BI solutions.

As soon as the code his MSDN, it’ll be time to rebuild the SharePoint 2010 SQL server.

TechNet blog found here:  http://bit.ly/SQL2008R2RTM  
Press Release found here: http://www.microsoft.com/Presspass/press/2010/apr10/SQL08RTMPR.mspx

Use PowerShell to Get ManagedPaths in SharePoint 2010

Just a quick post here. I wanted to get a list of all Managed Paths in my SharePoint 2010 farm.

So I first saw

Get-SPManagedPath

Next, I found it’s parameters by using

get-help get-spmanagedpath

Note: If you use it without a parameter, it prompts you for the web app url. Kind of neat. The PowerShell ISE actually displays a dialog window, while the PS> cmd prompt asks for a parameter.

Knowing that I could get a list of web applications from somewhere, I found

get-spwebapplication

And then piping each webapplication’s “url” property to another commandlet will get me what I’d like. And that is a listing of all managed paths in my farm.

get-spwebapplication | foreach { Get-SPManagedPath -WebApplication $_.url }

From there, it was all playing with the script to save both the web application url and the managed path. Here’s what I came up with:

And here is the code if you need to copy and paste it.

clear-host
write-host "------ BEGIN -----"
write-host ""
Add-PSSnapin Microsoft.SharePoint.Powershell
$a = New-Object System.Collections.ArrayList
$webapps = get-spwebapplication
foreach ($webapp in $webapps)
{
    $paths = Get-SPManagedPath -WebApplication $webapp.url;
    foreach ($path in $paths)
    {
        $a.Add( $webapp.url + $path.name );
    }
}
#Write out the results if you need them
$a
write-host ""
write-host "------ END -----"

Next stop, creating a managed path with PowerShell.

Where is the link to Create a Managed Path in SharePoint 2010 Central Administration?

This morning I was wondering: Where did my Central Admin link to Managed Paths go?

If you’ve been looking around for the link to Define a Managed Path in SharePoint 2010, stop looking. It’s not on the Central Administration “Control Panel” page(s). Instead, when you go to create a new Site Collection, there is a link.

If you are like me, you have a predefined set you want to use. Until I get the PowerShell commands posted, use this:

http://<centraladmin>/_admin/scprefix.aspx

To remember it, all pages in CA are either in _admin or in _layouts. This one is admin, and then Site Collection Prefix (or scprefix.aspx).

I only post this just as a tip in case you were going crazy looking for it!

Download SharePoint Foundation and SharePoint Designer

Where can I download SharePoint Foundation and SharePoint Designer? Right here:

SharePoint Foundation   http://bit.ly/MSF2010

SharePoint Designer http://bit.ly/SPD2010

SharePoint 2010 is released to web on MSDN today!

SharePoint 2010 is on MSDN, or Release to Web (RTW), today.
Now it’s time to build new VM’s, make any changes for presentations, and update the book I’m coauthoring.

I just got really, really busy!

SharePoint 2010 Error with Performance Point Dashboard: The data source no longer exists or you do not have permissions to view it. Additional details have been logged for your administrator.

Note: SharePoint 2010 Beta 2

While using Performance Point’s Dashboard Designer, I received the following error.

The data source no longer exists or you do not have permissions to view it. Additional details have been logged for your administrator.

I went into the event log, and saw this:

Here is the text:

An exception occurred while running a report. The following details may help you to diagnose the problem:
Error Message: The data source no longer exists or you do not have permissions to view it. Additional details have been logged for your administrator.

Contact the administrator for more details.
Dashboard Name:
Dashboard Item name:
Report Location: {fc25930f-590e-26ac-7da4-f60f076f7b32}
Request Duration: 119.02 ms
User: SPS\david.frette
Parameters:

Exception Message: The data source no longer exists or you do not have permissions to view it. Additional details have been logged for your administrator.
Inner Exception Message:
Stack Trace: at Microsoft.PerformancePoint.Scorecards.Server.PmServer.ExecuteAnalyticReportWithParameters(RepositoryLocation analyticReportViewLocation, BIDataContainer biDataContainer)
at Microsoft.PerformancePoint.Analytics.ServerRendering.OLAPBase.OlapViewBaseControl.ExtractReportViewData()
at Microsoft.PerformancePoint.Analytics.ServerRendering.OLAPBase.OlapViewBaseControl.CreateRenderedView(StringBuilder sd)
at Microsoft.PerformancePoint.Scorecards.ServerRendering.NavigableControl.RenderControl(HtmlTextWriter writer)

PerformancePoint Services error code 20604.

I solved this issue by adding my user account to the visitors group of the site. Crazy!

New Theme Enabled

I’ve enabled a new theme on this WordPress blog. It is a flexible width them, which allows the content area to expand with the size of the browser width. I finally found one that was ‘acceptable.’

I don’t particularly enjoy any of the wp themes. I can’t wait to migrate this to SharePoint 2010.

Soup to Nuts: MMS at a SharePoint Saturday near you

Soup to Nuts: Everything you need to know about the MMS at SharePoint Saturday
4/17 – Atlanta
5/1 – Houston
others to be announced

SharePointSaturday’s are free events held all across the world. They promote learning and interaction in the local SharePoint communities.

I’ll be speaking at SPS (ATL, HOU, …) about the Managed Metadata Service. Here are just some of the things I’ll cover:

– What is the MMS and what does it offer?
– How is it any different that the BCS?
– Enterprise architecture
– Small businesses architecture
– How access zones (internet, intranet, and extranets) affect your architecture
– The different ways to populate the MMS
– MMS Security considerations
– How to configure Content Type Syndication
– Configuration considerations for Content Type Syndication
– Using PowerShell to perform maintence tasks
– Using C# to perform developer tasks
– Linking Fields/Columns to MMS
– How to use the MMS in your custom applications

Performance Testing of Adding Unique Terms to the TermStore (Managed Metadata Service) using PowerShell

Performance Testing of Adding Unique Terms to the TermStore (Managed Metadata Service) using PowerShell

Continuing on in my MMS endeavor for my Soup to Nuts: The Managed Metadata Service presentation is testing how long it takes to add completely unique terms to the TermStore.

Again, at no point in my test did RAM hit the max available or CPU top out at 100%.

These are unique terms across the entire term store.

Time per 100,000 terms

  • 1st 100k 28 minutes
  • 2nd 100k 63 minutes
  • 3rd 100k 90 minutes
  • 4th 100k 130 minutes
  • 5th 100k 166 minutes

Total Time (rounded)

  • 100k 28 minutes
  • 200k 91 minutes
  • 300k 151 minutes
  • 400k 281 minutes
  • 500k 447 minutes

The code for this is here:

How to use PowerShell to upload a million terms to the SharePoint 2010 Term Store