Microsoft made the second service pack for SQL Server 2005 broadly available as of Presidents' Day.
This is not a trivial release. As reported by CRN in August, customers who want their database to be fully supported on the new Vista client, must install the new Service Pack 2.
The fact that SP 2 came out weeks, even months, after Vista itself demonstrates the quandary for those buying into the full Microsoft stack: The components are hardly in lockstep, and updates to one layer can break parts of another. Vista became available to corporate volume licensees in late November/early December and to consumers in late January/early February.
The update allows "unlimited virtual instances" to run on "fully licensed" SQL Server 2005 Enterprise Edition, according to a company statement on Monday.
Other claimed perks: improved analysis services for the newly available Excel 2007; data compression to ease disk storage requirements particularly in data warehousing ; and better manageability. The company also added management reports for the low-end SQL Server Express edition and better links for Oracle in the Report Builder.
For VARs with customers running older applications with the older embeddable Microsoft SQL Server Desktop Engine (MSDE), there is guidance on upgrading to SQL Server 2005 Express on Technet.
Microsoft has said that SP 2 will bundle the newer SQL Server Express Edition. VARs maintain that older MSDE applications will probably have to be rewritten. That could be a problem because many customers may run MSDE in applications without even knowing it.
For more on SQL Server compatibility issues see this site.
This report was updated Monday evening with additional information on MSDE to SQL Server 2005 Express migration.
|
|
10 Letdowns From The Facebook IPO Filing It may make a lot of its employees millionaires, but Facebook's IPO filing was disappointing in a few areas. |
|
|
Seven Hot Business Apps For Mac OS X Macworld/iWorld, the new name for the Macworld expo, featured the first OS X Zone. The sold-out section of the showroom floor was dedicated to exhibitors with software and accessories for Apple's Mac desktops and laptops. |
|
|
The New Face Of Linux Distros In 2012 From specialized OSes for fixed functions like kiosks or security, to revamped GUIs on general operating systems, Linux desktops in 2012 are taking on a new look. |
- Another Vista Wrinkle: Latest Database Required
- Barb Darrow's Unblog: Road To Vista--SQL Server SP2 Hits
- Microsoft's Flessner Gives The Skinny On SQL Server
- Microsoft's Flessner To Step Back From Day-To-Day Duties
- Imaging Know-How Could Boost Microsoft Applications
- Next SQL Server Stop: Katmai
- Microsoft Details Windows-On-ARM Development Efforts
- Appcelerator Extends Mobile App Dev Reach With Cocoafish Buy
- Microsoft Taps Cisco Exec To Manage Public Sector Business
- Microsoft Sets Feb. 29 For Windows 8 Consumer Preview Release
- The Importance of Partner Enablement in a Changing Software Industry
- The Cloud Computing Opportunity – How to Effectively Tap into the Future of IT
- Seize the Cloud! Proven Near-Term Tactics From Successful Service Providers: Hear the Inside Secrets from the fastest growing $2m+ MSPs
- Open Source and the Channel: A Perfect Pairing
