I’ve been bit by this a time or two… user changes their name in AD, but it doesn’t get updated automatically in Sharepoint via the Profile Import… there is a manual STSADM step needed, as taken from MSDN:

“When user account information is changed in Active Directory Domain Services (AD DS), the User name and Account name information is not synchronized correctly after you import a profile in SharePoint Server 2007″

stsadm.exe -o migrateuser -oldlogin <Domain name\Old user name> -newlogin <Domain name\New user name> -ignoresidhistory

Ref: http://support.microsoft.com/kb/953131

• Bookmark on Delicious
• Digg this post
• Recommend on Facebook
• Buzz it up
• Buzz it up
• Mixx it up
• share via Reddit
• Share with Stumblers
• Tweet about it
• Subscribe to the comments on this post
• Tell a friend
• Print for later

An article by Eric Shupps, Network World shed light on the 10 steps to improve the performance of our SharePoint servers.

1. Separate user and database traffic
   A common misconception is that servers connected to a high-speed network segment will have plenty of bandwidth to perform all required operations. But SharePoint places a tremendous amount of demand on SQL – each request for a page can result in numerous calls to the database, not to mention service jobs, search indexing and other operations. In order to mitigate the conflict between user and database traffic,connectivity between front-end servers and SQL should be isolated, either via separate physical networks or virtual LANs. Typically this requires at least two separate network interface cards in each front-end Web server with static routes configured to ensure traffic is routed to the correct interface. The same configuration may also be applied to application and index server.
2. Isolate search indexing
   A typical medium server farm consists of one or more Web front-end servers, a dedicated index or application server and a separate SQL database server. Search traffic initiated by the index server must be processed by the same servers responsible for delivering user content. In order to prevent search and user traffic from conflicting, an additional server may be added to the farm, which is dedicated solely to servicing search queries (in smaller environments, the index server may also serve this function). The farm administrator would then configure the search service to perform crawls only against this dedicated server. This configuration may reduce traffic to the Web front-end servers by as much as 70% during index operations.
3. Adjust SQL parameters
   One quick way to avoid future headaches is to provision the major SharePoint databases on separate physical disks (or LUNs if a storage-area network is involved). This means one set of disks for search databases, one for temporary databases and still another for content databases. Additional consideration should be given to isolating the log files (*.ldf). Although these do not incur the same level of I/O as other files, they do play a primary role in backup and recovery and they can grow to several times the size of the master database files.Another technique is to proactively manage the size and growth of individual databases. By default, SQL grows database files in small increments, either 1MB at a time or as a fixed percentage of database size (usually 10%). These settings can cause SQL to waste cycles constantly expanding databases, and prevents further data from being written while the databases are expanding. An alternative approach is to pre-size the databases up to the maximum recommended size (100G) if space is available and set auto growth to a fixed size (e.g. 10MB or 20MB).
4. De-fragment database indexes
   SQL Server maintains its own set of indexes for data stored in various databases in order to improve query efficiency and read operations. Just as with files stored on disk, these indexes can become fragmented. It is important to plan for regular maintenance operations, which includes index defragmentation. Special care should be taken to schedule these types of operations as they are resource-intensive and, in many cases, can prevent data from being written to or read from the indexes.
5. Distribute user data across multiple content databases
   Most SharePoint data is stored in lists: tasks, announcements, document libraries, issues, picture libraries, and so forth. A great deal of this data is actually stored in a single table in the content database associated with the site collection. Regardless of how many sites and subsites are created within the SharePoint hierarchy, each site collection has only one associated content database. This means that a site collection with thousands of subsites is storing the bulk of the user data from every list in every site in a single table in SQL. This can lead to delays as SQL must recursively execute queries over one potentially very large dataset. One way to reduce the workload is to manage the mapping of site collections to content databases. Administrators can use the central administration interface to pre-stage content databases to ensure that site collections are associated with a single database or grouped logically based on size or priority. By adjusting the ‘maximum number of sites’ setting or changing database status to “offline”, administrators can also control which content database is used when new site collections are created.
6. Minimize page size
   For SharePoint users connected to the portal via a LAN it is easy to manage content and find resources, but for users on the far end of a slower WAN link the heavyweight nature of a typical SharePoint page can be a real performance-killer. If you have many remote users, start with a minimal master page, which, as the name implies, removes unnecessary elements and allows designers to start with a clean slate that only contains the base functionality required for the page to render correctly. Second, most SharePoint pages contain links to supporting files, including JavaScript and style sheets, which require additional time to retrieve and execute. Designers can alter how SharePoint pages retrieve these files using a technique called “delayed loading”, which essentially loads the linked files in the background while the rest of the page is rendering.
7. Configure IIS compression
   SharePoint content consists of two primary sources — static files resident in the SharePoint root directories (C:\Program Files\Common Files\Microsoft Shared\12 for 2007 and \14 for 2010) and dynamic data stored in the content. At runtime, SharePoint merges the page contents from both sources then transmits them inside an HTTP response to the requesting user. Internet Information Server (IIS) versions 6 and 7 both contain various mechanisms for reducing the payload of HTTP responses prior to transmitting them across the network. Adjusting these settings can reduce the size of the data transmitted to the client, resulting in shorter load times and faster page rendering.
8. Take advantage of caching
   Much of the content requested by users can be cached in memory, including list items, documents, query results and Web parts. Site administrators can configure their own cache profiles to meet different user needs. Anonymous users, for example, can be assigned one set of cache policies while authenticated users are assigned another, allowing content editors to get a more recent view of content changes than general readers. Cache profiles can also be configured by page type, so publishing pages and layout pages behave differently, and administrators have the option to specify caching on the server, the client, or both. In addition, the SharePoint Object Cache can significantly improve the execution time for resource-intensive components, such as the Content Query Web Part. For example, large objects that are requested frequently, such as images and files, can also be cached on disk for each Web application to improve page delivery times.
9. Manage page customizations
   SharePoint Designer is a useful tool for administrators and power users but page customization can be harmful to overall performance. When customization occurs, the entire page content, including the markup and inline code, is stored in the database and must be retrieved each time the page is requested. This introduces relatively little additional overhead on a page-by-page basis, but in larger environments with hundreds or even thousands of pages, all that back-and-forth to the database can add up to significant performance degradation. To prevent this problem, administrators should implement a policy that restricts page customizations to only those situations where it is absolutely necessary. Site collection and farm administrators also have the option to disable the use of Designer or, when necessary, use the ‘reset to site definition’ option to undo changes and revert back to the original content.
10. Limit navigation depth
    One of the most significant design elements on any portal site is the global, drop-down, fly-out menu at the top of each page. It seems like a handy way to navigate through all the various sites and pages — until it becomes so deep and cluttered that all ability to navigate beyond the first few levels is lost completely. Even worse, fetching all the data to populate the navigation menus can be resource-intensive on sites with deep hierarchies. SharePoint designers have the ability to customize the depth and level of each navigation menu by modifying the parameters for the various navigation controls within the master page. Administrators should limit that depth to a manageable level that does not impact performance.

• Bookmark on Delicious
• Digg this post
• Recommend on Facebook
• Buzz it up
• Buzz it up
• Mixx it up
• share via Reddit
• Share with Stumblers
• Tweet about it
• Subscribe to the comments on this post
• Tell a friend
• Print for later

Gotta get em… especially when it’s hot and heavy in the planning phases!

http://www.johnchapman.name/visio-stencils-for-sharepoint-2010/

• Bookmark on Delicious
• Digg this post
• Recommend on Facebook
• Buzz it up
• Buzz it up
• Mixx it up
• share via Reddit
• Share with Stumblers
• Tweet about it
• Subscribe to the comments on this post
• Tell a friend
• Print for later

I take no credit for this, but props to Tom Wilson for pointing out this annoying little Sharepoint 2010 centering the page issue.

And I quote:

I was faced with the challenge of creating my first fixed width SharePoint site and the content had to be centered!

SharePoint 2010 implements a complicated system of divs, css and JavaScript to attain their static ribbon at the top of the screen but unfortunately this can get messy with different layout types.

In the master page remove the s4-workspace ID from the the div. This is the ID the java script looks for to resize the content.

Second, add the following to your branding css file or a style tag in the header after the core.css

/* Page Wrapper */

body{
overflow:auto;
}

form{
width:950px;
margin-left:auto;
margin-right:auto
}

That’s it!
The fixed width gets centered by the auto margins and the page properly shows the scroll bars because of the overflow:auto!

• Bookmark on Delicious
• Digg this post
• Recommend on Facebook
• Buzz it up
• Buzz it up
• Mixx it up
• share via Reddit
• Share with Stumblers
• Tweet about it
• Subscribe to the comments on this post
• Tell a friend
• Print for later

STSADM.exe -o enumsites -url htt:// YOURSITENAMEHERE > SiteList.txt

Outputs a nice summary of sites and their sizes… write a script that can enum sites and you can get alot of nice, quick, and easy info!

For more complex reporting though… obviously the API is the way to go, more on that at another time (I got a couple good ones).

• Bookmark on Delicious
• Digg this post
• Recommend on Facebook
• Buzz it up
• Buzz it up
• Mixx it up
• share via Reddit
• Share with Stumblers
• Tweet about it
• Subscribe to the comments on this post
• Tell a friend
• Print for later

OKEY!

First 64bit app over here… and lesson one, indicate it’s a x64 bit app in the Platform Target!  Duhhhaarrr!!!

But of course, for Sp 2010 Development… this is gonna be a handy reminder.  :)

• Bookmark on Delicious
• Digg this post
• Recommend on Facebook
• Buzz it up
• Buzz it up
• Mixx it up
• share via Reddit
• Share with Stumblers
• Tweet about it
• Subscribe to the comments on this post
• Tell a friend
• Print for later

The title basically gives you the combination to know that one of the VERY FIRST thing you should always be thinking about when implementation a new Sharepoint instance on Windows 2008 Server under a Kerberos environment.

unless you complete this step, you won’t be able to navigate to your base cname: http://yourserver (you will only be able to navigate to it via IP Address).  Therefore, don’t forget to enable Kerberos under the authentication area on Windows Server 2008:

• Bookmark on Delicious
• Digg this post
• Recommend on Facebook
• Buzz it up
• Buzz it up
• Mixx it up
• share via Reddit
• Share with Stumblers
• Tweet about it
• Subscribe to the comments on this post
• Tell a friend
• Print for later

• Bookmark on Delicious
• Digg this post
• Recommend on Facebook
• Buzz it up
• Buzz it up
• Mixx it up
• share via Reddit
• Share with Stumblers
• Tweet about it
• Subscribe to the comments on this post
• Tell a friend
• Print for later

• Bookmark on Delicious
• Digg this post
• Recommend on Facebook
• Buzz it up
• Buzz it up
• Mixx it up
• share via Reddit
• Share with Stumblers
• Tweet about it
• Subscribe to the comments on this post
• Tell a friend
• Print for later

Business Connectivity Services provides built-in functionality that enables you to rapidly build solutions that make use of external data by representing that data as an external content type and then using it within SharePoint as if it were a standard list. When you define a connection to external data by using the Business Connectivity Services wizard, the create, read, update, and delete commands can be created for you, thereby enabling a full read-write experience for users with minimal development effort.

When you define a connection to external data, you can use it with other functionality that is available in SharePoint 2010. You can, for example, integrate the external data into the business intelligence reports, or have it indexed and made available for search.

Another powerful capability is being able to use the external data that is managed by SharePoint in Microsoft Office client applications. For example, users can take the external content offline using the SharePoint Workspace application just as if it was any other SharePoint content, or they can export it to Microsoft Office Outlook.

You can build simple Business Connectivity Services solutions directly in SharePoint Designer, and you can make use of the built-in user experience and functionality. These solution types are typically suited to simple data models with a few external content types and simple associations.

You can also build advanced solutions by using Visual Studio 2010. Advanced solutions can provide custom user interfaces, and custom features and behaviors for interacting with the external data

Here is a pic gallery of some of the steps that take you from SQL datasource, to CRUD right within Sharepoint of that external data source:

• Bookmark on Delicious
• Digg this post
• Recommend on Facebook
• Buzz it up
• Buzz it up
• Mixx it up
• share via Reddit
• Share with Stumblers
• Tweet about it
• Subscribe to the comments on this post
• Tell a friend
• Print for later