Home

SharePoint IT Pro Blog

MSDN Magazine Feed

Friday, November 21, 2008

Using the new features in SQL Server 2008 with Office SharePoint Server 2007

Microsoft SQL Server 2008 includes several new and enhanced features that are important for deploying Office SharePoint Server 2007. New and enhanced SQL Server 2008 features are especially relevant for SharePoint deployments in four principal areas:

> Performance
> Availability
> Security
> Resource management


You can improve Office SharePoint Server performance by implementing the new database backup compression feature in SQL Server 2008. The ability to compress database backups is a significant improvement for Office SharePoint Server users; it enables you to significantly decrease the size of your database backups and shipped logs.


You can improve Office SharePoint Server availability by implementing the new log stream compression feature in SQL Server 2008. One of the performance-limiting factors of database mirroring is network throughput between the principal and mirror servers. SQL Server 2008 supports compression of the log stream, which consists of the inserts, updates, and deletes that are transferred between servers. Log stream compression can help maximize network throughput, especially in environments where network conditions are poor.


You can improve Office SharePoint Server security by using the new Transparent Data Encryption (TDE) feature in SQL Server 2008. TDE enables you to encrypt entire databases and requires no application awareness or modification. TDE encrypts data as it is written to disk and decrypts data as it is read from disk.


You can improve Office SharePoint Server resource management by using SQL Server 2008 Resource Governor. SQL Server Resource Governor enables you to maintain and administer your SQL Server resources, such as CPU and memory. You can use SQL Server Resource Governor to precisely control how your SQL Server resources are allocated. With SQL Server Resource Governor, you can apply thresholds to incoming connections based on assigned criteria.


For prescriptive guidance about implementing some of the new features in SQL Server 2008 that enhance the deployment of Office SharePoint Server 2007, see Integration of SQL Server 2008 and Office SharePoint Server 2007.


For information about SQL Server 2008 system requirements, see
Hardware and Software Requirements for Installing SQL Server 2008.

Monday, November 17, 2008

SharePoint group audience targeting stops functioning

After you install the updates that are described in Microsoft Knowledge Base articles 952294 and 946517, Microsoft Office SharePoint 2007 audience targeting stops functioning for nested SharePoint groups for global navigation and for any SharePoint group audience targeting for Web parts. The navigation links and Web parts in these cases are not visible at all. Therefore, they are inaccessible to the user targeted.

Hot Fix :

Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): October 28, 2008
http://support.microsoft.com/kb/957693
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957693

Friday, November 14, 2008

WSS & SharePoint Update / Hot Fix

Announcing August Cumulative Update for Office SharePoint Server 2007 and Windows SharePoint Services 3.0
The Microsoft Office team has changed the way that it delivers hotfixes for reported problems. This change comes in the form of cumulative updates and critical on-demand hotfixes. The objective is to deliver high-quality fixes in an acceptable time and on a predictable schedule. Cumulative updates are scheduled for every two months, so customers can be better prepared to test and apply new updates. Those who need an emergency fix can request critical on-demand (COD) fix. For information, please refer to http://support.microsoft.com/kb/953878.
The detail of August Cumulative Update (CU) for Office SharePoint Server 2007 and Windows SharePoint Services 3.0 can be found here:
Description of the Windows SharePoint Services 3.0 hotfix package (Wssmui.msp): August 26, 2008
Description of the Windows SharePoint Services 3.0 hotfix package: August 26, 2008
Description of the SharePoint Server 2007 hotfix package: August 26, 2008
Customers are not needed to install these updates unless they are affected by specific problems described in the KB articles. And these cumulative updates will be rolled in to Service Pack 2.
To keep all files in a SharePoint installation updated, we recommend customers to follow the path below:
1.
Windows SharePoint Services 3.0 Service Pack 1
2. The 2007 Microsoft Office Servers Service Pack 1
3. The Windows SharePoint Services Infrastructure Update x86 x64
4. The Microsoft Office Servers Infrastructure Update x86 x64
5. KB 953397: Excel Server Security Update x86 x64
6. KB 955586: Document Lifecycle Workflow Update
7.
August Cumulative Update for Windows SharePoint Services 3.0 (Global)
8. August Cumulative Update for Windows SharePoint Services 3.0 (Local)
9. August Cumulative Update for Microsoft Office Servers
After applied all these updates, run SharePoint Products and Technologies Configuration Wizard or “psconfig –cmd upgrade –inplace b2b” in command line. This need to be done on every server in the farm with SharePoint installed.
The version of databases should be 12.0.6327 after all these updates.
For a better guided update process, customers would also like to check out the following guides. These articles provide a correct way to deploy updates, as well as known issues and how to do slipstream builds.
Deploy software updates for Windows SharePoint Services 3.0
http://technet.microsoft.com/en-us/library/cc288269.aspx
Deploy software updates for Office SharePoint Server 2007
http://technet.microsoft.com/en-us/library/cc263467.aspx

Update: October Cumulative Update has been released on Oct 28th. Here're the download links and descriptions.

______________________________________________________________

Cumulative update packages for the 2007 Microsoft Office core suite applications and for 2007 Microsoft Office servers: October 28, 2008

http://support.microsoft.com/kb/958847

Description of the Windows SharePoint Services 3.0 hotfix package: October 28, 2008

http://support.microsoft.com/kb/957691

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957691

Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): October 28, 2008

http://support.microsoft.com/kb/957693

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957693

Announcing December Cumulative Update for Office SharePoint Server 2007 and Windows SharePoint Services 3.0

___________________________________________________


We are happy to announce that December Cumulative Update for Office SharePoint Server 2007 and Windows SharePoint Services 3.0 is available now. Despite the fixes and improvements, this new update package is also an effort to create a more convenient way for SharePoint administrators to keep all files in their SharePoint installations up-to-date. In this post, we will guide you on how and when to update, and the background of this new update model improvement.


December Cumulative Update Steps & Suggestions
Customers do not need to install these updates unless they are affected by the specific problems described in the KB articles. These cumulative updates will be rolled in to Service Pack 2.
To keep all the files in a SharePoint installation up-to-date, we recommend that customers install updates in the following sequence:


1.
Windows SharePoint Services 3.0 Service Pack 1
2. The 2007 Microsoft Office Servers Service Pack 1
3. December Cumulative Update for Windows SharePoint Services 3.0
4. December Cumulative Update for Microsoft Office Servers


After applying the preceding updates, run the SharePoint Products and Technologies Configuration Wizard or “psconfig –cmd upgrade –inplace b2b -wait” in command line. This needs to be done on every server in the farm with SharePoint installed. The version of content databases should be 12.0.0.6335 after successfully applying these updates.

The detail of December Cumulative Update (CU) for Office SharePoint Server 2007 and Windows SharePoint Services 3.0 can be found here:
Description of the Windows SharePoint Services 3.0 cumulative update package: December 16, 2008 (The link will be active soon)
Description of the SharePoint Server 2007 cumulative update package: December 16, 2008 (The link will be active soon)

Thursday, November 13, 2008

Visual Studio 2010 Tools for SharePoint & .NET Framework 4.0

Visual Studio 2010 Tools for SharePoint Announced at TechEd EMEA Developers 2008

This week at TechEd EMEA in Barcelona, Jason Zander, the GM for Visual Studio, announced and demonstrated the Visual Studio 2010 tools for SharePoint. Here's a quick summary of what he showed:
•Server Explorer for SharePoint viewing Lists and other artifacts in SharePoint directly inside of Visual Studio
•Windows SharePoint Services Project (WSP file) Import to create a new solution
•Added a new web part project item and showed the Visual web part designer which loads a user control as a web part for SharePoint
•Showed adding an event receiver for SharePoint and using the wizard to choose the event receiver and to just create a source file with that event receiver.
•Added an ASPX workflow initiation form to a workflow project and showed how this workflow initiation form has designer capability
•Showed the packaging explorer and the packaging editor which lets you structure the SharePoint features and WSP file that is created

Web Url: http://msdn.microsoft.com/en-us/vs2008/products/cc948977.aspx

Visual Studio 2010: http://www.microsoft.com/visualstudio/2010/overview.mspx

.NET Framework 4.0 [Dublin] : http://www.microsoft.com/net/Dublin.aspx