A workaround to use Power Query with SSIS Script Task

M is quite a nice language for Self Service ETL. The logical next step would be to include the Power Query functionality as a component in SSIS. As of now there is just the following Workaround. (Which is btw not supported but works quite well.) Create an Excel Workbook that contains the M-query and loads

SQL 2012 Operations Research – Simulated Annealing implemented in T-SQL can cut CO² Emission / Traveltime and Cost by more than 30%

Many organizations face combinational problems. Our service division has a quite interesting one. The assignment of engineers to customer workshops. The following screenshot illustrates the issue. (planned Workshop Travel EMEA subset of data) Assume Microsoft would just employ 2 engineers and would be asked to deliver 3 workshops (W1,W2,W3). Lets assume all engineers are skilled

Reporting Services Data Driven Subscriptions with Multi Value Parameters

To send a parameterized report to a list of subscribers we can use the Data Driven Subscription.   If the WHERE condition in the Report Dataset just contains single parameter values (something like: Select * From Sales where Department = 123)  the setup is fairly simple. (There is already a documentation on how to achieve that:

Data Explorer and Power View to analyse Stock Market Insider Trades

Boardmembers of market-listed corporations are liable to publish their share transactions. You can lookup these announcements at msn.com-> http://investing.money.msn.com/investments/insider-transactions?symbol=MSFT  Yet it was quite difficult to extract all the data directly from the website. Now with the new Data Explorer it just takes a few minutes to download all the information to excel and do exciting analysis. Here is an example: The following chart