SQL Server 2012 AlwaysOn Availability Groups corruption issue

Posted: May 21, 2015 | Author: | Filed under: Microsoft SQL Server 2012 | Tags: | Leave a comment

http://support2.microsoft.com/kb/3054530/en-us?sd=rss&spid=16139

FIX: Corruption occurs on pages of secondary replica when you change the secondary replica to unreadable

sql server 2012 sp2 cu5 is out

Posted: March 24, 2015 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server 2012 | Tags: , | Leave a comment

sql server 2012 sp2 cu5 is out – https://support.microsoft.com/en-us/kb/3037255

FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING

https://support.microsoft.com/kb/3034679

FIX: Complex parallel query does not respond in SQL Server 2012

When starvation of worker threads occurs, a specific wait between worker threads is not treated as a potential blocker. Therefore, the deadlock monitor does not detect the condition.

https://support.microsoft.com/en-us/kb/3037624

FIX: Data Alerts tables are filled up and never be cleared old data when you use alerts for SSRS 2012 reports

https://support.microsoft.com/kb/3038332

FIX: Error 4360 when you restore the backup of secondary replica to another server in AlwaysOn Availability Groups

https://support.microsoft.com/kb/3038943

FIX: “Access Denied” error occurs when you run an XML validation task in SSIS 2012

https://support.microsoft.com/kb/3040804

FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application

https://support.microsoft.com/kb/3041859

FIX: Access violation may occur when you run a query against the sys.dm_exec_procedure_stats DMV joined on plan_handle

https://support.microsoft.com/kb/3042007

FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012

https://support.microsoft.com/kb/3042077

FIX: Access violation and “No exceptions should be raised by this code” error occur when you use SQL Server 2012

https://support.microsoft.com/kb/3042135

FIX: SQL Server 2012 shuts down unexpectedly when you run DBCC CHECKDB and the rollback recovery on the snapshot fails

https://support.microsoft.com/kb/3044958

Advertisement

Currently reading…

Posted: July 28, 2014 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server 2012, Microsoft SQL Server 2014 | Leave a comment

 

DBA Survivor – Become a Rockstar DBA .

http://msdn.microsoft.com/en-us/library/ms191246(v=sql.120).aspx

All DMVs are under sys schema.

http://msdn.microsoft.com/en-us/library/ms188754.aspx

http://msdn.microsoft.com/en-us/library/ms179984.aspx

Wait stats for memory

– CMEMTHREAD

– LATCH_*

– LCM_M_*

– LOWFAIL_MEMMGR_QUEUE

– RESOURCE_SEMAPHORE_*

– UTIL_PAGE_ALLOC

Wait stats for CPU

– CXPACKET

– EXCHANGE

– EXECSYNC

SQL Profile

http://msdn.microsoft.com/en-us/library/ms175481.aspx

http://msdn.microsoft.com/en-us/library/ms190762.aspx

http://msdn.microsoft.com/en-us/library/ms190793.aspx

 

SQL Server 2012 Tabular Data Model

Posted: July 22, 2014 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server 2012, Microsoft SQL Server 2014 | Leave a comment

Documented at http://msdn.microsoft.com/en-us/library/hh212945.aspx

Securing the Tabular BI Semantic Model whitepaper http://msdn.microsoft.com/en-us/library/jj127437.aspx

Securing your tabular model http://blogs.msdn.com/b/cathyk/archive/2011/11/21/securing-your-tabular-model.aspx

Getting started with Tabular Model in SQL Server 2012 http://www.mssqltips.com/sqlservertip/2821/getting-started-with-tabular-model-in-sql-server-2012–part-1/

Roles (SSAS Tabular) http://msdn.microsoft.com/en-us/library/hh213165.aspx – includes row filters and dynamic security.

Perspectives – like views http://msdn.microsoft.com/en-us/library/hh230816%28v=sql.110%29.aspx

BISM – Tabular Security Model http://paultebraak.wordpress.com/2011/09/04/bism-%E2%80%93-tabular-security-model – more on row filters.

Implement Dynamic Security by Using Row Filters http://msdn.microsoft.com/en-us/library/hh479759%28v=SQL.110%29.aspx

(DMV Question)
https://www.linkedin.com/groups/Is-there-DMV-find-all-66097.S.5895157457688211456?view=&item=5895157457688211456&type=member&gid=66097&trk=eml-b2_anet_digest-group_discussions-8-grouppost-disc-0&midToken=AQH48zvduqwTWw&fromEmail=fromEmail&ut=0zOeU5w-MNxCk1

Data Compression & TDE

Posted: April 12, 2014 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server 2012, Microsoft SQL Server 2014 | Leave a comment

 

http://social.msdn.microsoft.com/forums/sqlserver/en-US/0650314c-6fda-4858-b667-90b0a06e1865/data-compression-tde

SQL Server 2012 Memory Error Recovery.

Posted: August 27, 2013 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server 2012 | Tags: , | Leave a comment

Just found this on Memory Error Recovery in SQL Server 2012 – http://www.sqlskills.com/blogs/glenn/memory-error-recovery-in-sql-server-2012/