Hvad betyder kvadranten for dit valg af BI-tool?
Så kom den årlige opdatering af branchens væsentligste vurdering af softwareleverandører, nemlig...
Posts om
microsoft power bi (2)
Endelig kom opdateringen af MS reporting services - læs dommen her!
Microsoft SQL Server Reporting Services har fået en overhaling. Spørgsmålet er, om vi kunne have...
Enrich your Data Warehouse dimensions
As a Data Warehouse Consultant, I´m often asked the following by customers: “Is it possible to...
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...
Special characters in SSAS Name properties
Have you ever got the request to use special characters, like ( ) / & %, in the names of your...
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...
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....
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 by...
New string conversion functions
SQL Server 2012 contains two new string conversion functions. PARSE and TRY_PARSE. These two...