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)


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

Informix 12.10.xC4 is out!

Informix 12.10.xC4 is out! Limit session locks and use multi-tenant databases!

SQL Supper 22nd April 2014 Questions.

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

Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer)

Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer)

Buy from Amazon

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:

USE [master]

/****** Object:  ResourcePool [PoolAdmin]    Script Date: 05/05/2014 10:17:42 ******/
CREATE RESOURCE POOL [PoolAdmin] WITH(min_cpu_percent=0,


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

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).


London SQL Supper 22nd April 2014 slides.

The slides for my talk at London SQL Supper 22nd April 2014 are at http://www.smooth1.co.uk/sqlserver2014/2014NewFeatures.zip

Informix FAQ

Informix FAQ

The Informix FAQ is back! v1.25


Get every new post delivered to your Inbox.