This is a great article on how to implement table inheritance in SQL Server.

http://technet.microsoft.com/en-us/office/sharepointserver/cc948709.aspx

After migrating an ASP.NET 1.1 website to 2.0, I wanted to find out how much faster the new website runs. So I used VSTS (Test Edition) to record a few web tests with the intention of running those tests against the new and old websites to measure whether...

All this time, I've mistakenly thought that System.Web.Caching.Cache can only be used in web applications. It turns out that is not true. You can use the web cache in Console or WinForm applications. Here's some sample code showing how that's done. ...

I spent a couple of hours trying to figure out why I keep getting an exception with an error code of 0x80040E14 whenever I try to programmatically update a list item. Found this blog entry which describes exactly what I experienced. A quick fix for this...

Follow these simple steps to encrypt sections of your configuration files 1. Create a custom machine-level RSA key container by running aspnet_regiis.exe C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -pc “MyKeys” -exp ...

I was given a temporary development laptop with Vista installed. There are the usual development tools and SQL Server Developer Edition. When I tried logging onto the local SQL Server instance, I got accessed denied. I'm part of the local Administrators...

Ever got the following parser error on one of your page layouts? Only Content controls are allowed directly in a content page that contains Content controls. Following the error message, it shows the source containing some HTML fragment that you...

If your “content access” account doesn’t have permission to manage user profiles, then you may see event 7888 in your Application Event Log like this: Description: A runtime exception was detected. Details follow. Message: Access Denied! Only...

Have you seen an error with event ID 6875 in your Application Event Log? It looks like this: Event Type: Error Event Source: Windows SharePoint Services 3 Event Category: General Event ID: 6875 Description: Error loading and running event receiver...

I have two web sites on a MOSS farm. The first is reserved for authors and the second one is exposed to the internet allowing anonymous access. Recently, we receive intermitten 403 errors (Event ID 1314) when a user tries to access a certain page. This...

Before moving a content database from one farm to another, remember to prepare the database with the STSADM tool. Otherwise, you'll get a " Failure trying to synch web application" error. This blog describes this command in more details.

I'm not sure about other developers, but I hate working with HTML. Here's an example why… I have a few images that need to be arranged in a table to show a page header. This simply is just some IMG tags inside some other TD tags. But whenever the header...

Last week, I spent an all-nighter troubleshooting a Kerberos issue for a MOSS installation. Although it was very tiring spending an entire day and night fixing this problem, I actually thought it was fun. I learned a lot about configuring AD for delegation...

Ever got repeated “Attempted to read or write protected memory” messages on your MOSS servers? If you do, then the event ID’s are probably 7076, 6398 and 6432. It seems these errors are related to a bug in the Internet Information Services (IIS) Active...

Does your MOSS installation generate the following error? The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {61738644-F196-11D0-9953-00C04FD919C1} to the user domainxyz\user123...

I tried to create a web application today but got a vague unknown error message from SharePoint. I looked in the Event Viewer and found this error message: Unknown SQL Exception 10054 occured. Additional error information from SQL Server is included...

Today, I tried to open a SharePoint document library in Explorer View but nothing come up but an error from IE. After searching for a while, I stumbled onto the "Understanding and Troubleshooting the SharePoint Explorer View" white paper. Pretty interesting...

This page contains a convenient list of SharePoint content type IDs.

My client had two lists. First list (appropriately named “Lookup List”) contains a list of application names, stored in the “Application Name” column. The other list (Example List) contains a lookup column (Application Name, again) that points back to...

If you've searched the web for articles on how to create custom web parts, then you will see some articles that describe how to do it in SharePoint 2003 and some will describe techniques in 2007. Make sure you are reading the article for the right version...

I write a lot of custom code for MOSS. There are times when I need to save configuration settings for some of the components I write. Saving them in the <AppSettings> section of web.config is the easiest way, but hard to maintain. What I'd rather...

A few good blog entries that talk about SharePoint web parts and AJAX: http://sharethispoint.com/archive/2007/02/28/Using-a-SPGridView-inside-an-ASP.net-Ajax-UpdatePanel.aspx http://www.capdes.com/2007/02/ajaxbasepart_easy_aspnet_20_aj.html ...

On a recent MCMS to MOSS conversion project, I had to convert some existing templates to page layouts. There were a couple of templates which were using AJAX. Each template has its own instance of the ScriptManager because each has a different ServiceReference...

Two great blog entries describing MOSS Content Deployment and how to configure it: http://blogs.msdn.com/sharepoint/archive/2006/05/02/588140.aspx http://blogs.msdn.com/jackiebo/archive/2007/02/26/content-deployment-step-by-step-tutorial.aspx