Currently reading…
Posted: July 28, 2014 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 Filed under: Microsoft SQL Server, Microsoft SQL Server 2012, Microsoft SQL Server 2014 Leave a commentDocumented 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
SQL Server 2014 Buffer Pool Extension onto SSD.
Posted: July 6, 2014 Filed under: Microsoft SQL Server, Microsoft SQL Server 2014 Leave a commentSQL Server 2014 Buffer Pool Extension onto SSD – http://www.smooth1.co.uk/sqlserver2014/bpe_ssd.html