Microsoft Releases SP2 Preview for SQL Server 2008 R2 -- Redmondmag.com

Microsoft Releases SP2 Preview for SQL Server 2008 R2

By Kurt Mackie
05/15/2012

Microsoft this week released a preview of its forthcoming Service Pack 2 (SP2) for SQL Server 2008 R2.

The community technology preview (CTP) is designed for testing purposes only and not for production environments. It can be downloaded here. It's not clear when Microsoft will release the final version of the service pack.

SP2 fixes about 25 flaws in Microsoft's relational database management system. The flaws are described in this Knowledge Base article.

The fixes are based on requests from users, according to Microsoft's announcement. The CTP also includes hotfixes from Microsoft earlier release, namely cumulative updates 1 through 5 for SQL Server 2008 R2 Service Pack 1.

Microsoft listed three highlights to be found in the CTP. It's designed to fix an issue where charts in Windows 7 reports get inexplicably cropped. Another fix addresses a problem with "hidden rows," which causes rows or cells to get collapsed in reports. Finally, Microsoft added fix for a caching problem associated with "batch files containing the alter table command," according to the company's announcement.

About the Author

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

Featured

Using Configuration Files to Control PowerShell Scripts, Part 2: Building Blocks

Learn how to use PowerShell's GUI capabilities to dynamically create configuration files that enhance script flexibility and usability.
U.S. House Leaders Unveil Bipartisan Strategy for AI Governance and Innovation

On Tuesday, U.S. House Speaker Mike Johnson and Democratic Leader Hakeem Jeffries received the final report from the bipartisan House Task Force on Artificial Intelligence, which outlines essential principles and recommendations to bolster American leadership in AI.
Using Configuration Files to Control PowerShell Scripts, Part 1: The Basics

Learn how to use JSON configuration files to make PowerShell scripts more dynamic, flexible and user-friendly.
Exchange Online Receiving Enhanced Message Trace

Microsoft has announced the public preview of its enhanced Message Trace feature in the Exchange admin center (EAC) for Exchange Online.
Major Microsoft Multifactor Authentication Vulnerability Revealed

A vulnerability in Microsoft’s multifactor authentication (MFA) system has been uncovered by cybersecurity firm Oasis Security, allowing attackers to bypass security measures and access sensitive data across services including Outlook, OneDrive, Teams and Azure.