SPQuery query = new SPQuery();
SPListItemCollection spListItems ;
string lastItemIdOnPage = null; // Page position.
int itemCount = 2000

while (itemCount == 2000)
{
    // Include only the fields you will use.
    query.ViewFields = "<FieldRef Name=\"ID\"/><FieldRef Name=\"ContentTypeId\"/>";
    query.RowLimit = 2000; // Only select the top 2000.
    // Include items in a subfolder (if necessary).
    query.ViewAttributes = "Scope=\"Recursive\"";
    StringBuilder sb = new StringBuilder();
    // To make the query order by ID and stop scanning the table, specify the OrderBy override attribute.
    sb.Append("<OrderBy Override=\"TRUE\"><FieldRef Name=\"ID\"/></OrderBy>");
    //.. Append more text as necessary ..
    query.Query = sb.ToString();
    // Get 2,000 more items.

    SPListItemCollectionPosition pos = new SPListItemCollectionPosition(lastItemIdOnPage);
    query.ListItemCollectionPosition = pos; //Page info.
    spListItems = spList.GetItems(query);
    lastItemIdOnPage = spListItems.ListItemCollectionPosition.PagingInfo;
    // Code to enumerate the spListItems.
    // If itemCount <2000, finish the enumeration.
    itemCount = spListItems.Count;

}

============================================================

Example 2:

SPWeb oWebsite = SPContext.Current.Web;
SPList oList = oWebsite.Lists["Announcements"];

SPQuery oQuery = new SPQuery();
oQuery.RowLimit = 10;
oQuery.Query = "<OrderBy Override=\"TRUE\">" +
    "<FieldRef Name=\"FileLeafRef\" /></OrderBy>";

int intIndex = 1;

do
{
    Response.Write("<BR>Page: " + intIndex + "<BR>");
    SPListItemCollection collListItems = oList.GetItems(oQuery);

    foreach (SPListItem oListItem in collListItems)
    {
        Response.Write(SPEncode.HtmlEncode(oListItem["Title"].ToString()) +
        "<BR>");
    }

    oQuery.ListItemCollectionPosition =
        collListItems.ListItemCollectionPosition;
    intIndex++;
} while (oQuery.ListItemCollectionPosition != null);

1:49 PM | Add a comment | Permalink | Blog it

November 05

SharePoint and QA

SharePoint 2007 Test Data Population Tool http://www.codeplex.com/sptdatapop

http://www.webperformanceinc.com/library/casestudies/sharepoint/SharePointLoadTesting.pdf

Testing types	Short description	Results
Requirements testing	A requirement testing is a method for detection of logical errors in project documentation at an early stage, before the actual development starts. The main purposes of the testing are: Standard: detection of mismatches in expectations and interpretations of the product requirements as well as cyclic Improvement of the requirements quality (correctness, completeness and adequacy, unambiguity, consistency) Specific for SharePoint: requirements analysis and review taking into account the peculiarities of the architecture, configuration and structure of SharePoint (for ex. the usage of standard SharePoint Search, validation, special symbols, etc.). As a result QA suggests some enhancements to increase the flexibility and configurability of the system.	Verification of requirements compliance with SharePoint restrictions and finding logical problems in product requirement at an early stage allows to: Get recommendations for improving flexibility and convenience of the system. Improve the quality of the future product. Lower the development and testing costs and reduce product time of delivery by minimizing expensive rework in case of requirements-related defects.
Functional and GUI testing	Functional and GUI testing of SharePoint based applications consists of the following main parts: Detection of functional and GUI defects (testing against business requirements, sketches, mock-ups and other project documentation) as well as finding configuration errors (for ex., unacceptable quality of the functionality can be forced not by problems in code but incorrect system configuration) Detailed GUI testing to ensure that the application looks professional, and is implemented in the uniform style. It is not so critical for standard SharePoint objects but very important for number of custom grids, forms (search, workflow), navigation trees, and different branding schemes. Administrative Guide testing. It is installation process testing in accordance with the Guide the system is deployed with. A QA engineer checks if there is enough information to configure the system properly and whether the system works correctly under default configuration. This testing type is very important in case the system is to be deployed in geographically-distributed organization because the Customer will need to install and reinstall the system several times.	Testing allows to: Identify the functional and GUI defects and improve product quality quickly and in time. Make appropriate enhancements and change requests to the default configuration and Administrative Guide. It helps to avoid blocking of the system if the deployment takes place on the customer’s side. Find workarounds for some configuration errors by QA engineers. If it is possible, QA Engineers are able to reduce delays in functional testing and reporting without waiting till a new version of a solution to be delivered.
Usability testing	Usability testing verifies that the application appeals to the target audience and meets the customer’s requirements alongside with the non-documented requirements and enhancements which are bound by usability rules and standards. It is a method of finding logical and structural errors. Usability testing has the following objectives: Determine if the project allows users to easily and efficiently accomplish their tasks Uncover user difficulties and frustrations associated with the site Collect significant usability findings (including positive and negative findings) with the purpose of improving usability of the product Performing this test is reasonable and necessary in case of testing deep customized applications based on SharePoint.	As a result, QA provides recommendation for improving the usability characteristics of the product to increase the usability level and ensure that the project meets end users expectations.
Integration testing	QA performs testing of integration between SharePoint and outer systems: Verification of integration with customer external systems, MS Office integrated systems (custom plug-in, add-in and etc.) and etc. Verification of the systems which are integrated to SharePoint as separate modules or web-parts (for example, Brava! Enterprise, payment systems).	The test results show if integration is able to provide smooth interaction of integrated systems taking into account various systems’ constraints and peculiarities.
Migration testing	There can be different goals of migration testing which depends on the migration type: Verifying that the projects migration is successful Checking the process of Projects migration testing from custom DMS to SharePoint products Testing of the developed Custom Migration Tools to ensure that it can support the migration process	Testing allows to: Identify defects found during migration process. As a result, it reduces the number of errors and mistakes during real migration. Increase the quality of the Custom Migration Tool (as a result of testing migration errors handling, GUI issues, etc.)
Security testing	During security testing of the QA: Checks different configurations of Standard SharePoint groups and their rights Tests functionality under custom groups and permissions Check internal (intranet) and external (external site) access points to SharePoint based application.	The customer gets information about the quality of a system in real life conditions when users with different rights interact with the system: Whether Security Policy is carried out (all users can go through their business process and limited users are restricted from doing some actions, etc.) If a system can be accessed from the outside (authentication, correct pages redirection, etc. testing) and external users can operate with functionality.
Code review	Testing of code against technical specifications/requirements.	QA validates that code is written in accordance with technical requirements (source code has uniform structure, necessary comments, etc.).
Automated testing	Automated testing includes the development of automated scripts mostly based on predefined functional test cases. Automated scripts are used for the following objectives: Frequent or time-consuming functional test case generation Hard-to-reproduce scenario generation Data generation Iterative mechanisms check Regressions detection.	Reduces manual testing efforts for re-testing stable functionality (regression testing) Allows more frequent build delivery and minimal QA of these builds Reduces efforts on multi-platform and multi-browsers testing Minimizes routine testing operations and replace them with automated test.
Performance testing	Performance tests determine end-to-end timing (benchmarking) of various time-critical business processes and transactions under low load but with a production-size database. Load tests are end-to-end performance tests under the anticipated production load, which determine response time for various time-critical transactions and business processes.	As a result, the Customer gets information how well the software performs under normal, unusual, and abnormal circumstances, establishing the maximum load, traffic, data, and other parameters the system can handle.

1:53 PM | Add a comment | Permalink | Blog it

October 30

Membership Providers, SSL

Identity and Access Strategies for SharePoint Products and Technologies (Part 1): Membership and Provider Architecture

http://msdn.microsoft.com/en-us/library/dd878353.aspx

Identity and Access Strategies for SharePoint Products and Technologies (Part 2): Membership and Role Provider Assignment

http://msdn.microsoft.com/en-us/library/dd897500.aspx

6:50 PM | Add a comment | Permalink | Blog it

October 28

Directions on Microsoft

All About Microsoft

http://blogs.zdnet.com/microsoft/

http://redmondmag.com

2:31 PM | Add a comment | Permalink | Blog it | Books

October 24

Smooth Jazz, Lounge

Brian Simpson (Waiting)

Peter White (Caravan Of Dreams)

Brian Culbertson - Together Tonight

Jazzmasters - Shine

Fridrik Karlsson - Rest your Mind

Joe McBride (Walking In Rhythm)

Paul Hardcastle (Lucky Star)

David Benoit

Oli Silk (Easy Does It)

Dj River - The Coloured Room Sessions

The Red Room (Autumn 2006)

The Blue Room (Spring 2006)

The Purple Room (Autumn 2005)

The Green Room (Summer 2005)

The Orange Room (Spring 2005)

1:17 AM | Add a comment | Permalink | Blog it | Музыка

October 23

SharePoint and IRM

Inside SharePoint Security and Compliance with AD RMS

http://technet.microsoft.com/en-us/magazine/2009.04.insidesharepoint.aspx?pr=blog

Microsoft Office Versions and AD RMS Features summary Default with SharePoint

AD RMS-enabled Applications	Microsoft Office 2003	Microsoft Office 2007	Microsoft Office Mobile
Microsoft Word	●	●	●
Microsoft Excel	●	●	●
Microsoft PowerPoint	●	●	●
Microsoft Outlook	●	●	●
Microsoft InfoPath	Not provided	●	Not provided

http://technet.microsoft.com/en-us/library/dd772697(WS.10).aspx

Enabling Microsoft SharePoint to search Oracle IRM sealed documents

http://blogs.oracle.com/irm/2009/08/enabling_sharepoint_to_search.html

Oracle IRM which both Office documents (even in Office 2000 which RMS doesn't) and PDF documents out of the box. Oracle IRM also can allow share point to search inside the protected documents.

12:25 PM | Add a comment | Permalink | Blog it | Tips and Tricks