Technical RollUp

Premier Field Engineering - Technical Rollup Mails

May 2013 – Technical Rollup Mail – SQL Server

May 2013 – Technical Rollup Mail – SQL Server

  • Comments 1
  • Likes

 

 

 

News

Leveraging Flash across the Microsoft SQL Server Stack

http://blogs.technet.com/b/dataplatforminsider/archive/2013/05/01/leveraging-flash-across-the-microsoft-sql-server-stack.aspx

Viewing and Integrating with SSRS Reports on an iPad

http://blogs.technet.com/b/dataplatforminsider/archive/2013/04/26/viewing-and-interacting-with-ssrs-reports-on-an-ipad.aspx

Insight Through Integration: SQL Server Parallel Data Warehouse

http://blogs.technet.com/b/dataplatforminsider/archive/2013/04/25/insight-through-integration-sql-server-2012-parallel-data-warehouse-polybase-demo.aspx

PASS Business Analytics Conference

http://blogs.technet.com/b/dataplatforminsider/archive/2013/04/22/let-s-call-it-a-wrap-on-the-pass-business-analytics-conference.aspx

Develop and Test New SQL Server Apps, Scale Existing Apps

http://blogs.technet.com/b/dataplatforminsider/archive/2013/04/16/develop-and-test-new-sql-server-apps-scale-existing-apps-and-unlock-hybrid-scenarios-with-windows-azure-infrastructure-services.aspx

Premier

OpsVault — Operate and Optimize IT

http://www.opsvault.com

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/

Paul S. Randal - In Recovery...

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

SQL Server Storage Engine - Site Home - MSDN Blogs

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

SQL Azure

SQL Azure Team Blog - Site Home - MSDN Blogs

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

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

New KB's

Troubleshooting AlwaysOn availability group listener creation in SQL Server 2012

http://support.microsoft.com/kb/2829783/EN-US

How to troubleshoot the "Cannot generate SSPI context" error message

http://support.microsoft.com/kb/811889/EN-US

How to use Kerberos authentication in SQL Server

http://support.microsoft.com/kb/319723/EN-US

FIX: Merge replication changes are missing on a SQL Server subscriber when they subscribe to a partition in SQL Server 2008 R2 or in SQL Server 2012

http://support.microsoft.com/kb/2644396/EN-US

"Validating WSFC quorum vote configuration" warning when you create an AlwaysOn availability group in SQL Server 2012

http://support.microsoft.com/kb/2833122/EN-US

Using SQL Server in Windows 8 and Windows Server 2012 environments

http://support.microsoft.com/kb/2681562/EN-US

Enable plan-affecting SQL Server query optimizer behavior that can be controlled by different trace flags on a specific-query level

http://support.microsoft.com/kb/2801413/EN-US

You may experience connectivity issues to SQL Server if SPNs are misconfigured

http://support.microsoft.com/kb/2443457/EN-US

How to enable Trace Logging in SQL Server 2008 R2 and 2012 Master Data Services

http://support.microsoft.com/kb/2423478/EN-US

Database file names change when you restore a database by using the WITH REPLACE option in SQL Server 2012

http://support.microsoft.com/kb/2839722/EN-US

"A system assertion check has failed" error message when you execute a CREATE PARTITION FUNCTION statement in SQL Server 2008 R2

http://support.microsoft.com/kb/2813697/EN-US

FIX: Incorrect result is returned when you query an indexed view by using the NOEXPAND hint in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012

http://support.microsoft.com/kb/2756471/EN-US

FIX: Business rule does not work when a member code contains special characters in MDS in SQL Server 2012

http://support.microsoft.com/kb/2819383/EN-US

SQL Server 2012 performance issues in NUMA environments

http://support.microsoft.com/kb/2819662/EN-US

FIX: A PowerPivot workbook cannot connect to data source and load data when a PowerPivot server of a SharePoint farm is unavailable

http://support.microsoft.com/kb/2760981/EN-US

FIX: "Failed Assertion = 'CheckValidInput (wsName, cbName)'" error when you use database mirroring in Microsoft SQL Server 2008 R2

http://support.microsoft.com/kb/2802113/EN-US

FIX: Access violation when you put a FILESTREAM-enabled database offline in SQL Server 2008 R2 or in SQL Server 2012

http://support.microsoft.com/kb/2800013/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

http://support.microsoft.com/kb/2800797/EN-US

FIX: Heap corruption occurs when an MDX error message is generated in SSAS 2008, SSAS 2008 R2 or SSAS 2012

http://support.microsoft.com/kb/2809431/EN-US

FIX: High memory usage or OOM error when you run an MDX query in SSAS 2008 R2 or in SSAS 2012 that uses the INT function

http://support.microsoft.com/kb/2809339/EN-US

FIX: Access violation when you restore transaction log backups in a SQL Server 2008 R2-based or SQL Server 2012-based log shipping environment

http://support.microsoft.com/kb/2806244/EN-US

FIX: Session deadlock occurs when you use an Analysis Services personalization extension in SSAS 2008 R2 or in SSAS 2012

http://support.microsoft.com/kb/2794260/EN-US

FIX: Data corruption occurs when LOB data is loaded into a Transact-SQL variable in SQL Server 2008 R2, SQL Server 2012 or SQL Server 2008

http://support.microsoft.com/kb/2803994/EN-US

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

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

2821783 FIX: Out-of-memory errors related to a memory clerk in SQL Server 2012

http://support.microsoft.com/kb/2821783/EN-US

Troubleshooting automatic failover problems in SQL Server 2012 AlwaysOn environments

http://support.microsoft.com/kb/2833707/EN-US

You receive a "Warning SuperSocket Info" warning information when a SQL Server service account is a domain user

http://support.microsoft.com/kb/303411/EN-US

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

http://support.microsoft.com/kb/959032/EN-US

FIX: Incorrect result when you run an MDX query that returns multiple calculated members in SSAS 2008, SSAS 2012 or SSAS 2008 R2

http://support.microsoft.com/kb/2821836/EN-US

FIX: SSAS 2012 freezes when a scheduled data update starts while you run complex DAX queries

http://support.microsoft.com/kb/2821686/EN-US

FIX: CPU spike when there is no load on a server after you install SQL Server 2012 on the server

http://support.microsoft.com/kb/2813214/EN-US

FIX: Poor performance when you run a query against an RCSI-enabled table in SQL Server 2012

http://support.microsoft.com/kb/2806979/EN-US

FIX: Access violation or incorrect result when you insert data into or update a new partition of a partitioned table in SQL Server 2008 R2, SQL Server 2012 or SQL Server 2008

http://support.microsoft.com/kb/2504090/EN-US

FIX: Security token leak when you run more than two PowerShell steps by using a proxy account in a SQL Server Agent job

http://support.microsoft.com/kb/2791496/EN-US

FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2

http://support.microsoft.com/kb/2618676/EN-US

FIX: Error when you run the sp_cursoropen stored procedure together with the scrollopt argument in SQL Server 2008 R2

http://support.microsoft.com/kb/2819446/EN-US

This content is for informational purposes only. Microsoft makes no warranties express or implied, as to the information in this document. If you are a customer of Microsoft, please refer to the terms and conditions which cover the provision of support and consulting services to you/your organization.  If you are not corresponding in the course of, or in connection with a Microsoft contract or program with its own terms and conditions, please note that no liability is accepted by Microsoft for the contents of this document. 

TRM contributor this month was Glen Small.

This message from Microsoft is an important part of a programme, service, or product that you or your company have purchased or participate in. Microsoft respects your privacy. Please read our Privacy Statement

clip_image004

Comments
  • Do you know if the fix for 2809339 also included the "FIX" function?  I am having a similar problem, but with FIX() not INT()

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment