This site is published by Paul Turley and is based upon my opinions and perspectives.  These are not the opinions or responsibililty of my employer, Microsoft or any other vendor, my associates, clients, family, friends, my dog or anybody else.  If I’m right, I’m right and if I’m wrong, I’m wrong.  Please don’t make any critical business decisions or change the course of any life-altering events based upon what you read on my blog.  To do so would be really dumb and I can’t accept responsibility for it.

If you have a differing opinon or  if you think any information I have posted is wrong or unclear, you are welcome and encouraged to respond in a respectful and professional manner to comment, provide feedback and to contribute for the benefit of the community.  At my descretion, I will allow or remove comments.  If you are trying to sell something, please go away.  Otherwise, you are welcome to return and visit often.

Contact me

Paul’s Bio

13 thoughts on “About

  1. I was wondering what your take is on Dan Linstead’s “Data Vault” approach as opposed to Kimball’s DW approach? It seems sensible to me, but I don’t have enough experience with either to make an informed decision as to when I would something like that.


    • I am familiar with the concept of the data vault and I think it addresses some important needs. I had a client who shifted gears and went down that path after architecting the first phase of their EDW and realized it didn’t address all their reporting needs. There are different data warehouse philosophies that exist for good reason, many of which are driven by specific businesses or industry requirements like auditing and historical tracking. In some solutions, it makes sense to collect snapshots of source data into a staging area or operational data store – sort pf a dumping ground so you can see the business state as it was at a point in time. The operational store might be separate from the data warehouse or it might be an integral component of the warehouse. But, again it depends on the business needs. Kimball’s notion of a “single version of the truth”, a principle I strongly believe in and promote, makes sense as long as everyone can agree on a version of the truth. Otherwise, we have to contend with what the truth WAS, IS and might be in the future – which, as I understand it, is the point of the data vault. So, we may potentially be talking about three different data stores: the ODS, EDW and dimensional data mart. Doing analytics over modern big data stores introduce the same basic problem if making order out of chaos.
      There is often a difference between a data warehouse and a dimensional data mart. Back to my original point in this post; ideally, if the data mart exists as a star/snowflake schema, that solves the problem of non-conformity in the semantic model (again, talking about SSAS) as opposed to going directly to the source or a non-conformed copy of the source data. One way or another, the data must be conformed to work in a model.


  2. Hi Paul,

    I was wondering if you know of a way to get rid of blank spaces/lines between two nested tables. Re-sizing the nested/child tablix within a main tablix to .06, the smallest value it can have, still leave about a line of space and a solid line between the records within the main tablix.

    Thank you for your help. I wanted to buy your SSRS Recipes book, but it is out of print.


    • HB
      If you could put together a simple example and upload to a public file share (e.g. OneDrive, DropBox, etc.), I’d be happy to take a look. Just reply and send a link.

      The recipes book is available in the Kindle edition which is what may people prefer now. Many publishers are moving to e-book only editions after the initial print book sales.


  3. Hi Paul!

    I need to do a migration from ssas traditional model to the tabular model, Where can I download or buy the solidq migration tool?

    Thank you


  4. I’m working through SQL 2012 Reporting Services, Could you direct me to how to restore the Adventure Works DW Multidimensional ABF file download (for examples in Chapters 6 & 7)?
    I’m using SQL 2012 Developer


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s