SharePoint Saturday EMEA session schedule !

This is just a quick note to let you know that the session schedule, presenters and session listings are now available for download:
http://www.endusersharepoint.com/WorkshopDownloads/SPSEMEA-FinalSchedule.xls

I’ll be speaking at 11:00 AM Cairo Time, waiting for you all!

Advertisements

For the first time : Arabic session at SharePoint Saturday!!

Throughout my blog, twitter account and Facebook, I had wonderful opportunities to get connected to a lot of nice guys in the middle east and especially in the Arabia and one thing noticed in common is the thirst for SharePoint knowledge. Moreover, I have been lately receiving many requests for more Arabic Content at SharePoint4arabs.com so cheer up guys, I have good news for you!

As you might know, I’ll be speaking at SharePoint Saturday EMEA on January 23rd. The good news is that for the first time ever, there will be a session delivered in Arabic. I’m really glad to be the speaker and hope to see you all there. (Please spread the word)

Here is a brief description of my session.

3

 

For the list of speakers and sessions, click here.

If you haven’t registered yet, click here.

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.

1

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 :

2

 

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

4

 

5

 

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.

8

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

9

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.

10

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!

1

 

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

Quick-Hit Technology Thoughts from a Territory Manager @ Nintex, Microsoft Regional Director and 6x Microsoft MVP