News

TPC-E – Raising the Bar in OLTP Performance

http://blogs.technet.com/b/dataplatforminsider/archive/2012/08/28/tpc-e-raising-the-bar-in-oltp-performance.aspx

Final “Be The Next Microsoft Employee” Episode Recap

http://blogs.technet.com/b/dataplatforminsider/archive/2012/08/23/final-be-the-next-microsoft-employee-episode-recap.aspx

Denny Cherry Guest Post: Get Ready for PASS Summit 2012

http://blogs.technet.com/b/dataplatforminsider/archive/2012/08/21/denny-cherry-guest-post-get-ready-for-pass-summit-2012.aspx

Save 50% on New & Top SQL Server Ebooks

http://blogs.technet.com/b/dataplatforminsider/archive/2012/08/17/save-50-on-new-amp-top-sql-server-ebooks.aspx

Premier

OpsVault — Operate and Optimize IT

http://www.opsvault.com

Microsoft Premier Support UK - Site Home - TechNet Blogs

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

SQL Server Blogs

Search - MSDN Blogs

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

MSDN Blogs

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

SQL Server Team Blog - Site Home - TechNet Blogs

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

SQL Server Security - Site Home - MSDN Blogs

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

In Recovery... | Paul S. Randal on SQL Server

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

SQL Server Storage Engine - Site Home - MSDN Blogs

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

SQL Azure Team Blog - Site Home - MSDN Blogs

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

Other

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

Events/Webcasts

Strata Conference + Hadoop World

http://strataconf.com/stratany2012

New KB's

SQL 2008 & 2008R2

Microsoft SQL Server 2008 Analysis Services: How to configure SQL Server 2008 Analysis Services and SQL Server 2005 Analysis Services to use Kerberos authentication

http://support.microsoft.com/kb/917409/en-US

Microsoft SQL Server 2008 R2 Analysis Services: FIX: An MDX query in SQL Server 2008 R2 runs very slowly if the query contains nested Crossjoin functions

http://support.microsoft.com/kb/2707185/en-US

Microsoft SQL Server 2008 R2 Analysis Services: FIX: Incorrect results when you run an MDX query in ROLAP storage mode in SQL Server 2008 R2 Analysis Services

http://support.microsoft.com/kb/2741143/en-US

Microsoft SQL Server 2008 R2 Datacenter: FIX: Access violation in SQL Server internal deadlock monitor when you run multiple applications together with Multiple Active Result Sets enabled in SQL Server 2008 R2

http://support.microsoft.com/kb/2723979/en-US

Microsoft SQL Server 2008 R2 Datacenter: FIX: "Tuning process exited unexpectedly" error message when you run Database Engine Tuning Advisor under the db_owner role in SQL Server 2008 R2

http://support.microsoft.com/kb/2728419/en-US

Microsoft SQL Server 2008 R2 Datacenter: FIX: "A system assertion check has failed" error when you re-create a nonclustered index on a column in SQL Server 2008 R2

http://support.microsoft.com/kb/2728534/en-US

Microsoft SQL Server 2008 R2 Datacenter: FIX: You cannot delete a consolidated or collection member from an entity in SQL Server 2008 R2

http://support.microsoft.com/kb/2730795/en-US

Microsoft SQL Server 2008 R2 Datacenter: FIX: Performance decreases when you run a parallel query after you upgrade from SQL Server 2008 to SQL Server 2008 R2

http://support.microsoft.com/kb/2732742/en-US

Microsoft SQL Server 2008 R2 Enterprise: SQL Server Assertion error when you try to execute a Bulk Insert or BCP statement: "<loglock.cpp>, line=807 Failed Assertion = 'result == LCK_OK' "

http://support.microsoft.com/kb/2700641/en-US

Microsoft SQL Server 2008 R2 Integration Services: FIX: Some events are missing when you run an SSIS package by using the dtexec utility (DTExec.exe) or the SQL Server Agent in SQL Server 2008 R2

http://support.microsoft.com/kb/2711189/en-US

Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010: FIX: "The syntax of the string representation of a datetime value is incorrect" error when you use SQL Server 2008 R2 PowerPivot for Excel 2010

http://support.microsoft.com/kb/2729495/en-US

Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010: FIX: "An unexpected error occurred" when you query some calculation data of an SSAS tabular model by using SQL Server 2008 R2 PowerPivot for Excel 2010 or SQL Server 2008 R2 PowerPivot for SharePoint 2010

http://support.microsoft.com/kb/2731068/en-US

Microsoft SQL Server 2008 R2 Reporting Services: FIX: KeepTogether property does not work when you generate a report that contains a Tablix in SSRS 2008 R2

http://support.microsoft.com/kb/2737499/en-US

Microsoft SQL Server 2008 R2 Service Pack 2: FIX: "Cannot get the supported data types from the database connection" error message when you use the Import and Export Data Wizard to connect to a Sybase database in SQL Server 2008 R2

http://support.microsoft.com/kb/2740507/en-US

SQL 2012

Microsoft SQL Server 2012 Business Intelligence: FIX: "out of memory" error when you use ODBC with SQL Server 2012

http://support.microsoft.com/kb/2667742/en-US

Microsoft SQL Server 2012 Business Intelligence: FIX: Access violation when you try to build a columnstore index for a table in SQL Server 2012

http://support.microsoft.com/kb/2708786/en-US

Microsoft SQL Server 2012 Business Intelligence: FIX: "Dataflow - <SSISPackageName>" error when you try to open an SSIS package in SSIS 2012

http://support.microsoft.com/kb/2713827/en-US

Microsoft SQL Server 2012 Business Intelligence: "No such interface supported" error message when you add a project to a source control in SQL Server Management Studio 2012

http://support.microsoft.com/kb/2727824/en-US

Microsoft SQL Server 2012 Business Intelligence: FIX: Incorrect email priority if you set the SSRS email subscription priority to Low or Normal in SSRS 2012

http://support.microsoft.com/kb/2731402/en-US

Microsoft SQL Server 2012 Developer: "A severe error occurred on the current command" error when you run a full-text query that has the CONTAINS predicate in SQL Server 2012

http://support.microsoft.com/kb/2709075/en-US

Microsoft SQL Server 2012 Developer: FIX: "No object exists with a lineage ID" error message when you run an SSIS 2012 package

http://support.microsoft.com/kb/2714937/en-US

Microsoft SQL Server 2012 Developer: "DQS Cleansing failed the pre-execute phase" error when you run the DQS Cleansing transformation in SQL Server 2012

http://support.microsoft.com/kb/2715968/en-US

Microsoft SQL Server 2012 Developer: FIX: SQL Server Agent logs verbose logs in the Application log when you start a SQL Server 2012 failover cluster instance

http://support.microsoft.com/kb/2718920/en-US

Microsoft SQL Server 2012 Developer: FIX: Slow performance or deadlock when you restore a database and execute statements at the same time in SQL Server 2012

http://support.microsoft.com/kb/2725950/en-US

Microsoft SQL Server 2012 Developer: FIX: You cannot install a SQL Server 2012 cluster instance on a Server Core operating system that contains an existing cluster instance

http://support.microsoft.com/kb/2727221/en-US

Microsoft SQL Server 2012 Developer: Description of Microsoft StreamInsight 2.1

http://support.microsoft.com/kb/2731961/en-US

Microsoft SQL Server 2012 Developer: FIX: SQL Server is slow or an "Out-Of-Memory" error occurs when you run a query with nested IF statements on DAX measures in SQL Server 2012

http://support.microsoft.com/kb/2733091/en-US

Microsoft SQL Server 2012 Developer: FIX: "FOR UPDATE clause allowed only for DECLARE CURSOR" error when you execute stored procedures together with cursor-specific syntax in SQL Server 2012

http://support.microsoft.com/kb/2740957/en-US

Microsoft SQL Server 2012 Enterprise: FIX: "Failure sending mail" error when you create a subscription to deliver an RDL report whose file name contains non-Latin characters in SSRS 2012

http://support.microsoft.com/kb/2725256/en-US

Microsoft SQL Server 2012 Enterprise: FIX: Execution of a package ends unexpectedly and status is "Canceled" when you execute many SSIS 2012 packages in parallel

http://support.microsoft.com/kb/2735763/en-US