SQL Intellisense not updating - SQL Server 2008

I created a new table in SQL Server 2008, then when SELECTing from it I got the red squiggly line.

Closed the query window, still no luck.

Found a post that suggested CTRL+Shift+R which worked!.

More info here.

LDAP tutorial

I was reading the MOSS install on this link, and one of the first things it says is 'Start by creating the following users in an OU in AD '.... Whats an OU? - it took a couple of minutes but I found a couple of links.

• Introduction to LDAP
• LDAP URL Query FAQs

OU is an organisational unit.

Exam 70-542: TS: Microsoft Office SharePoint Server 2007 – Application Development

Today I passed, Exam 70-542: TS: Microsoft Office SharePoint Server 2007 – Application Development, with 1000 points which I was quite pleased about!

SharePoint on .NET Rocks

SharePoint on .NET Rocks Tv.

Part 4 covers the BDC with the same content as in this post

1. SharePoint 2007: Part 1
2. SharePoint 2007: Part 2
3. SharePoint 2007: Part 3
4. SharePoint 2007: Part 4

SharePoint 2007 - The Business Data Catalog

A good link giving a series of articles on the Business Data Catalog from Sahil Malik.

• BDC - The Business Data Catalog
  

Records Management and Creating a custom Information Management Policy

A good series of posts from Zlatan Dzinic on Records Management.

1. Doing Records Management in SharePoint 2007 Part 1 (Intro)
2. Doing Records Management in SharePoint 2007 Part 2 (Creating a Records Repository and Configuring the Retention Schedules)
3. Doing Records Management in SharePoint 2007 Part 3 (Sending Content from SharePoint Server 2007 to the Records Repository site)
   

A good series of posts from Ton Stegeman on creating a custom information management policy.

1. Introduction and creating the policy feature
   
2. Implementing the handler and submitting to a records centre
3. Implementing and testing the policy

Exam 70-541: TS: Microsoft Windows SharePoint Services 3.0 – Application Development

Today I passed, Exam 70-541: TS: Microsoft Windows SharePoint Services 3.0 – Application Development.

Well done me!

101 LINQ Samples from MSDN

101 Linq Samples from MSDN.

Create a WSS Site Collection.

It is very simple to create a WSS Site Collection!

• Startup SharePoint 3.0 Central Administration
• Select Application Management tab
• Click 'Create Site Collection' under SharePoint site management heading
• Enter details and Click Ok.

The book - Inside Microsoft Windows SharePoint Services 3.0

I've just finished reading this book Inside Microsoft Windows SharePoint Services 3.0, it was straight forward to read beginning to end, containing a lot of useful information for the WSS developer. It has lots of good code samples, available here.

Here follows my scribbled notes from the first chapter.

• WSS is a site provisioning engine.
• WSS is part of Windows Server 2003.
• MOSS - value adds a set of components and services that have been built on top of this platform
• A WSS site is a storage container for container, eg lists, libraries and child sites.
• A WSS site is a securable entity.
• WSS doesnt do authentication, it does authorisation.
• A WSS site is an application with an extensible fully customisable user interface.
• A WSS site is an application with an extensible, fully customisable user interface.
• A WSS site is a foundation for using web parts.
• A WSS site must be created within the scope of an existing Web Application, not as an independent entity; it must be created within a site collection.
• A site collection is a container of WSS sites.
• Each site collection requires a top level site, it can contain a hierarchy of child sites.
• A Web Application, contains site collections, contains sites, contains lists,libraries,child sites.

How should you as a developer partition sites across site collections?

To answer this you need to gain an understanding of how partitioning sites affects the scope of admin priviledges, security boundaries, backup and restore and site design.

• The concept of the site collection is important because it allows an IT dept to hand off the admin burden to the business divisions that own the sites.
• A site collection is an 'island' ie they provide scope of membership and security authorisation.
  
• A site collection provides a convenient scope for backup and restore.
• WSS object model allows for queries that span lists within a site collection but not across site collections.
  

The WSS developer platform provides a comprehensive framework for scalable portable applications it includes;

• the object model
• web part framework
• web services
• site provisioning model

It is important to differentiate between customisation and development.

A user can customise lists, libraries, the appearance of pages using web parts, master pages and css using SharePoint designer. Customisation is saved within the content database. This is an advantage as it provides great flexibility to users and site admins. But a disadvantage for development as they are now hard to version and make repeatable across multiple sites.

How can you move a customisation from dev > staging > production. How do you customise a single site and then reuse it across multiple sites. The answer is its difficult! If this is what you need to do you should be looking at development.

• WSS 3.0 has site columns
• WSS 3.0 has content types
• WSS 3.0 can work with Office Open XML file formats.
• WSS 3.0 is built on top of Windows Workflow Foundation
• Security and site membership within WSS 3.0 can be extended.

If you dont use Active Directory, you can build or acquire ASP.NET authentication provider.

Features, Features, Features! - they feature a lot in the book.

Features are a new developer focused innovation that has been added to WSS 3.0 They provide a mechanism for defining site elements and adding them to a target site or collection.

Several object types in WSS object model such as SPSite and SPWeb use unmanaged resources and must be disposed of in a timely manner.