SharePoint Blogs

A cool example of Silverlight and AJAX in SharePoint 2010.  Go to All site content –> Create to see such a nice dialog to create a list

Clicking on More Options shows you the old UI :)

Really nice :)

List Threshold and throttling is a new feature in SharePoint 2010 lists.  This allow SharePoint administrator to block running heavy queries on SharePoint Lists which has thousands of items.  In SharePoint 2007 the max items that can be returned by a list view was about 2000 items and any query over that number can result in low performance and load on the server.  SharePoint 2010 lists has been optimized to support millions of items all together but provide SharePoint Administrators control over how many items are being retrieved from the lists at a time using User Interface or Object Model.

See the example below as we have a list with 6000 thousand items.  The default threshold limit is 5000 which can be changed in the Web Application Settings.

To set the resource throttling we need to go to Central Administration –> Application Management –> Manage Web application

click on the web application –> Click on the Ribbon and click the General settings Dropdown –> Select Resource Throttlling

There are different threshold values that we can specify List View Threshold  - Minimum Items before Thread hold – Default is 5000 Object Model Override – Do you want to allow object model code to override the threshold and run an expensive query.  Default is Yes List View Threshold for Auditors and Administrators – Maximum number of items in a view for a user who has sufficient permissions – Default is 20000 List View Lookup Threshold  -  The max number of columns that can be returned by a object model SPQuery.  Default is 6 Move-over you can also specify the time when you want to allow these expensive queries to run.

Now when a list has items mover than the threshold.  The settings page will show that the list has reached its threshold.

Go got List Settings using the ribbon.

Gulf Developer Conference will held on 13, 14 and 15th of December in Riyadh and I will be there.  But a question is “What I will be doing there?”.  The anwer to this question is pretty simple.

• I will be Leading the Microsoft Technical Community Lounge
• According to Microsoft “This event will be driven by the community” so we will doing many small presentation, events, chit chats, technical discussion and signups for our communities.  I will be leading the place as RSUG Lead with Muhammad Halabi Taking DLS Lead.
• I will be available on SharePoint Technology Booth at the event for all 3 days to answer the toughest questions of the audience after the event.
• I will be doing 3 Chalk Talk Session + many on spot SharePoint 2010 Demos :)
• Building Dashboards with SharePoint… the good, the bad, the ugly
• SharePoint 2010… what every developers needs to know!
• Happy with SharePoint 2007?... things you need to know about SharePoint 2010!
• I will be speaking in 2 Break out session.
• Microsoft SharePoint Server 2010: What's in it for Developers
• Visual Studio Tools for SharePoint 2010

There will be many raffle draws for different gifts during the event so please make sure you visit the community booth for get them.  Also take part in the chalk talk session to get the interesting learning experience.

By the way.  GDC is free you can register and join us for the event without paying a single penny. 

http://www.marcomarabia.net/ceventregister.asp?Evid=192

Looking forward to see you there.

Jerry

SharePoint 2010 Lists support Field Validation which enables you to validate the values.  Field Validation allow you to “specify the formula that you want to use to validate the data in this column when new items are saved to this list. The formula must evaluate to TRUE for validation to pass. “

Example: If your column is called "Company Name" a valid formula would be [Company Name]="My Company".

To Test out the Validation go to the List and Select List from List Tools

Click Create Column

The Enter Title of the Column and select type the type.  for this example I have a column name Employee Age which should be a number greater than 25

Expand the validation section and Write your formula and message.  You should enter the try condition and message for wrong values.

Now Create or edit the existing item to test your formula

List item Validation Works same but we can write a formula to verify the item.  We can specify the formula you want to use to validate the data in this column when new items are saved to this list. To pass validation, the formula must evaluate to TRUE. For more information, see Formulas in Help. Example: =[Discount]<[Cost] will only pass validation if column Discount is less than column Cost.

For this example I created two currency columns GrossSalary and Netsalary and my formula is that Net salary should be less than Gross Salary.

I entered 20000 as Gross and 30,000 in Net Salary so the error message is visible in the status pane.  The different between column or field validation and Item validation is that the wrong value message in field will be visible in front of columns.

Very impressive :)

The following products are available for download.

Microsoft Visio Premium

Microsoft Office 2010

Microsoft Exchange 2010

SharePoint Server 2010

Project 2010

Project Server 2010

Office Web Applications 2010

Microsoft FAST Search Beta

SharePoint Designer 2010

The link to download them is given below 

Download: http://www.microsoft.com/2010/en/

The announcement: http://www.microsoft.com/presspass/features/2009/nov09/11-18PDCKurtDelBene.mspx
The announcement: http://www.microsoft.com/presspass/presskits/2010office

Last night I installed the beta bits on my Windows 7 64bit.  SharePoint 2010 is working nicely.  Although I faced many problem but thanks to Microsoft bloggers for providing instant help on these problems.

Update

GDC is Free.  Please note that There is no fee to attend GDC. All you have to do is to register before 10th of December.  The link is given below.

http://www.marcomarabia.net/ceventregister.asp?Evid=192

Register Now !.  I will be there so make sure you pass by.

Jerry

Hi All,

It is now official that I will be speaking at Gulf Developers Conference 2009.  You can see more details below.  I will be announcing some very good for the community.   Much more than what we have announced during Riyadh Community Summit.  So Stay Tuned.  I will be presenting 3 Breakout + 5 Chalk talk Sessions while leading the community lounge.

If you wanted to see Riyadh Community Summit Highlights check the YouTube link below.

mstechcommunites

Jerry

What is GDC '09?

Gulf Developers Conference 2009 (GDC '09) - the largest Microsoft developer event in the Gulf region. This is a 3-days conference that is expected to attract more than 2,500 attendees from Saudi Arabia and near-by Gulf countries starting from December 13 to December 15, 2009. The conference will be held at Al-Yamamah University on the same premise of the new Microsoft Innovation Center in Riyadh, Saudi Arabia.
With the intense anticipation for Win7, Office 2010 & VS2010, the event is expected to attract the attention of many developers in the region. The GDC'09 event will be geared towards generating developers' excitement by providing early developer access to key platform technologies that have not been released yet (e.g. VS2010, Office/MOSS 2010) or that have recently been released (e.g. Expression3,SL3, Win7). Moreover, GDC'09 will offer a unique experience for IT and developer managers to learn about new technology directions from Microsoft and how such technologies can be used to maximime value for their businesses.

Why Attend GDC '09?
The GDC '09 event will be a great opportunity you can't afford to miss!
This event features large number sessions that will be delivered by international and local experts from Microsoft and its partners, to ensure that the conference includes a wide range of topics to reflect on the diversity of today's software business. During this event, broad range of sessions covering all the following tracks would be delivered:

1. User Experience Track: includes latest updates on Windows 7, Expression 3, Silverlight 3, and Windows Presentation Foundation)
2. Developer Track: Includes latest updates on .NET 4.0, Visual Studio 2010, and Application Lifecycle Management tools
3. Web Development Track: including latest updates on web technologies and MOSS 2010
4. Dynamics: Including latest updates on Ax, CRM
5. Application Platform Track: Includes latest updates on Windows 2008, SQL Server 2008, and BizTalk 2009
6. Mobility Track: Includes latest update on mobile 6.5 development
7. IT & Dev Managers Track: providing latest technology directions and updates on how to best maximize business value and return on investments from use of different IT technologies.

Who should attend?
• IT Professionals
• Developers/Programmers
• Web Application Developers
• Software Design Engineers
• Software Architects
• Technical Leads
• IT Managers
• Developer Managers
• Software Test Engineers
• Infrastructure Engineers
• Web Masters

GDC is an important event for IT managers and IT professionals, not just developers. Whether you are involved in architecture, deployment, operations, strategic vision or systems engineering, GDC is the leading technical event to be held in Saudi Arabia and near-by countries this year.

Fees and Location:
Location
Kingdom Of Saudi Arabia - Riyadh
Al-Yamamah University (link to map & directions on same page or separate page)
King Fahad Road between exit 4 and 5 heading north

Fees
Discounted Fees: SAR 275
(in case registered on or before 15th of November)
Fees: SAR 375
(in case registered after 15th of November)
Academic Fees: FREE
(Universities & collages students & Instructors)
Note: University or Collage ID should be present to qualify for free admittance at the entrance.

Now we have a cool منتديات for Social Networking for Arabic speaking people where they can make friends, share pictures, ideas, documents, videos.  Although the other Web 2.0 sites like facebook and twitter are there but this site is 100% Arabic content site.   Please visit and do write your feedback here in the comments.

Thanks to Abdurrahman Al Qahatani for sending me this list. 

My Opening Notes at Riyadh Community Summit.

A Short interview with Ammar about History, Evolution and Future of Microsoft Communities in Saudi Arabia.