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 […]
This just got in: Second shot is back! You can now retake your exam for free, until jan 12 2016. Yay! Go get ’em… More info here
If either you are doing your SSIS by hand or using the BIML framework, you’ve came across the expressions and the expression-builder. This is a helper list, with my most often used, and wich are allways forgotten when I need them, of my commonly used SSIS expressions.
Guess what. I just got 15.000 new collegues. Rehfeld Partners is to be acquired by IMS Health. IMS Health is a leading global information and technology services company, with more than 60 years experience, providing clients in the healthcare industry with comprehensive solutions to measure and improve their performance.
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.
In these times of datawarehouse automation and fast track SSIS, BIML has become a huge contributor to my daily work. On one of my most recent projects we had a custom script task that we needed to implement in the same package several times.
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?
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.
On several occasions I’ve been assigned the task to split a delimited string into rows. I’ve done this in different ways, but never thought about the performance or stability of the different approaches for doing this. So here’s my 25 cents and findings.
With a little push from some of my colleagues, I have submitted a speaksersession to SQL Saturday in Copenhagen and Edinburgh. To my big surprise both sessions (with the same subject) was chosen as a part of the sessions to be held. I’m very excited and thrilled that these possibilities was given to me.