FIX: Corruption occurs on pages of secondary replica when you change the secondary replica to unreadable
sql server 2012 sp2 cu5 is out – https://support.microsoft.com/en-us/kb/3037255
FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING
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.
FIX: Data Alerts tables are filled up and never be cleared old data when you use alerts for SSRS 2012 reports
FIX: Error 4360 when you restore the backup of secondary replica to another server in AlwaysOn Availability Groups
FIX: “Access Denied” error occurs when you run an XML validation task in SSIS 2012
FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application
FIX: Access violation may occur when you run a query against the sys.dm_exec_procedure_stats DMV joined on plan_handle
FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012
FIX: Access violation and “No exceptions should be raised by this code” error occur when you use SQL Server 2012
FIX: SQL Server 2012 shuts down unexpectedly when you run DBCC CHECKDB and the rollback recovery on the snapshot fails
DBA Survivor – Become a Rockstar DBA .
All DMVs are under sys schema.
Wait stats for memory
Wait stats for CPU
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
Just found this on Memory Error Recovery in SQL Server 2012 – http://www.sqlskills.com/blogs/glenn/memory-error-recovery-in-sql-server-2012/