Kevin Harmer on SharePoint in Tech.Days 2011

On November 16, 2011, Kevin Harmer presented in Tech.Days 2011 how business users can be empowered to create self-service analytic BI applications by harnessing the power of SharePoint.

Microsoft BI Intelligence

1- SharePoint 2010 provides a powerful suite of BI tools that enable self-service BI by power users and analysts.

2- Each SharePoint 2010 BI tool has unique advantages that align to specific performance management use cases, empowering analysts to leverage the right tool for a given corporate BI goal.

– Chart/ Status List Web Parts – quick web part analysis
– Excel Services – corporate analytic
– PowerPivot Services – self-service data integration
– PerformancePoint Services – enterprise scorecards /dashboards
– Visio Services – graphical analysis
– Reporting Services – enterprise reporting

3- Microsoft BI tools are accessible, integrated, robust, and support your organizations data-sources.

4- Fully leverage your existing Microsoft software investment by practicing Microsoft BI.

Stephen Cawood on SharePoint in Tech.Days 2011

On November 16, 2011, Stephan Cawood presented in Tech.Days 2011 the performance of file share migrations and BLOB offloading with EBS, and RBS.











File Share Options in SharePoint

Option 1. You can use the out of the box features of SharePoint to upload files
Option 2. You can ‘index’ your content in SharePoint but keep the files on other storage
Option 3. You can use a migration solution to transfer your files with all the associated metadata

SharePoint BLOB Remoting Techniques

A. SharePoint EBS
1- The EBS technique is deprecated in SharePoint 2010, but it is still supported.
2- It is based on Legacy COM architecture. The COM interface is complicated.
3- It does not have orphaned BLOB garbage collection.

1- The RBS techniques is only supported in SharePint 2010.
2- It is based on .NET COM architecture. The .NET interface is well documented.
3- It supports orphaned BLOB garbage collection.

The RBS technique can be used with either of option 2 or option 3.

C. Stubs or HTML Redirects
1- It involves writing to the SharePoint database directly that is not supported.
2- HTML Redirects are not compatible with SharePoint OM use.

Backup and Restore Times for 100 GB Database

LINQ to SharePoint 2010

The LINQ to SharePoint Provider is defined in the Microsoft.SharePoint.Linq namespace. It translates LINQ queries into Collaborative Application Markup Language (CAML) queries. It is no longer necessary for developers to know how to write CAML queries. LINQ queries can be used in server code. To query from a client application, use SharePoint’s support for ADO.NET Data Services.

The gateway class for the LINQ to SharePoint provider is Microsoft.SharePoint.Linq.DataContext which represents the data of a SharePoint Foundation Web site.

It is parallel in use and function to the System.Data.Linq.DataContext class in the LINQ to SQL provider. Just as the latter class has a GetTable method that returns a Table(Of TEntity) object that implements System.Linq.IQueryable(Of T), the Microsoft.SharePoint.Linq.DataContext class has a GetList(Of T) method that returns an EntityList(Of TEntity) class that implements System.Linq.IQueryable(Of T). It is objects of type EntityList(Of TEntity) that are queried.

The following is an example of the use of LINQ to query SharePoint Foundation.

Copyright © All Rights Reserved - C# Learners