August 2013 – Technical Rollup Mail – SQL Server

 

News

Hardware Considerations for In-Memory OLTP in SQL Server 2014

https://blogs.technet.com/b/dataplatforminsider/archive/2013/08/01/hardware-considerations-for-in-memory-oltp-in-sql-server-2014.aspx

SQL Server 2014 In-Memory OLTP – bwin Migration and Production Experience

https://blogs.technet.com/b/dataplatforminsider/archive/2013/07/30/sql-server-2014-in-memory-oltp-bwin-migration-and-production-experience.aspx

Buffer Pool Extension to SSDs in SQL Server 2014

https://blogs.technet.com/b/dataplatforminsider/archive/2013/07/25/buffer-pool-extension-to-ssds-in-sql-server-2014.aspx

Premium Preview for Windows Azure SQL Database Now Live!

https://blogs.technet.com/b/dataplatforminsider/archive/2013/07/22/architectural-overview-of-sql-server-2014-s-in-memory-oltp-technology.aspx

Architectural Overview of SQL Server 2014’s In-Memory OLTP Technology

https://blogs.technet.com/b/dataplatforminsider/archive/2013/07/22/architectural-overview-of-sql-server-2014-s-in-memory-oltp-technology.aspx

Premier

Welcome opsvault.com - BlueHost.com

https://www.opsvault.com

TechNet Blogs

https://blogs.technet.com/b/mspremuk/

SQL Server Blogs

Search - MSDN Blogs

https://blogs.msdn.com/search/searchresults.aspx?q=SQL%20Server%202008%20R2&sections=5001

MSDN Blogs

https://blogs.msdn.com/b/psssql/

SQL Server Team Blog - Site Home - TechNet Blogs

https://blogs.technet.com/b/dataplatforminsider/

SQL Server Security - Site Home - MSDN Blogs

https://blogs.msdn.com/b/sqlsecurity/

Paul S. Randal - In Recovery...

https://www.sqlskills.com/blogs/paul/

SQL Server Storage Engine - Site Home - MSDN Blogs

https://blogs.msdn.com/b/sqlserverstorageengine/

SQL Azure

SQL Azure Team Blog - Site Home - MSDN Blogs

https://blogs.msdn.com/b/sqlazure/

Other

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

Downloads

clip_image002

Redistributable component

Microsoft® SQL Server® 2012 SP1 Feature Pack

The Microsoft® SQL Server® 2012 SP1 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2012 SP1.

FREE

Release Date:

1/9/2013

clip_image002[1]

Application

Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012

Installs the Microsoft SQL Server Data Tools Business Intelligence project templates for Analysis Services, Integration Services, and Reporting Services.

FREE

Release Date:

6/7/2013

Events/Webcasts

24 Hours of PASS

https://www.24hoursofpass.com/

Microsoft Virtual Academy

https://www.microsoftvirtualacademy.com/#fbid=OyFqx7G05Ks

New KB's

FIX: Error message when you use the sqlcmd utility to execute the Transact-SQL query in SQL Server 2008 and SQL Server 2008 R2

https://support.microsoft.com/kb/2121407/EN-US

FIX: SSRS 2008 R2 report or SSRS 2012 report has no Export menu in Internet Explorer 9.0 if you use the out-of-box viewer page in the SharePoint Report Viewer Web Part

https://support.microsoft.com/kb/2616481/EN-US

FIX: Incorrect results when a complex update query uses the JOIN operator in an execution plan in SQL Server 2008 or in SQL Server 2008 R2

https://support.microsoft.com/kb/2499023/EN-US

FIX: An update is available that enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server 2008 R2 or in SQL Server 2008

https://support.microsoft.com/kb/2793580/EN-US

FIX: Incorrect result when you run an MDX query that includes an Aggregate function that is used in a calculated member in SSAS 2008 R2 or SSAS 2012

https://support.microsoft.com/kb/2800284/EN-US

FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2, SQL Server 2008 or SQL Server 2012

https://support.microsoft.com/kb/2803799/EN-US

FIX: You may experience performance issues in SQL Server 2012

https://support.microsoft.com/kb/2845380/EN-US

FIX: Index size increases significantly after you rebuild the index online and the RCSI is enabled in SQL Server 2008 or in SQL Server 2008 R2

https://support.microsoft.com/kb/2812884/EN-US

FIX: Master Data Explorer pane does not display in the SQL Server 2012 MDS Add-in for Excel

https://support.microsoft.com/kb/2840614/EN-US

FIX: Error 3241 when you run RESTORE FILELISTONLY statement in SQL Server 2008 R2 or SQL Server 2012

https://support.microsoft.com/kb/2849351/EN-US

FIX: An UnhandledReportRenderingException error occurs when a report is rendered in Report Manager in SQL Server 2008 R2 Service Pack 2 or SQL Server 2012

https://support.microsoft.com/kb/2854420/EN-US

Technorati Tags: SQL,SQL Server,Hekaton,OLTP,OLAP,Memory Optimised,2014