Speaking at SharePoint Saturday EMEA

2I would love to announce that I’ll be speaking at SharePoint Saturday EMEA on January 23rd, 2010. I’ll be co-presenting “Implementing Multi-Lingual Solutions on SharePoint 2010” with my colleague, friend and mentor Marwan Tarek. I’m really happy and proud to have my name along with those highly visible names in the SharePoint community.

I’m also happy to announce that there will be great Arabic SharePoint Experts speaking for the first time at SharePoint Saturday like Mohamed YehiaMostafa Arafa and Muhanad Omar.

For the list of speakers and sessions, click here.

If you haven’t registered yet, click here.


Associating Workflows to SharePoint 2010 External Lists

I’m a real fan of SharePoint 2010 composites, so since the beta version came out, I have been playing a lot with most of the features of BCS, SharePoint Designer 2010 Reusable workflows, Access Services and others.

While I was preparing a demo about BCS and External Lists for Egypt SharePoint User group, I noticed that you cannot associate workflows to SharePoint external lists. I double checked that with some Microsoft guys and I reached to a conclusion that SharePoint 2010 External lists doesn’t support the automatic triggering of Workflows however using custom actions ( which could by easily created now using SharePoint Designer 2010) can do the trick, in other words, clicking a button on the ribbon on an external list and triggering a workflow could be a workaround.

What if you in a real need to automatically trigger workflows for external data ? you can create a SharePoint list with external data columns and treat your list as any native SharePoint list. However, be informed that External data is a little bit different from external lists in the way it’s only copy of the external data but you can always refresh it manually.

I would also like to highlight another feature, you can now author SharePoint workflows that access external data through external lists or external data columns. Brilliant!

Four reasons TO directly query SharePoint logging database

Remember my post “Five reasons not to directly query SharePoint databases” ? I have cautioned you more than once throughout it NOT to directly query SharePoint databases and I have mentioned its disadvantages and problems. If you haven’t read this post, I would encourage you to do that before carrying on.

I’m not contradicting myself! The first post was all about SharePoint 2007 but now I’m talking about the new and the amazing 2010 version of SharePoint.

So you might be asking “What the hell is SharePoint Logging Database?”  Good question!

To answer you, please fire up the SQL Management Studio, and expand your databases. You’ll notice a new one named WSS_Logging.


SharePoint 2010 keeps tracks of everything it does by logging into the WSS_Logging Database. It  aggregates all of the raw logging data accumulated in the text files under the 14 hive and imports it into this wonderful logging database. This is the ONLY database in SharePoint that Microsoft will be happy to let the developers directly read, query and build reports against it. There is a bunch of useful views at your disposal, the one that I will show you now is  the “RequestUsage” View.

Every time a user visit generates a page request, a record is inserted into one of the partitioned tables in this database and the “RequestUsage” view is kind enough to union all the data in the partitioned tables and presents it to you to consume in your custom solutions (Web Parts, Reports, Application Pages,…). An example is shown below :



Let’s dive a little bit deeper to see what happens behind the scenes and where this data come from.

1)  Navigate SharePoint 2010 Central Administration > Monitoring > Configure usage and health data collection.






3) Did you notice the “Log Collection Schedule” section ? This implies that there is a timer job that collects  the log files located under the 14 hive and copies the events you specify into your logging database which can be employed later for reporting purposes. You can even schedule this timer job based on the load patterns of your server as you will see in the next step.

4) I have opened up my favorite troubleshooting tool ( SharePoint Manager) 2010) to track this job. As you can see in the figure below, I have configured the “Microsoft SharePoint Foundation Usage Data Import” job from the central administration to run every minute.


5) Out of curiosity, I have decided to use .NET Reflector to check out how this timer job works, I have noticed two things.


The first one is that the Job lock type specified in the constructor is SPJobLockType.None which instructs the Timer Service to run this job on all the Web Front Ends in the farm, this makes sense!

The difference between the Job and the None LockTypes is that the Job LockType ensures that the timer job only runs on one server but the None ensures that the job runs on every server.


Forcing the Execution of Timer Jobs in SharePoint 2010

Since you are here, You have probably read my Understanding SharePoint Journal bonus issue about SharePoint troubleshooting or my blog post “Forcing the execution of timer jobs” where I discussed debugging custom timer jobs.

That’s what I have written four or five months ago:

“You will probably need to execute your timer jobs outside of their scheduled times when you are developing, troubleshooting, or testing your custom timer jobs. Unhappily, this is not possible from Central Administration, but you can work around that using the SharePoint object model”

Of course this was all about SharePoint 2007 but NOW in SharePoint 2010, Microsoft has made it easier for us, you can directly force the execution of any timer job by just pressing a button! Awesome!



“People who suffered from this limitation in SharePoint 2007 will really appreciate this…

Data-Centric Composites (Mashups) in SharePoint 2010 [EGYSUG, Dec09 Meeting]



Last Saturday, I was happy to deliver another SharePoint 2010 talk for Egypt SharePoint User Group members. My session, titled “Data-Centric Composites (Mashups) in SharePoint 2010), focused on the following topics:

1) What is a composite ?
2) What is a mashup ?
3) Business Connectivity Services
4) XSLT Data Views, The ultimate mashup tool.
5) SharePoint Designer 2010.

We also had two other sessions by Mohamed Mosaad who gave a brief overview on the SharePoint topology and Mohamed Yehia who spoke about the new and the amazing “Access Services in SharePoint 2010”.





I loved how the audience was enthusiastic and interactive. I would like to thank them all for their amazing feedback and interactivity during the session, your feedback guys means  a lot to us.

Egypt SharePoint User Group – December 09 Gathering

6Egypt SharePoint User Group is glad to invite you to its December 2009 Gathering which will be held on Saturday, Dec 19th at Microsoft Egypt – Smart Village. This time, we have a valuable speaker that you shouldn’t miss, Mohamed Mosaad(SharePoint PFE, MEA). This is a great opportunity to benefit from his expertise in MOSS 2007 installations and implementations.

Please find below the event schedule




11:30am – 12:30 pm

MOSS 2007 Administration

Mohamed Mosaad

12:30pm- 12:45 pm


12:45am – 1:45 pm

Data-Centric Composites in SharePoint 2010

Ayman El-Hattab

1:45pm- 2:00 pm


2:00pm -3:00pm

Access Services in SharePoint 2010

Mohamed Yehia

Please Register here …

About the Speakers

Mohamed Mosaad is SharePoint Premier Field Engineer (PFE), Micorsoft MEA, with extensive experience in SharePoint administration and implmentations.

Mohamed Yehia has been diligently working in the development of enterprise solutions using Microsoft SharePoint technologies  including SharePoint Portal 2003, MOSS 2007 and currently 2010.  Mohamed is a Technical Architect and is Microsoft Certified Professional since 2001, MCSD, MCAD and MCTS Charter Member in SharePoint technologies.    He participated in a lot of Events for CuttingEdge Club and Egypt SharePoint User Group.  Twitter : @mohdyehia

Ayman El-Hattab: is a SharePoint Developer, Speaker and author. He is a Microsoft Certified Solution Developer as well as a Microsoft Certified Technology Specialist in SharePoint configuration and development. Ayman writes articles about topics in relation to SharePoint and related technologies for online magazines, publicly speaks for numerous user groups and offline communities, organizes events and conferences for EGYSUG, founder of SharePoint4Arabs.com and you will always find him active at MSDN forums and on Twitter @aymanelhattab

SharePoint 2010 TechDay!

Last Saturday, Egypt SharePoint User group and .NetWork user groups organized SharePoint 2010 TechDay, it was a full day of new SharePoint features, we started at 10:30 AM and we finished at 5:00 PM.



Marwan Tarek started with “SharePoint 2010, Getting Ready!” exploring the new and exciting features of SP2010



Mohamed Yehia followed him by “Developer tools for SharePoint 2010” in which he introduced Visual Studio 2010 SharePoint tools, LINQ for SharePoint and Client Object Model.



Finally, I presented “Developing No Code SharePoint 2010 Solutions”, I have created an end-to-end no code Training Request Solution in which I featured the following



1. SharePoint Designer 2010 enhancements.
2. SharePoint Designer Workflows
3. Visio 2010
4. InfoPath 2010 Integration with SharePoint 2010
5. Data View Web Parts & XSLT list View Web Parts
6. Using JQuery with SharePoint

I would like to seize this opportunity to extend a special thank-you to all our attendees, their interaction and questions really made my day!

I would also like to thank my colleagues Marwan Tarek and Mohamed Yehia for their wonderful sessions , Good job guys!

A feature that I really appreciate in InfoPath 2010 and SharePoint 2010

2Microsoft heard our feedback guys and took them very seriously regarding the portability of the solutions created in the development environments. You can now take all the lists, libraries, site assets, data and forms, package them up all into one file and easily deploy them onto different environments!

Now, the question is “What about InfoPath forms?”

In InfoPath 2010, all the links you have to external data are now relative, so when you move that form to different environments, those links will continue to work.. I really appreciate this!

Live Online SharePoint Saturday EMEA

1SharePoint Saturday EMEA is a loosely knit group of SharePoint evangelists from around the world. We are working together using SharePoint as a collaboration tool to sponsor live, online global events.

On January 23rd, 2010, we will hold our first online SharePoint Saturday event in the EMEA Timezones (8:00am to 5:00pm London time).

Registration is now open

Join Facebook group here.

I’m really proud to be one of the organizers and speakers in this event, stay tuned, we have a bunch of creative ideas that you will definitely like!