Click here to receive your FREE subscription to Campus Technology
News
Microsoft Details SharePoint-SQL 2008 Integration
8/22/2008
|
|
Microsoft really wants SharePoint users to upgrade to SQL Server 2008, which was released to manufacturing Aug. 6. Tuesday, the company's SharePoint hosting and development blog pointed out that IT admins don't have to wait for the documentation to do so.
IT administrators typically look for Microsoft's "supportability statement" document before performing system upgrades. The document for Microsoft Office SharePoint Server (MOSS) 2007 is currently available, and it includes information about upgrading to SQL Server 2008 that was published on July 31.
The document describes MOSS 2007 hardware and software dependencies, along with precautions on upgrading from SQL Server 2005 to SQL Server 2008. For instance, you need to have the latest SharePoint service packs in place before installing SQL Server 2008.
"Office SharePoint Server 2007 supports SQL Server 2008," the document says. "However, you must install Windows SharePoint Services 3.0 SP1 or later and Office SharePoint Server 2007 SP1 or later before you install SQL Server 2008."
IT admins have to download and run the setup program, as well as "the SharePoint Products and Technologies Configuration Wizard," to perform the MOSS 2007 SP1 install.
The SharePoint Hosting and Development blog provides some upgrade tips and suggests that the "upgrade from [SQL Server] 2005 to 2008 is a pretty simple process." IT admins will have to install ".NET 3.5 SP1 and hotfix KB942288-v4" first in order to move to SQL Server 2008.
Microsoft's blog provides a list of features describing why IT admins should upgrade, but most of the benefits seem to apply just to improvements in SQL Server 2008. One potential benefit is data compression, which can be automated by default. Compression can reduce your backup size, although SharePoint stores data in the binary large object (blob) form, which doesn't compress as well as other data types.
"That said, you can probably see up to 30% [size reduction] on your blob-laden content databases and perhaps 90-95% on your other databases," the blog estimates.
Other improvements include a Resource Governor for SQL Server maintenance and administration, although the blog cautions that it "should not be used to control SharePoint's usage of SQL."
Those interested in Microsoft's supportability statement for MOSS 2007 -- which goes by the descriptive title, "Determine hardware and software requirements (Office SharePoint Server)" -- can access it on Microsoft TechNet here.
Kurt Mackie is online news editor, Enterprise Group, at 1105 Media Inc. You can contact Kurt at kmackie@1105media.com.
Cite this Site
copy text (above) for proper citation
Recommended Reading
- Tufts Grants Rights for Mileage-Increasing Transportation Technology to Electric Truck
Tufts University has optioned rights to a technology that can recharge the batteries of any hybrid electric and electric-powered vehicle while it is driven. The Tufts-developed technology could increase by 20 percent to 70 percent the miles per gallon or total driving range performance of vehicles like the Honda Civic, Ford Escape, and Toyota Prius hybrids and the Tesla Motors and Phoenix Motorcars electric vehicles.
- U Florida and Cyntellect Collaborate to Unlock Mysteries of Cancer Stem Cells
The University of Florida has entered into a research agreement with life sciences company Cyntellect. The university's Interdisciplinary Center for Biotechnology Research will work with the company to focus on a variety of research areas including the purification and analysis of cancer stem cells (CSCs), rare cells believed to be directly involved in propagating cancers.
- George Mason U Receives Grant To Deploy Intergraph Apps for Intelligence Curriculum
George Mason University (GMU) in Fairfax, VA has been awarded a grant from Intergraph to enable students enrolled in GMU's Geospatial Intelligence Graduate Certificate program to use the company's geospatial production and exploitation software as part of their core curriculum.
- Institute for Cyber Security at U Texas, San Antonio Opens Incubator
The University of Texas at San Antonio (UTSA) Institute for Cyber Security (ICS) has launched a new Internet security incubator. The incubator was developed to commercialize promising technologies that address major cyber security and privacy issues. The first companies to enter the incubator are Denim Labs and SafeMashups.
- ISO/IEC Publishes Office Open XML Standard
ISO/IEC has published the Office Open XML (OOXML) file format standard, formally known as ISO/IEC 29500:2008. It describes file formats originally designed by Microsoft for its Office 2007 productivity suite, which are used in presentation, spreadsheet and word processing applications.
- Dynamics NAV 2009 ERP Coming Next Month
Microsoft exec Kirill Tatarinov Wednesday described some new features to expect in the forthcoming Microsoft Dynamics NAV 2009 enterprise resource planning solution. He gave the keynote address at Microsoft's Convergence 2008 event in Copenhagen, Denmark.
