Click here to receive your FREE subscription to Campus Technology
News
SQL Server 2005 SP3 Expected in Summer '08
4/18/2008
Microsoft this week announced through two blogs that it plans to release the next service pack to SQL Server 2005, Service Pack 3 (SP3). The release is timed for the third quarter of this year, or after Microsoft releases SQL Server 2008 to manufacturing.
In addition, Microsoft issued notes Monday describing the availability of Cumulative Update 7 (CU 7) for SQL Server 2005 Service Pack 2.
CU 7 is intended for users "severely affected" by certain problems. Those not affected should wait until the next service pack is released, according to Microsoft's notes.
Microsoft's PSS SQL Server engineers strongly caution that applying CU 7 can affect "Analysis Services backup and sync operations." The problem is associated with a time-out issue, as the PSS SQL blog explains.
"After the fix a backup is treated as a blocker for a commit operation. Due to the way that lock compatibility operates in Analysis Services, once the commit operation is blocked, all incoming requests against objects in the database are also blocked."
The blog describes some workarounds, but it generally recommends that administrators schedule "database backups at a time that will not overlap with processing of objects in the database."
The Cumulative Updates are part of Microsoft's "incremental servicing model" -- a three-pronged approach to releasing important code corrections that Microsoft calls "hotfixes." Microsoft's Cumulative Updates contain all previously released critical on-demand hotfixes and are released every two months. They must be requested by customers, but any customer, regardless of their support level can request them.
A second way to get hotfixes is through Microsoft's "On-Demand" and "Critical-On-Demand" releases, which are solutions to specific customer-referenced problems that have no workaround fix.
The third way that Microsoft releases hotfixes is in a "general distribution release." Microsoft issues these general distribution releases when it needs to fix problems that affect customers more broadly, such as when security issues are involved.
Microsoft already has uploaded a page describing its next Cumulative Update for SQL Server 2005 Service Pack 2. Cumulative Update 8, as it's called, is scheduled for release sometime in June.
Kurt Mackie is Web editor of RCPmag.com and ADTmag.com. He can be reached at kmackie@1105media.com.
Cite this Site
copy text (above) for proper citation
Recommended Reading
- Sun, Stanford Working To Archive History
In May in San Francisco, experts from leading universities, libraries, and research institutions around the world met as part of an ongoing effort to address a pressing issue: archiving the world's history, right up to today.
- The Quilt Coalition Rolls Out XO Communications for High-Capacity Network Services
The Quilt, a coalition of 28 regional network organizations, has added XO Communications Services to its authorized vendor list. The Quilt represents 200 universities and thousands of other educational institutions across the United States. With this new relationship, Quilt members can purchase XO's high-speed IP transit and network transport services at competitive rates.
- Wimba Classroom 5.2 Expands Classroom Capture Support, Adds MP3 Downloads
At the NECC 2008 conference in Texas this week, Wimba launched a new version of Wimba Classroom, the virtual classroom component of the company's Collaboration Suite. The new 5.2 release expands options for classroom capture and adds a variety of other functional and ease of use features.
- Automation Chimera: Education Is Not Management
The lure of automating workflow online so human intervention is minimized is continually reinforced in the minds of higher education administrators by examples of automated campus systems such as financials, student information systems, and other enterprise systems. But what's good for management is not always good for learning.
- Cognos Releases BI Software for Linux-based IBM System z Mainframe
Cognos, which IBM acquired in January, has released an update to its business intelligence software that will run on the Linux operating system on IBM System z mainframes. IBM Cognos 8 BI was being developed by the two companies prior to the acquisition, but assimilation of Cognos into IBM accelerated development.
- Facebook and Collegiality: A Serendipitous Social Niche
Facebook is a way to greet a colleague as if she or he is on your own campus: a wave at a distance, a hello at the corner burrito place, a honk as you both leave the campus parking lot. Informal collegiality has been extended over the miles.
