May - Technical Rollup Mail - SQL

News

The Fantastic 12 of 2012: A Behind the Scenes View of Blazing Fast Performance

https://blogs.technet.com/b/dataplatforminsider/archive/2012/04/26/the-fantastic-12-of-2012-a-behind-the-scenes-view-of-blazing-fast-performance.aspx

Win New SQL Server T-Shirts by Following the Fantastic 12 of 2012: Behind the Scenes Blog Series

https://blogs.technet.com/b/dataplatforminsider/archive/2012/04/23/win-new-sql-server-t-shirts-by-following-the-fantastic-12-of-2012-behind-the-scenes-blog-series.aspx

The Fantastic 12 of 2012: Behind the Scenes Look into Required 9s and Data Protection

https://blogs.technet.com/b/dataplatforminsider/archive/2012/04/18/the-fantastic-12-of-2012-behind-the-scenes-look-into-required-9s-and-data-protection.aspx

Customers achieving Breakthrough Insight with SQL Server 2012: Volvo Car Corporation, ABB SpA, Klout, Stein Mart and Menlo Worldwide Logistics

https://blogs.technet.com/b/dataplatforminsider/archive/2012/04/13/customers-achieving-breakthrough-insight-with-sql-server-2012-volvo-car-corporation-abb-spa-klout-stein-mart-and-menlo-worldwide-logistics.aspx

The coming in-memory database tipping point.

https://blogs.technet.com/b/dataplatforminsider/archive/2012/04/09/the-coming-in-memory-database-tipping-point.aspx

Guest Blog by EMC: Mission Critical Confidence meets Efficient and Powerful

https://blogs.technet.com/b/dataplatforminsider/archive/2012/04/06/guest-blog-by-emc-mission-critical-confidence-meets-efficient-and-powerful.aspx

SQL Server 2012 – Battle Tested for the NEW Mission Critical

https://blogs.technet.com/b/dataplatforminsider/archive/2012/03/13/sql-server-2012-battle-tested-for-the-new-mission-critical.aspx

Other

https://blogs.technet.com/trm/default.aspx

Events/Webcasts

SQL Rally Dallas

https://www.microsoft.com/sqlserver/en/us/learning-center/events.aspx

Documents

SQL Server 2012 Data Sheet

https://download.microsoft.com/download/3/6/C/36C733CA-394B-4C44-A83C-945600644B0A/SQL_Server_2012_Overview_Mar2012.pdf

New KB Articles

SQL 2008

Microsoft SQL Server 2008 R2 Analysis Services

FIX: Slow performance when you run an MDX query that uses some sub queries in SSAS 2008 R2

https://support.microsoft.com/kb/2675233

Microsoft SQL Server 2008 R2 Analysis Services

FIX: Performance of a SELECT statement that contains a LIKE operator and an ESCAPE clause is low in SQL Server 2008 R2

https://support.microsoft.com/kb/2698639

Microsoft SQL Server 2008 R2 Analysis Services

FIX: SQL Server 2008 R2 may stop responding when you perform many Update Cube writeback transactions on multiple cubes that belong to different SSAS 2008 R2 databases

https://support.microsoft.com/kb/2682819

Microsoft SQL Server 2008 Datacenter

FIX: The size of a database file is not reduced when you use the DBCC SHRINKFILE command in SQL Server 2008 R2

https://support.microsoft.com/kb/2674636

Microsoft SQL Server 2008 Developer

FIX: Replication Log Reader Agent crashes when an empty string is inserted into an XML column of a table in a transactional replication publication in SQL Server 2008 R2

https://support.microsoft.com/kb/2681514

Microsoft SQL Server 2008 Enterprise Edition

FIX: A non-convergence occurs when you run a merge replication publication that uses web synchronization if the value of a column is NULL in SQL Server 2008 R2

https://support.microsoft.com/kb/2689903

Microsoft SQL Server 2008 R2 PowerPivot for Excel

FIX: Error message when you try to create a data service document in a data feed library from a sub-site collection in SharePoint 2010 to publish Atom feeds: "There is no file with URL"

https://support.microsoft.com/kb/2700227

Microsoft SQL Server 2008 R2 Reporting Services

FIX: Error message when you try to view a report in SSRS 2008 R2: "Different query parameters resulted in a same hash"

https://support.microsoft.com/kb/2696161

Microsoft SQL Server 2008 R2 Reporting Services

FIX: You cannot search a Word document or an Excel workbook that is exported from an SSRS 2008 R2 report by using a keyword in the content of the document or of the workbook in SharePoint 2010

https://support.microsoft.com/kb/2678796

Microsoft SQL Server 2008 R2 Reporting Services

FIX: The field list of the dataset disappears unexpectedly when a report uses a query as a dataset that includes named parameters in SQL Server 2008 R2

https://support.microsoft.com/kb/2679342

Microsoft SQL Server 2008 R2 Standard Edition

Cumulative update package 6 for SQL Server 2008 R2 Service Pack 1

https://support.microsoft.com/kb/2679367

Microsoft SQL Server 2008 R2 Standard Edition

Cumulative update package 13 for SQL Server 2008 R2

https://support.microsoft.com/kb/2679366

Microsoft SQL Server 2008 Standard Edition

DateTime values are rounded to the nearest second when a business logic handler is used in SQL Server 2008 or SQL Server 2008 R2

https://support.microsoft.com/kb/2598510