September - Technical Rollup Mail - SQL
News
TPC-E – Raising the Bar in OLTP Performance
Final “Be The Next Microsoft Employee” Episode Recap
Denny Cherry Guest Post: Get Ready for PASS Summit 2012
Save 50% on New & Top SQL Server Ebooks
Premier
OpsVault — Operate and Optimize IT
Microsoft Premier Support UK - Site Home - 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/
In Recovery... | Paul S. Randal on SQL Server
https://www.sqlskills.com/blogs/paul/
SQL Server Storage Engine - Site Home - MSDN Blogs
https://blogs.msdn.com/b/sqlserverstorageengine/
SQL Azure Team Blog - Site Home - MSDN Blogs
https://blogs.msdn.com/b/sqlazure/
Other
https://blogs.technet.com/trm/default.aspx
Events/Webcasts
Strata Conference + Hadoop World
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://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' "
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://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
https://support.microsoft.com/kb/2727221/en-US
Microsoft SQL Server 2012 Developer: Description of Microsoft StreamInsight 2.1
https://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
https://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
https://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
https://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