This is my third article about using the preconfigured 2010 Information Worker Demonstration and Evaluation Virtual Machine (SP1).
I think I've found the final solution, or better, I've found a sequence of exceptional blog postings describing how to use it with Oracle VM VirtualBox in very deep detail:
SharePoint, in both 2007 and 2010 releases, doesn't implement field level security.
For sure hiding fields at the presentation level is not the correct solution: the want-to-be-hidden data is still available to the unwanted users through internal SharePoint pages, web-service call and all the cllient object model APIs, search, and so on.
Doing some researches on this topic I've found a very clever implementation in the following article: Column Level Security in SharePoint. This implementation is very clever, uses lookup fields to a protected tables and methods to retrieve data to authorized users only. The nice thing is that the final result is very nice, and it fit perfectly in the native SharePoint user interface (but of course above all it's really safe).
You can also download the sources from codeplex in the following address: SharePoint - Secure Field.
Hiren's BootCD is a particular installation of Windows XP that contains a lot of utilities to recover damanged computers. You can download it directly from the file Hirens.BootCD.15.1.zip.
To run it from an USB disk, you need the utilities USBFormat and Grub4Dos, after that you can simply follow the simple guide in the page Hiren's BootCD From USB Flash Drive (USB Pen Drive). In the last step, remember to copy the content of the iso file contained in the Hiren's BootCD zip file.
You can implement pagination in SPQuery using the two following properties:
- RowLimit: to define page size;
- ListItemCollectionPosition: to define the current position:
- for the first page, don't give this value;
- for other pages, use the value returned by the GetItems method (it will be null for the last page);
- othersise, for more advanced scenarios, give a value to the PagingInfo string property.
The SharePoint content database schema can be found the in page Database Tables.
Other tables can be found in the reference page 2.2.7 Tables and Views.
Common queries can be found in the blog post SQL Queries for SharePoint Content Database.
Finally, an explanation of direct query access can be found in the APress book SharePoint 2010 as a Development Platform at page 280.