Query execution time in miliseconds in SQL Server Management Studio

If you need to get query execution time in milliseconds in SQL Server Management Studio, there is a simple way to achieve this.

Getting field value for specific item version

In this blog entry I will share some findings regarding SharePoint API for items versioning in document library.

Extraction of term custom properties from list item field of managed metadata type

The task was to extract custom properties from managed metadata field of list item. Custom properties can be stored in name value like collection for each term, which is very handy in many cases.

Locating list item in document library by url

If you need to find list item by url, there is easy way. You can create site based on file url. Than it is enough to run GetFile which will return SPFile object. Last thing is to get Item object from returned file object. No need to write CALM queries.

Detection of field value changes in document library

There is pretty easy way to detect change of field value in document library. You can use EventReceiver attached to your content type. ItemUpdating is a good place detects changes and performs validation if required. In my case it was required to detect that value of field has changed and additionally to synchronize value of two fields and perform some additional validation of entered values.

Document Library and custom rendering templates

Goal was to create document library with requirement to hide fields which have 'Hidden' string in name (unfortunately I could not use ShowIn.. settings due to specific requirement from external tools integrated with SharePoint instance). My first idea was to use custom FormTemplates with custom ListFieldIterator.

Quickly, it turns out that there is a problem with registering FormTemplates for content types based on document library. SharePoint 2010 was ignoring them. The only solution I was able to find, was to disable content type inheritance. That allowed me to register my own FormTemplates.

Returning rows in random order from MS SQL Server

Have you ever needed to return rows from MS SQL Server in random order every time you execute query? Here is simple solution to achieve this.

select top 10 * from some_table order by newid();