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
- RIAA Outsources Fingering of Students Who Share Music Illegally
The RIAA is outsourcing the hunt for music thieves. Its largest target currently is those who operate from within colleges and universities, a move that has piqued the attention of Educause.
- Microsoft Expands Education Footprint in Asia Pacific Region
Microsoft Chairman Bill Gates announced new partnerships to extend accessibility and computer literacy in the Asia Pacific region during a speech in Jakarta at a government leader gathering earlier this week.
- IT Struggling Over Security, Compliance
IT pros are having a hard time balancing security, software patch management and IT auditing with a host of other duties, according to a survey released Monday by Shavlik Technologies.
- Toronto College Upgrades Network with Gigabit Ethernet Wireless Links
Toronto-based George Brown College has gone public about its deployment of six BridgeWave GE60 wireless links to upgrade its campus-wide network.
- Gates Highlights R&D at CES08, Unveils Microsoft Touch Wall
Microsoft's Chairman Bill Gates spent a lot of time Wednesday talking about "empowering the workers" at the Microsoft's 12th annual CEO Summit 2008 in Redmond, WA, where he gave a keynote speech. However, Gates wasn't talking about political revolutions or even pay raises for office workers before the CEO crowd. Instead, he was referring to new software technologies that can better enable collaboration, social networking and decision-making on the job.
- Vista Vulnerability Study Puts Microsoft on Defensive
Microsoft and some independent security researchers had the blogosphere buzzing Wednesday over a series of denunciations after one company claimed that the Vista operating system was more vulnerable to malware and other exploits than previous operating systems.
