Technical Rollup Mail – SQL Server – September 2013

News

Tune in to TechNet Radio for the Inside Scoop on PASS Summit 2013

https://blogs.technet.com/b/dataplatforminsider/archive/2013/09/05/tune-in-to-technet-radio-for-the-inside-scoop-on-pass-summit-2013.aspx

Querying Microsoft SQL Server 2012 Databases Jump Start–September 13th

https://blogs.technet.com/b/dataplatforminsider/archive/2013/09/04/querying-microsoft-sql-server-2012-databases-jump-start-september-13th.aspx

Solving Session Management Database Bottlenecks with In-Memory OLTP

https://blogs.technet.com/b/dataplatforminsider/archive/2013/09/03/solving-session-management-database-bottlenecks-with-in-memory-oltp.aspx

PASS Summit 2013 - Get the 411 on Sessions

https://blogs.technet.com/b/dataplatforminsider/archive/2013/08/28/pass-summit-2013-get-the-411-on-sessions.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

Events/Webcasts

Microsoft Virtual Academy

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

New KB's

FIX: Database with transparent data encryption enabled is marked as "suspect" if the server certificate is dropped in SQL Server 2008 or in SQL Server 2008 R2

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

FIX: Empty or incomplete tree view is shown in the Process Progress window when you process an SSAS object in SSMS or BIDS in SQL Server 2008 R2

https://support.microsoft.com/kb/2744760/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: Access violation when you use a SQL profiler to trace an RPC event class in SQL Server 2008 or SQL Server 2008 R2

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

FIX: Master Data Explorer pane is not displayed 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

FIX: Poor performance when you run a query that uses the LIKE operator in the WHERE clause in SQL Server 2008 R2 or SQL Server 2012

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

FIX: Access violation when you run queries that use the sys.dm_server_services DMV multiple times on several UNION clauses in SQL Server 2012 or SQL Server 2008 R2

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

FIX: Query on a role-playing dimension returns incorrect results in SSAS 2008, SSAS 2012 or SSAS 2008 R2

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

FIX: The Remote Registry service crashes when an application tries to retrieve Performance Counter data from another computer

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

Technorati Tags: SQL Server