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
SQL Server 2014 Buffer Pool Extension onto SSD – http://www.smooth1.co.uk/sqlserver2014/bpe_ssd.html
Informix 12.10.xC4 is out! http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.po.doc/new_features_ce.htm … Limit session locks and use multi-tenant databases!
1. To install SQL Server 2014 documentation locally?
SSMS -> Help -> Manage Help Settings -> Help Library Manager then choose Install Content from online
Under SQL Server 2014 Add Books Online, Developer Reference and Installation.
You can also check for updates online as well.
2. What is new in SQL Server 2014 Integration Services?
As per books online nothing! However Professional Microsoft SQL Server 2014 Integration Services
does mention 2014 enhancements although it says they are from codeplex and not integrated into the base product yet.
3. What is new in Report Services?
Books Online only mentioned addition of support for Chrome as a browser!
4. What T-SQL enhancements are there in 2014?
This is covered at http://www.smooth1.co.uk/sqlserver2014/t_sql_enhancements.html
5. Resource Governor for physical IO, the IO settings do not appear in SSMS.
If you run ‘script resource pool as’ the settings are visible:
/****** Object: ResourcePool [PoolAdmin] Script Date: 05/05/2014 10:17:42 ******/
CREATE RESOURCE POOL [PoolAdmin] WITH(min_cpu_percent=0,
AFFINITY SCHEDULER = AUTO
I have mail Mark Souza (General Manager -Data Platform Group) for an update when these will appear in the properties page.
IBM Informix on POWER7 White paper – https://www.ibm.com/developerworks/community/wikis/home?lang=en-us#!/wiki/W6461741bf7e8_47d7_89fc_a0a9233f3ca9/page/IBM%20Informix%20on%20POWER7 (from Fernando Nunes).
The slides for my talk at London SQL Supper 22nd April 2014 are at http://www.smooth1.co.uk/sqlserver2014/2014NewFeatures.zip