News

Microsoft Releases CTPs of SQL Server 2008 SP3

Microsoft on Monday released community technology previews (CTPs) of a new Service Pack 3 (SP3) being developed for various versions of SQL Server 2008.

Microsoft issues CTPs, which are not-for-production test versions, to gather user feedback on its products before their final release. The new SQL Server 2008 SP3 CTP can be downloaded here. It's available in 32-bit and 64-bit versions for most editions of the product, including the Evaluation, Standard, Enterprise, Developer and Workgroup editions.

The new SQL Server 2008 SP3 Express edition CTP (32-bit and 64-bit) can be downloaded here. The Express edition is free to use, but Microsoft only recommends it for supporting smaller server and desktop applications, or just for learning purposes.

The CTPs contain improvements based on earlier customer comments, but Microsoft managed to reduce the changes with this release by about 65 percent, according to Abhishek Sinha, a program manager for the Microsoft SQL Server sustained engineering team. Sinha explained in a blog post that introducing fewer changes into the service packs adds greater sustainability on the customer's side, and Microsoft had improved its product development processes with an eye toward achieving that goal.

The changes highlighted by Sinha included an improved upgrade experience. SQL Server Integration Services will now show the total rows sent in data flows. There are also some functional improvements. Users get a warning message during a maintenance process "if the Shrink Database option is enabled," Sinha explained. A SQLAgent.exe shared memory problem that prevented the program from running from the command line has been fixed, he added.

A list of the flaws that were fixed in SQL Server 2008 SP3 CTP can be found in this Knowledge Base article.

The current non-test version of SQL Server 2008 R2 SP1 was released by Microsoft in July. Microsoft also released a CTP3 test version of its next-generation SQL Server, code-named "Denali," at that same time. The last service pack that Microsoft released for its SQL Server 2008 relational database management products was Service Pack 2, back in September 2010.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.

Featured

  • Microsoft Joins Amazon, Google, OpenAI and Other Tech Giants in AI Safety Pledge

    Over a dozen companies at the forefront of today's generative AI boom have agreed to a set of "AI safety commitments" as part of last week's AI Seoul Summit.

  • Image of a futuristic maze

    The 2024 Microsoft Product Roadmap

    Everything Microsoft partners and IT pros need to know about major Microsoft product milestones this year.

  • SharePoint Embedded Becomes Generally Available

    After a six-month preview, SharePoint Embedded, an API-based version of SharePoint that developers and ISVs can use to embed Microsoft 365 capabilities into their apps, is now generally available.

  • Copilot in Microsoft 365 Getting Agents, Extensions and Team (Not Teams) Support

    Microsoft is adding more functionality to its Copilot AI assistant aimed at improving business collaboration, processes and workflows for Microsoft 365 users.