Friday, December 24, 2010

Sharepoint 2010 Capacity Planning and Sizing Tool

In the last few months I had a few projects where I had to plan the capacity of SharePoint Server 2010 farms. There are some very useful resources in Technet:
Capacity management and sizing for SharePoint Server 2010
http://technet.microsoft.com/en-us/library/cc261700(office.14).aspx
Storage and SQL Server capacity planning and configuration (SharePoint Server 2010)
http://technet.microsoft.com/en-us/library/cc298801(office.14).aspx
Actually the second article was my starting point for this blog post. The question was – how to size the storage for Sharepoint Server 2010 HA environment? I created an Excel sheet which implemented all rules and advises, mentioned in the resources above. You could download and use it for your projects and of course feel free to customize it. I’ll be very thankful if someone decide to contribute and extend the existing content!

Open it directly from SkyDrive: Sharepoint 2010 capacity planning and sizing sheet

Tool Reference
The idea behind this tool is that for each Sharepoint Server 2010 deployment stays a particular business need. Almost always we have a content, which has to be uploaded after deployment and this is our initial data. This data always grows and our sizing and capacity planning approach has to cover this important factor.
General Sites Sizing Sheet
image
Enter in this section your initial files count and volume in GB
image
Decide how many initial sites you will have in the farm (one row for each) and divide your initial files between them – as count and as volume.
image
Define a growth model for each site collection for the next 1 year using the tables. The final size (colored cell) will be auto populated in the above table.
You could find a detailed description of the used formula in Technet
http://technet.microsoft.com/en-us/library/cc298801.aspx
image
Cell B26 formula: =(B19*B21*B23)+(10*(B22+(B23*B19)))
You can always see the formula details for particular cell from Ribbon/Formulas tab/Formula Auditing group (Excel 2010)
image
Capacity Sheet
Use the screen shots below, Formula Auditing tools and Formulas in the Excel file to understand the logic of the calculations.
image
image
image
image
image
image

Saturday, November 27, 2010

SUGBG and Telerik

On 24 November we did a SUGBG meeting together with Telerik, They presented the integration of their AJAX, Silverlight and Reporting with Sharepoint 2010. It was a great session with a lot of questions, discussions and feedback. Thanks guys!

Follow us up in Facebook

Saturday, October 23, 2010

Troubleshooting User Profile Service

Wow, it it amazing troubleshooting experience. Did you get your User Profile Service (Sharepoint 2010) working without issues?

if (upsWorking)

{Console.WriteLine(“You are lucky man”);}

Smile

So, some useful resources, thanks to Stefan for share!

Probably the best guides are here (thanks to Spence)

Rational Guide to implementing SharePoint Server 2010 User Profile Synchronization
“Stuck on Starting”: Common Issues with SharePoint Server 2010 User Profile Synchronization

On third place I’ll put the Technet article

http://technet.microsoft.com/en-us/library/ee721049.aspx

Good luck with UPS!

Devil

Thursday, August 5, 2010

How to Use Metadata Navigation in Enterprise Wiki Site (Sharepoint 2010)

If you want to use Metadata navigation tree in Enterprise Wiki Site, you have to do the following:

  • Activate Metadata Navigation and Filtering feature on site level

image

  • Navigate to Library settings page of your “Pages” library and select Metadata navigation settings
  • From “Configure Navigation Hierarchies” select “Wiki Categories” and click “Add” and “OK”

image

  • Navigate to Pages library again

http://<Your Wiki Site Url>/Pages/Forms/AllItems.aspx

clip_image001

But when you click on any of the pages on the right panel, the navigation tree will disappear. 

clip_image001[5]

You have to change the EnterpriseWiki.aspx page layout or better to create and deploy a new one (via Sharepoint Designer or wsp)

You have to include a reference to MetadataNavTree control and put it in some placeholder (PlaceHolderLeftActions) on the page layout aspx file.

  • Put this markup in the beginning of the page

<%@ Register TagPrefix="wssuc" TagName="MetadataNavTree" src="~/_controltemplates/MetadataNavTree.ascx" %>

  • Put this code in the end of page’s code, after the next </asp:Content> tag

<asp:Content id="Content1" runat="server" contentplaceholderid="PlaceHolderLeftActions">

<wssuc:MetadataNavTree id="mdnt" runat="server" />

</asp:Content>

The result is:

image

image

How to Fix Sharepoint 2010 DCOM 10016 Error on Windows Server 2008 R2

If you get DCOM error 10016 in your event error, it means, that you have to configure local activation permissions of IIS WAMREG admin Service for your farm account.

Open Component Services/Computers/My Computer/DCOM Config/IIS WAMREG admin Service , Properties –> Security tab

image

Ooops … all controls are inactive?!?! The picture was different in WS 2003 and 2008, but in 2008 R2…. Smile

Open “regedit” and search for

HKEY_CLASSES_ROOT\AppID\{61738644-F196-11D0-9953-00C04FD919C1}

Right click, “Permissions” and click “Advanced” button, open “Owner” tab

image

Select some of the listed names or browse for another user or group and finally click Apply

image

Now, you (or your group) can change the permissions for modification of the service

image image

 

After “OK”, try to reopen the “Component Services” console and open the properties window of IIS WAMREG admin Service. now the picture is a little bit different Smile

image

Tuesday, July 6, 2010

Telerik Components for Sharepoint 2010

In their ASP.NET AJAX Q2 Beta release, Telerik packaged RadEditor and RadGrid as standalone web parts for Sharepoint 2010.

“Need to use our AJAX controls in a custom Sharepoint 2007/2010 implementation? Not a problem at all. RadEditor, RadGrid and the rest of our ASP.NET AJAX components can also be plugged very easily into Sharepoint 2007/2010 visual/dynamic web parts, or placed directly into Sharepoint pages/user controls.”

Telerik Sharepoint 2010 Demo Site: http://sharepoint.telerik.com/Pages/default.aspx

You can play with RadGrid web part after login with:

User: .\sp2010visitor

Pass: sp2010visitor

Here http://sharepoint.telerik.com/silverlight/Pages/default.aspx you can find screen casts from Sahil Malik, how to use Telerik Silverlight controls in Sharepoint 2010, together with Sharepoint client object model. Enjoy! Smile

image

Wednesday, June 30, 2010

SQL Server 2008 R2 Community Launch

Yesterday (June, 29) we launched the SQL Server 2008 R2 in our local SQL&BI and Sharepoint user groups. The event started at 17 PM in business center ‘Iliev’. Together with Magi and Galin we delivered two presentations:

SQL Server 2008 R2 – Perception v/s Reality – Covering all new features in this release: Application and Multi-server Management, Master Data Services and StreamInsight

SharePoint 2010 and SQL Server 2008 R2 – a smooth integration for a complete BI Solution – PowerPivot and integration with Sharepoint 2010, Reporting Services and consumption of OData from PowerPivot.

You can click the presentation’s title to get the PPTX file.

30462_410925709790_643429790_4207202_8262334_n 36474_410926954790_643429790_4207241_826429_n

34612_410926734790_643429790_4207239_4947612_n 34531_410925454790_643429790_4207191_1927356_n

35397_410926214790_643429790_4207227_1797723_n

The Live Meeting recording of Magi’s sessions is here. Unfortunately, the record of mine presentation has been failed, but the next will be more successful, I promise! Smile

Friday, May 21, 2010

User Profile Synchronization Error MOSS MA not found

When I tried to define connection to my profile store (Active Directory), I got the error: “MOSS MA not found”. This article gave me a help, but solution was:

I went to Services console and started Forefront Identity Manager Service. After that I restarted ForeFront Identity Manager Synchronization Service.

The profile connection was created successfully! Smile

Tuesday, April 20, 2010

Capacity Planning for Sharepoint 2010

When Sharepoint 2010 RTM has been released on April 16th, the new Capacity Management site went live. There you can find earlier released architecture Visio documents and planning guides, as well as links to few recommendations from Technet.

Wednesday, March 31, 2010

MS Days 10 Presentations

Here you get my presentations for MS Days 2010 (Bulgaria). They are created with Office 2010 RC Smile

ms-days-10
Office 2010 trailer

Sharepoint 2010 for Developers

ECM with Sharepoint 2010

 

Saturday, March 6, 2010

Sharepoint 2010 RTM is Coming in April

Today, we officially announced that May 12th, 2010, is the launch date for SharePoint 2010 & Office 2010. In addition, we announced our intent to RTM (Release to Manufacturing) this April 2010. 

It’s an exciting time for us! We hope you can virtually join us on May 12th at 11am EST to listen to Stephen Elop, President of the Microsoft Business Division, announce the launch. You can register for the event @ http://sharepoint.microsoft.com/businessproductivity/proof/pages/2010-launch-events.aspx

Arpan Shah
Director, SharePoint

Link to Facebook announcement

Sharepoint 2010 Ignite Wave in Bulgaria is Starting Next Week

Майкрософт България ще организира 8 Sharepoint 2010 Ignite обучения за партньори и клиенти. Първата вълна започва следващата седмица (8-ми март) в центровете за обучение на New Horizons  и СТЕМО. Очаквайте допълнителна информация за регистрацията и програмата тук и във Фейсбук сайта на SUGBG.

image

Първото обучение за IT Pro за корпоративни клиенти ще се проведе от 8 до 10-ти март, а програмата ще покрива темите:

  • Intro to Sharepoint 2010
  • Introducing Architectural Changes in 2010 (incl. HOL)
  • Services Applications (incl. HOL)
  • Business Continuity Management (incl. HOL)
  • Enterprise Search: Sharepoint Search and FAST (incl. HOL)
  • Upgrade
  • ECM Changes (incl. HOL)
  • Business Connectivity Services (incl. HOL)
  • New Social Features
  • ‘Office’ Services 2010

Съответно, обучението за разработчици за корпоративни клиенти ще бъде отново тридневно и ще започне на 16 март.

Ако желаете да се включите, изпратете E-mail на ignite@sugbg.org и ще ви изпратим информация за регистрацията.

За Sharepoint 2010 Ignite for Devlopers за партньори на Майкрософт намерете повече информация тук

Saturday, February 6, 2010

Wednesday, January 27, 2010

Saturday, January 23, 2010

Microsoft Days 2010

imageIt’s conferencing time, the biggest Microsoft event in Bulgaria is scheduled for 30-31 March 2010.  The registration is already opened, you can see all speakers, sponsors and exhibitors (the content is still in progress).

 

 

I shall have two presentations there:

Enterprise Content Management with SharePoint 2010 (Level: 200)
and
SharePoint 2010 for Developers (Level: 300)

Come and see also Magi’s SQL sessions! Magi achieved Microsoft Certified Master: SQL Server 2008 and I’m sure, it will be great content, emotion and fun!

fcb_msdays10

Thursday, January 21, 2010

SUGBG (Meeting 8): Sharepoint 2010 Overview

We did our eighth Sharepoint Group meeting on 20-th of January. Fifty professionals came to see the new features of Sharepoint 2010. We spoke about news for IT Pros, Developers and end users. I had only four slides and 1 hour demo! :)

Monday, January 4, 2010

MOSS 2007 List IDs

 

List ID

 

List type

100

Generic list

101

Document library

102

Survey

103

Links list

104

Announcements list

105

Contacts list

106

Events list

107

Tasks list

108

Discussion board

109

Picture library

110

Data sources

111

Site template gallery

112

User Information list

113

Web Part gallery

114

List template gallery

115

XML Form library

116

Master pages gallery

117

No-Code Workflows

118

Custom Workflow Process

119

Wiki Page library

120

Custom grid for a list

130

Data Connection library

140

Workflow History

150

Gantt Tasks list

200

Meeting Series list

201

Meeting Agenda list

202

Meeting Attendees list

204

Meeting Decisions list

207

Meeting Objectives list

210

Meeting text box

211

Meeting Things To Bring list

212

Meeting Workspace Pages list

300

Portal Sites list

301

Blog Posts list

302

Blog Comments list

303

Blog Categories list

1100

Issue tracking

1200

Administrator tasks list

2002

Personal document library

2003

Private document library