BIML

Enlarge AdventureWorksDW2012

Posted on

Just recently I had to have a big datawarehouse solution to test some performance optimization using BIML. I could use the AdventureWorks2012 database, but I needed the clean datawarehouse tables in order to have minimum data maintennance when testing the BIML scripts. I could not find it, and figures out it was faster to make my own. So heavily inspired by this post from Jonathan Kehayias (blog), I’ve made a script that can be used to enlarge the dbo.FactInternetSales table. The script creates a new table called dbo.FactInternetSalesEnlarged and copies data from dbo.FactInternetSales into it with a randomizer. Exploding the […]

BIML

Fully automate the BIML expansion

Posted on

With all the BIML code done and the production scenarios start to emerge, it would be great to have the BIML code automatic expanded and create new packages if there are changes to the underlying metadata. Either configured manually or directly from the sources. With the MIST application from Varigence – this is possible through the command line util that ships with the installation.

Ikke kategoriseret

Install SQL Server in 5 mins

Posted on

You know this everybody – you need to install a whole new SQL Server on the customers Windows Server. And the customer doesn’t have the time or money to wait for you to click around the GUI and sit around and watch the progress-bar move every second. So why not do this in a fully automatic way and in the same time save both effort and expensive time doing so?

Development

Power Query – October 2014 update

Posted on

The Power Query tool has just been updated and there are some pretty neat features rolled out: New Transfomation: Use Headers as First Row. Column Name field in Merge Columns dialog. Quick Access Toolbar in Query Editor dialog. Warning for stale data previews in new queries. Function Invocation from Search. Preserve Excel Number formats in the worksheet on query refresh.