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
Storage and SQL Server capacity planning and configuration (SharePoint Server 2010)
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
Enter in this section your initial files count and volume in GB
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.
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
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)
Capacity Sheet
Use the screen shots below, Formula Auditing tools and Formulas in the Excel file to understand the logic of the calculations.

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”);}


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

Good luck with UPS!


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


  • 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”


  • Navigate to Pages library again

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


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


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" />


The result is:



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


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

Open “regedit” and search for


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


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


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


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:

You can play with RadGrid web part after login with:

User: .\sp2010visitor

Pass: sp2010visitor

Here 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


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


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

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 @

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.


Първото обучение за 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 на и ще ви изпратим информация за регистрацията.

За 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)
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!


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


Generic list


Document library




Links list


Announcements list


Contacts list


Events list


Tasks list


Discussion board


Picture library


Data sources


Site template gallery


User Information list


Web Part gallery


List template gallery


XML Form library


Master pages gallery


No-Code Workflows


Custom Workflow Process


Wiki Page library


Custom grid for a list


Data Connection library


Workflow History


Gantt Tasks list


Meeting Series list


Meeting Agenda list


Meeting Attendees list


Meeting Decisions list


Meeting Objectives list


Meeting text box


Meeting Things To Bring list


Meeting Workspace Pages list


Portal Sites list


Blog Posts list


Blog Comments list


Blog Categories list


Issue tracking


Administrator tasks list


Personal document library


Private document library