In a previous post, I discussed how to use common table expressions to generate temporary result sets that can read from and written to. In this post, I’ll show how to use two CTEs together for more complex scenarios. To
Intro to Common Table Expressions
Common table expressions (CTEs) are a powerful feature that was added to Microsoft SQL Server 2005. Common table expressions can be thought of as a temporary result set that can be used with one single SELECT, INSERT, UPDATE, or DELETE
Semaphores in C#
A short while ago I had a need to limit simultaneous requests to a web service from a multi-threaded application to prevent timeouts. I learned about semaphores in school and knew this was the right approach, but I have never
Deploying a SharePoint Master Page in a Feature
A few weeks back I was tasked with deploying some content to a site collection including a new master page. The requirements stated that upon activation of the feature, the new master page would need to be deployed out to
Enable ASP.NET AJAX in Your SharePoint 2007 Farm
SharePoint 2007 does not enable ASP.NET AJAX by default. Although the process to enable ASP.NET AJAX on a SharePoint 2007 web application is rather straightforward, it can be time consuming and error prone due to the amount of web.config entries
Adding Configurable Properties to a SharePoint Web Part’s Tool Pane
In a previous post, we developed a simple web part to add two numbers together and display the result. It is a great introduction to web parts in the SharePoint world, but it is lacking any end user configuration. So,
How To Create a Basic SharePoint Web Part
A large part of SharePoint’s power comes from the fact that the interface is completely pluggable. Users can add web parts to pages of their choice in order to add functionality and features to a SharePoint site on demand. So,
Executing Code in Assemblies with SharePoint CustomActions
In my previous post, I discussed the basics of using a CustomAction to enhance the functionality of a content type. We used a CustomAction to redirect and pass some parameters to another page. This functionality is great, but what if
CustomAction Basics in SharePoint
CustomActions allow you to provide an easy way for an end user to perform some sort of action on or with a specific list item that is not available in a standard SharePoint installation. Let’s go through a simple demo
Feature Receiver Basics
As you begin developing more and more complex features to be deployed to SharePoint, you will most likely come across the need to perform some additional actions when your feature is installed and activated as well as extra clean-up when