I can see the new metro look will be all over the place. Now all lists and libraries are Apps… This is going to start confusing end users. Site settings seems the same. Central Admin still has a similar layout. Which is good. But now there’s an App Store.
I know i only post about technology related content. But us techies need to stay in shape as well. I just joined an awesome gym. Its really a gym with a full SPA for the wifey. If you want to try it out, please contact Jennifer @ 305.935.9514, just mention AJ Alacan and she’ll hook you up.. more details here: http://www.equinox.com/ It doesnt matter where you live, she can get you a pass for any Read more…
I found a great set of custom actions called iLoveSharePoint. One of the actions is an Execute SQL action. Very handy for sending data from a list to SQL. I’ve started sending data to SQL so i can use Reporting Services to create dashboards to report item history. You can download the solution from codeplex: http://ilovesharepoint.codeplex.com/
Power view seems awesome eventhough it uses Silverlight. Contoso Energy Demo: https://businessintelligencedemoportal.com/sites/contosoenergy/SitePages/pvrsample.aspx More demos here: http://www.microsoft.com/en-us/bi/GetMicrosoftBI/TryIt.aspx
By default the Assigned To allows multiple selections that will not allow you to group by. Just set allow multiple selections to No and then you will be able to Group By Assigned To
Column Ordering in List Settings was not being displayed because i had “Allow management of content types” set to “yes”. So if you set it to No, you will be able to order columns again.
One of my developers was having an issue refreshing data using excel services in browser to Analysis Server 2008. It seems he added PowerPivot for excel that change some default connection string setting in excel. His connection string was generating “provider=MSOLAP.5;…” Which is not listed as a trusted provider in Excel Services. Once i added MSOLAP.5 as a trusted provider, data refresh worked in browser!
I found a great flowchart for troubleshooting data refresh in excel services for SharePoint 2010. I also ended up using the Secure Store instead of kerberos. I had a few issues connecting to OLAP, but this diagram helped. View PDF: Excel Services Troubleshooting
One of my developers was getting a connection timeout on using an External Content Type. The real problem was that BCS has a limit of 2000 rows returned in a query. Here’s a PowerShell script to edit that limit: $wthbcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)} $BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $wthbcs $BCSThrottle Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000
SharePoint 2010 and Office 2010 Hyper-V VHD files are now available for download. It’s spit up in 23 files for SharePoint 2010. This includes Windows Server 2008 R2, SharePoint 2010, Office 2010, Visual Studio 2010, SQL Server 2008 R2. Theres 2 more VMs for Exchange and Communicator. http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27417