Microsoft SQL Server 2008 R2 Service Pack 2 (SP2) released today includes product improvements based on requests from the SQL Server community and hotfix solutions provided in SQL Server 2008 R2 SP1 Cumulative Updates 1 to 5.
Here are a few highlights what's new in SP2:
- "Reporting Services Charts Maybe Zoomed & Cropped
Customers using Reporting Services on Windows 7 may sometime find charts are zoomed in and cropped. To work around the issue some customers set ImageConsolidation to false.
- Batch Containing Alter Table not Cached
In certain situations with batch files containing the alter table command, the entire batch file is not cached.
- Collapsing Cells or Rows, If Hidden Render Incorrectly
Some customers who have hidden rows in their Reporting Services reports may have noticed rendering issues when cells or rows are collapsed. When writing a hidden row, the Style attribute is opened to write a height attribute. If the attribute is empty and the width should not be zero," explains SQL team.
Also, the Community Technology Preview of Open XML SDK 2.5 for Microsoft Office, released on July 24, intended for feature evaluation purposes.
Built on top of the System.IO.Packaging API, Open XML SDK 2.5 CTP for Microsoft Office is a pre-release build of the next version of Open XML SDK and provides strongly typed part classes to manipulate Open XML documents.
"The SDK also uses the .NET Framework Language-Integrated Query (LINQ) technology to provide strongly typed object access to the XML content inside the parts of Open XML documents," Microsoft said.
The tools package contains the Open XML SDK v2.5 Productivity Tool for Office and the hyperlink to documentation for the Open XML SDK v2.
The Open XML SDK 2.5 Productivity Tool for Microsoft Office provides a number of features designed to improve your productivity and accelerate your learning while working with the SDK and Open XML files.
Features include "the ability to generate Open XML SDK 2.5 source code based on document content, compare source and target Open XML documents to reveal differences and to generate source code to create the target from the source, validate documents, and display documentation for the Open XML SDK v2.5, the ECMA376v1 standard, and the Microsoft Office implementation notes," Microsoft exlpained.
The available package includes the Open XML SDK v2.5 Productivity Tool for Office, along with documentation for the Open XML SDK v2.5.
"Open XML is an open ECMA 376 standard and is also approved as the ISO/IEC 29500 standard that defines a set of XML schemas for representing spreadsheets, charts, presentations, and word processing documents," Microsoft explains.
Microsoft Office Word 2010, Excel 2010, and PowerPoint 2010 all use Open XML as the default file format.
- SQL Server 2008 R2 SP2
- SQL Server 2008 R2 SP2 Express
- SQL Server 2008 R2 SP2 Feature Packs
- Open XML SDK 2.5 CTP for Microsoft Office
Also, Microsoft Security Research Center issued a new Security Advisory (2737111) stating that they are "investigating new public reports of vulnerabilities in third-party code, Oracle Outside In libraries, that affect "Web-ready document viewing" in Microsoft Exchange Server 2007 and Microsoft Exchange Server 2010."
Microsoft recommend that customers apply the workarounds described in this advisory "so you are not exposed to the vulnerabilities described in Oracle Critical Patch Update Advisory - July 2012."
"Web-ready document viewing is a feature that allows Outlook Web App users to view supported attachments in an email without having to download them to a computer and using locally-installed applications to view them," Microsoft explains.