April 2013 - Technical Roll-up Mail – SQL Server
News
SQL Server 2012 Common Criteria Certification
Day 1: PASS Business Analytics Conference, The Art of Analytics
Premier
OpsVault — Operate and Optimize IT
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§ions=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/
https://blogs.technet.com/trm/default.aspx
New KB's
FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005 or in SQL Server 2008
https://support.microsoft.com/kb/959032/EN-US
FIX: Errors when a client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2
https://support.microsoft.com/kb/2543687/EN-US
You may experience connectivity issues to SQL Server if SPNs are misconfigured
https://support.microsoft.com/kb/2443457/EN-US
FIX: Access violation when you put a FILESTREAM-enabled database offline in SQL Server 2008 R2 or in SQL Server 2012
https://support.microsoft.com/kb/2800013/EN-US
FIX: Data corruption occurs when LOB data is loaded into a Transact-SQL variable in SQL Server 2008 R2 or in SQL Server 2008
https://support.microsoft.com/kb/2803994/EN-US
FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008 or in SQL Server 2012
https://support.microsoft.com/kb/2791745/EN-US
FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2 or in SQL Server 2012
https://support.microsoft.com/kb/2803799/EN-US
FIX: Poor performance in SQL Server 2012 when you run a SQL Server trace
https://support.microsoft.com/kb/2803529/EN-US
FIX: Incorrect results when you run a FULL JOIN query that uses the CROSS APPLY clause in SQL Server 2008 R2 or in SQL Server 2012
https://support.microsoft.com/kb/2800797/EN-US
FIX: CPU spike when there is no load on a server after you install SQL Server 2012 on the server
https://support.microsoft.com/kb/2813214/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
Technorati Tags: sql server,sql