Tag Archives: resource

The Seattle Foundation

The Seattle Foundation is making the greater Seattle community a vital and healthy place to live, driving positive change on a range of local issues by working side by side with donors. Founded in 1946, The Seattle Foundation is your local, definitive resource for giving. We provide the reliable insight and tools you need to [...]
Read More

Take advantage of SharePoint Server 2010 search capabilities from SharePoint Server 2007 by doing a search-first migration

Upgrading to Microsoft SharePoint Server 2010 from SharePoint Server 2007 provides significant enhancements in enterprise search capability. This includes many improvements for end users when they issue search queries and view search results. You can find a summary of these enhancements in  What’s new in enterprise search (SharePoint Server 2010).

However, due to policy or resource constraints, organizations sometimes aren’t in a position to complete an upgrade all at once. If this sounds like your organization, you can still set your end users up to take advantage of search capabilities of Microsoft SharePoint Server 2010 from your existing SharePoint Server 2007 deployment by performing a search-first migration.  

To perform such a migration, you deploy a new SharePoint Server 2010 farm and configure it for search. You reproduce the existing SharePoint Server 2007 farm search settings in the new farm, and then configure the SharePoint Server 2007 farm to forward search queries to the new farm. For this migration you don’t migrate content databases to the new SharePoint Server 2010 farm, for example, or configure any functionality in the new farm that isn’t related to search.

After the search-first migration, your users can take advantage of SharePoint Server 2010 query features and search-results features right from your SharePoint Server 2007 farm! These new query features include prefix matching, Boolean query syntax, phonetic name matching, and query suggestions. Search-results features include results refinement, social tags integration, and relevance improvements. And your users continue to use the existing SharePoint Server 2007 deployment for SharePoint functionality other than search.

Your organization can complete the remainder of the product upgrade at any time that is convenient, but the enhancements that your users gain in search capability will probably give your business decision makers an incentive to fully adopt SharePoint Server 2010 as soon as possible!

You can find a full description of the search-first migration process in this series of articles on TechNet. Read the articles, try out the process, and let us know how it goes!

Read More

Just Released – Best Practices Resource Center for SharePoint Server 2010

Hi – the Best Practices articles and the Best Practices Resource Center for 2007 were some of our most popular content for that release. We’re pleased to announce that we now have a 2010 version of the Best Practices Resource Center. Like in 2007, this was a joint effort between the SharePoint Customer Engineering team and Microsoft Consulting Services team for SharePoint. They drew on real customer experiences to help us bring you a set of guidelines that lay out the best practices for success with SharePoint Server 2010. Following these practices will help you avoid some of the common deployment pitfalls and keep your SharePoint environments available and performing well. Get the details now from the Best Practices Resource Center.

More best practices articles are in the works and will appear in the coming weeks and months on the Resource Center and in the Best Practices section of the Technical Library, so keep checking back for more info.

– Samantha Robertson

Read More

Upgrading SharePoint SQL Servers to SQL Server 2008.

SQL Server 2008 is now released and is supported by WSS 3.0 and MOSS 2007 SP1 and above although we probably won’t see a supportability statement anytime soon due to resource constraints with the content folks. I will let you know when the official supportability statement is released.
[Update] – Support has been annouced. See http://technet.microsoft.com/en-us/library/cc262485.aspx for MOSS and http://technet.microsoft.com/en-us/library/cc288751.aspx for WSS. (look towards the bottom)
Upgrade from 2005 to 2008 is a pretty simple process. Here are some things to be aware of when using Upgrade Advisor. If you run upgrade advisor (recommended for SQL servers not dedicated to SharePoint 2007) you will see the following warnings in the report. These warnings can safely be ignored:
· Full-Text Search has changed in SQL Server 2008 – SharePoint 2007 no longer uses Full Text Search and will not be affected by these changes.
· Column aliases in ORDER BY clause cannot be prefixed by table alias – This is flagged on each instance of the proc_GetTpPageMetaData stored procedure in each content database. Though this issue suggests that this stored procedure will not work correctly in SQL 2005 and SQL 2008, it apparently does and can be ignored.
· Other Database Engine upgrade issues – The upgrade advisor doesn’t check for all possible upgrade and compatibility issues. This can be ignored for SharePoint 2007 databases.
Here are some additional things to be aware of when building out a new farm or provisioning new services on SQL server 2008.
(Thanks to Gabe Bratton and Rahul Sakdeo for this info)
· SSRS and MOSS Report Center – On servers where MOSS is installed on top of SQL server 2008 with Reporting Services the potential for a URL conflict exists since they can both end up with the same url. The workaround would be to use a non-default web site for hosting MOSS. You can distinguish the sites using and IP address, Host Header, or Port.
· Least Privilege Deployments and WSS 3.0 – There is at least one known issue where provisioning a new web application will fail if content access account is running without sufficient permissions to the new database. I haven’t reproduced this or tested a workaround, but I imagine that if you temporarily give the content access account sys admin perms on the SQL Server you will avoid this error.
You will need to install .Net 3.5 SP1 and hotfix KB942288-v4 (Windows Installer 4.5) – Update services will be stopped and started during the install. These installs will likely require a reboot. One will wait for the other to complete before prompting to reboot. (two installs – one reboot)
Run setup.exe again after reboot and choose installation > upgrade from SQL Server 2000 or SQL Server 2005 and follow the prompts. I imagine a resource constrained or large SQL instance will take some time to upgrade. I did not notice any loss of availability with my databases during the upgrade which is good since my upgrade took almost 4 hours per instance, not including the prerequisites install. I have a feeling it took so long because of the lack of memory on my virtual server. (2GB) There was lots of paging occurring during the upgrade. The upgrade process itself seems lightweight, never consuming more than a few percent of the proc and about 30MB of memory.
If using database mirroring, upgrade the mirror and witness instances first. If running a mirroring split (principal databases on both instances) fail over to one node or the other. By upgrading the mirror and witness first you will ensure mirroring continues to work during the upgrade and you will minimize downtime due to the mandatory reboot. Make sure to upgrade the witness server and mirror server before attempting a failover. Else, the failover will fail and you will end up with unprotected databases and worse, you will need to break mirroring to bring your principal databases online.
All in all, the upgrade from SQL 2005 to SQL 2008 is a straightforward process. While I recommend you test the upgrade process I doubt you will find any surprises on a dedicated SharePoint backend. I hope that IT shops fast track this upgrade so we can focus on and take advantage of the new feature set in 2008. I plan to talk about how we SharePoint folks can leverage those new features in a post in the near future. [Update] See http://blogs.msdn.com/mikewat/archive/2008/08/19/improving-sharepoint-with-sql-server-2008.aspx for information on new features….(read more)
Read More

Microsoft Office Project Server 2003 Unleashed

This go-to-resource is a must-have for anyone using Project Server 2003!  Written by a widely recognized authority on project management, QuantumPM, this in-depth approach to planning and implementing Microsoft Office Project Server 2003 is derived from the team’s technical and practical client experiences.  Microsoft Office Project Server 2003 Unleashed provides an in-depth look at Microsoft Office Project Server 2003 and the possibilities of this technology.

Buy Now!

List Price: $ 64.99
Price: $ 0.20

Technology Made Simple for the Technical Recruiter: A Technical Skills Primer

This guidebook for technical recruiters is an essential resource for those who are serious about keeping their skills up-to-date in the competitive field of technical resource placement. Recruiting can be challenging with little background in technology, technology roles, or an understanding of how the two interact. In this book, you will learn the fundamentals of technology from basic programming terms, to database vocabulary, network lingo, operating system jargon, and other crucial skill sets. Topics covered include: • What questions to ask candidates • How to determine when someone is embellishing his or her skills • Types of networks and operating systems • Software development strategies • Software testing • Database job roles • And much more! Armed with indispensable information, the alphabet soup of technology acronyms will no longer be intimidating, and you will be able to analyze client and candidate requirements with confidence. Written in clear and concise prose Technology Made Simple for the Technical Recruiter is an indispensable resource for any technical recruiter.

Buy Now!

List Price: $ 22.95
Price: $ 21.08

THE definitive resource for all things BCS in SharePoint 2010

Having other books by Scot Hillier, I had high expectations for the book Professional Business Connectivity Services in SharePoint 2010and it blew those away. I teach SharePoint 2010 development and have found that one of the more challenging subjects to find details on. This book covers every single aspect of Business Connectivity Services (BCS) in SharePoint 2010. It starts out with a good discussion explaining the need and how it addresses the common challenges we face. It then goes into the details of how to implement and use custom BCS solutions using SharePoint Designer 2010.

Scot and Brad then go on to show you how to connect BCS solutions with Office 2010 as well as how to build custom solutions that are deployed to Office 2010. I had no idea SharePoint Workspace 2010 had a extensibility story! Finally they go into a deep walkthrough on building custom solutions using the .NET Assembly Connector & custom connectors. All in all, this is a fantastic resource I’d highly recommend to everyone doing SharePoint development.

Read More

Microsoft Sharepoint Portal Server 2001 Resource Kit (It Professional)

SharePoint Portal Server 2001 extends the capabilities of Microsoft Windows and Microsoft Office by offering powerful new document-management, content-searching, and team-collaboration features that make it easy for knowledge workers to organize, find, and share information. Roll out, support, and optimize SharePoint Portal Server 2001 with expertise from those who know the technology best-the SharePoint Portal Server development team. MICROSOFT SHAREPOINT PORTAL SERVER RESOURCE KIT is the all-in-one guide that computer professionals can rely on while installing, customizing, and supporting Microsoft SharePoint Portal Server 2001. This powerhouse reference includes hundreds of pages of detailed technical drill-down plus exclusive tools and Web parts on CD-ROM-all designed to help you save time and reduce support costs. Coverage includes detailed information on planning, deploying, administrating and managing developing, and troubleshooting of this powerful new server. Armed with this RESOURCE KIT and SharePoint Portal Server 2001, readers can plan and administer this new server to create corporate Web portals and integrate document management capabilities, browse through information by categories, search for information, subscribe to new or changing information, check documents in and out of a secure environment, review a document’s version history, approve documents for publication, publish documents, and simplify other corporate information-management functions.

Buy Now!

List Price: $ 69.99
Price: $ 9.97