Inspari Hubspot Leads

Output row values effected by an update

Have you ever thought about logging the before and after value for an update or delete? It’s...

Updateable views

By default view are updateable. It means you can write a TSQL update statement against a view...

Avoid schema changes corrupting your views

Maybe you are using views as a layer between your tables and your users. If you have a lot of...

From PowerPivot to Tabular Part1

In this series of blog posts I will show you how to create PowerPivot model, how to convert it...

From PowerPivot to Tabular Part2

In this series of blog posts, I will show you how to create a PowerPivot model, how to convert...

FileTables in SQL Server 2012

SQL Server 2008 gave us filestreams. Filestream saves files on the disk instead of using BLOB’s....

QlikView – how many records can you have in a document?

Triggered by a discussion last week, I just had to test how many records that could be stored in...

QlikView Charts with use of bar offset

The use of bar offset gives you the possibility easily to make new types of bar charts. Among...

QlikView Meta data

Meta data in QlikView is much more than just comments of how a measure is calculated. In a...

Change data capture in SSIS SQL Server 2012

SQL Server 2012 gives us some new SSIS components that make reading from the CDC tables created...