Currently reading…

 

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

 

Advertisements

SQL Server 2012 Tabular Data Model

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


SQL Server 2014 Buffer Pool Extension onto SSD.

SQL Server 2014 Buffer Pool Extension onto SSD – http://www.smooth1.co.uk/sqlserver2014/bpe_ssd.html