QlikView - Loading images into memory
Images in a QlikView application can be power full in many ways. Most of the time I see solutions...
Using table variables in a SSIS data source
Every now and then standard queries just aren’t sufficient as data sources and therefore it might...
QlikView tape recorder functionality
Try to visualize your old tape recorder. If you are old enough, you might remember the forward...
Special characters in SSAS Name properties
Have you ever got the request to use special characters, like ( ) / & %, in the names of your...
Throw your server off balance
…Balanced Power Plan that is
Caring about nature is most certainly a likable trait. But did you...
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 just...
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 views...
dbcc checkdb
Almost every one of my customers is running a backup of their databases (you would be surprised if...
From PowerPivot to Tabular Part1
In this series of blog posts I will show you how to create PowerPivot model, how to convert it to...
From PowerPivot to Tabular Part2
In this series of blog posts, I will show you how to create a PowerPivot model, how to convert it...
FileTables in SQL Server 2012
SQL Server 2008 gave us filestreams. Filestream saves files on the disk instead of using BLOB’s....
Gartner Magic Quadrant - Visual Analysis
Modern BI tools can be used for more than just adding numbers. The best of the tools can really...
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 them...