SharePoint

SharePoint and Database Maintenance

In this post I would like to point to “an issue” with the Database Maintenance for Microsoft® SharePoint® Products and Technologies. It shows a stored procedure, which will defragment the index of a database. How to defragment Windows SharePoint Services 3.0 databases and SharePoint Server 2007 databases The problem is that it is mentioned nowhere, that the stored procedure requires the Enterprise version of the SQL Server 2005!

Issues in WSS V2

Responses to items in an Issue list (SPListIssue) are new version in WSS V3. WSS V2 lacks the ability to use versions for lists. So what did Microsoft do that an Issue list behaves like it is using versions? In WSS V2 items in a single “thread” all have different ItemIDs. To group them together, all have the same IssueID. This is the ItemID from the original item. A single issue in WSS V2 could look like this:

Apply a LDAP Filter for User Profile Import

With MOSS (Microsoft Office SharePoint Server 2007) you can import user profiles from an Active Directory or LDAP. By default, it will import user profiles from the current domain. The import will include all user objects, since the default LDAP filter is: (&(objectCategory=Person)(objectClass=User)) Deactivated and deleted accounts will appear in the SharePoint user database. The filter value can be adjusted, to only import active user objects. (&(objectCategory=person)(objectClass=user)(!(userAccountControl:1.2.840.113556.1.4.803:=2))(!(IsDeleted=TRUE))) With a LDAP browser, you can compare the results of the two filters if you don’t trust the query 🙂

New Server in the farm – Trial?

Imagine you have a working SharePoint Server Farm with a valid license. The great thing about SharePoint is that you can extend an existing farm with new servers, to split roles or increase performance/redundancy. Now you add a new Server to the farm. So you install SharePoint, make sure it has the same patches installed as the rest of the farm, and add it to the farm by connecting it to the existing configuration database.

SharePoint UserGroup in OWL?

Vor einiger Zeit hat Michael Greth einen Aufruf gestartet. Wer Interesse an einer regionalen UserGroup hat, sollte sich bei ihm melden. Bisher sind schon einige regionale UserGroups gegründet worden. Eine Übersicht findet sich auf der SharePointCommunity. Auf den o.g. Aufruf habe ich damals schon geantwortet. Jedoch hatten sich zu wenig Interessenten aus OWL (Raum Bielefeld, Paderborn, Gütersloh…) gemeldet. Zum Glück gab es die Abendveranstaltung der SharePointKonferenz 2009 in München. Dort habe ich mich u.

Custom Field – Upload Files and Images

If you know my WikiWebpart or DiscussionListUploader, you know that there are some occasions where you want to upload a file, and place a link to it to another field. The above solutions are only for the certain list type. My new custom field can be used on every list or library! Just add the field to one of your lists/libraries: It will automatically try to find local libraries for documents and images to store the uploaded files and images.

How to use the SharePoint Web Controls – Update

My post How to use the SharePoint Web Controls has been updated. It now shows how to use a generic control for each SPField, instead of picking the corresponding SharePoint Web Control. 1: BaseFieldControl webControl = field.FieldRenderingControl; <span class=lnum> 2: </span>webControl.ListId = list.ID; 3: webControl.ItemId = item.ID; <span class=lnum> 4: </span>webControl.FieldName = field.Title; 5: webControl.ID = GetControlID(field); <span class=lnum> 6: </span>webControl.ControlMode = mode; Thanks for all the great comments and ideas!

The file manifest.xml does not exist in the solution package

Creating a SharePoint solution file (which is a cab file renamed to wsp), can cause problems if the size of the file would exceed the space on an 1.44MB disk. 1.44MB? What the…? The default values for makecab, which is used for generating the cab file, will prevent the creation of a valid cab file 🙁 Thanks to Eugene Rosenfeld for finding this one.

SharePoint Konferenz

Dieser Post ist noch ein Nachtrag zur SharePoint Konferenz in München. Mein Fazit zur Veranstaltung: Eine Gelungene Veranstaltung mit hochkarätigen Vorträgen! Deshalb geht mein Dank an den Veranstalter mit seinem Team, die verschiedenen Sprecher und natürlich an die Teilnehmer der Konferenz. Ein Gedankenaustausch durch zahlreiche Gespräche zwischen den Beteiligten war jederzeit möglich. Allein diese Tatsache ist auf Konferenzen ein Grund zur Teilnahme. Wo sonst kann man sich mir so vielen Personen zum Thema SharePoint austauschen?

CKS:EBE

Finally I found the time to enable the Enhanced Blog Edition on my blog. As you can see, the layout did change 🙂 The EBE also brings some new functionality like comment spam detection, trackbacks and a cleaner RSS feed. So if you are using the old URL for my RSS feed, please update it to http://feeds2.feedburner.com/ReneHezser The new feed URL may result in duplicate RSS items. The EBE is not a final version.

Next SharePoint

Here is some information about the next release of SharePoint. FAST Search for SharePoint, a new search server that will add the high-end search capabilities of FAST ESP into Microsoft Office SharePoint Portal Server, will be available as a part of the next release of the Microsoft Office system. Source: http://blogs.msdn.com/sharepoint/archive/2009/02/10/microsoft-unveils-new-enterprise-search-road-map.aspx As part of this vision, and feedback from a wide variety of customers, PerformancePoint scorecarding and dashboarding capabilities will now become part of SharePoint Enterprise CAL and available to customers who are on SharePoint SA.

SharePoint Konferenz Vortrag

Nach meiner Session auf der SharePoint Konferenz veröffentliche ich wie versprochen meinen Vortrag von inklusive dem Sourcecode. In der Solutions ist auch Code für einen Feature Receiver enthalten. Folien Sourcecode Update Die restlichen Vorträge sind inzwischen zum Download auf einer Seite gesammelt worden: http://live.sharepointcommunity.de/wiki/SKPPEDV2009/Forms/Downloads.aspxTechnorati Tags: SharePoint,SharePoint Konferenz

Versioning files in a document library

If you open a file from a document library, modify it and save it, you will get a new version. This is what I had expected. But if you open up a document do some changes, save it, change some more and save it, you will only get one new version. Not as many as I had expected because I have saved the document like 10 times. Interesting…Technorati Tags: SharePoint,Document Library,Versioning

SharePoint Dispose Checker Tool

As I posted earlier, MS was working on a tool which will analyze your code if you are coding against SharePoint. Here is a short description: It provides assistance in correctly disposing of certain SharePoint objects to help you follow published best practice. This tool may not show all memory leaks in your code. Further investigation is advised if you continue to experience issues. SPDisposeCheck.exe takes the path to a managed .