Andreas De Ruiter's BI blog
Best practices on designing business intelligence solutions using SSAS, SSIS and other Microsoft BI tools
Creating a security-enabled AngularJS application with ASP.NET MVC the easy way (tutorial)
In recent years Single Page Applications (SPAs) have become popular and there are plenty JavaScript...
Author: Andreas de Ruiter (Microsoft) Date: 01/06/2016
Transforming data in a data warehouse through SQL views
This post is an add on to the another post titled Designing an ETL process with SSIS: two approaches...
Author: Andreas de Ruiter (Microsoft) Date: 04/20/2015
How to rename data columns in Azure ML programmatically
In Azure ML you usually rename columns using the Metadata Editor component. This works well in...
Author: Andreas de Ruiter (Microsoft) Date: 03/10/2015
Azure ML now supports Python scripts
Update 2/19/2015: Microsoft has now officially announced general availability of Azure Machine...
Author: Andreas de Ruiter (Microsoft) Date: 02/16/2015
Troubleshooting “Error 1000: RPackage library exception: Failed to convert RObject to DataSet” when running R scripts in Azure ML
I’ve recently started experimenting with Azure ML and while I find this technology – which currently...
Author: aaaab Date: 02/03/2015
Loading daily gold prices into Azure ML
Technorati Tags: Azure ML Want to load daily gold prices into Azure ML? Here’s one way to do...
Author: aaaab Date: 01/28/2015
Tracking changes to tables in your data warehouse using snapshot-based versioning
Today I will explain a way to track historic changes in a data warehouse and share a little program...
Author: Andreas de Ruiter (Microsoft) Date: 03/19/2013
SSMS 2012 freezes when being launched
I just spent 30 minutes on SSMS which hanged on me every time I tried to launch it. I searched the...
Author: Andreas de Ruiter (Microsoft) Date: 12/18/2012
Should you use a data warehouse with a tabular cube?
With SQL Server 2012, Microsoft introduced SSAS “tabular mode”. Tabular mode essentially is a...
Author: Andreas de Ruiter (Microsoft) Date: 12/10/2012
Designing an ETL process with SSIS: two approaches to extracting and transforming data
On the Internet you find a lot of articles explaining the concepts like the data warehouse and ETL....
Author: Andreas de Ruiter (Microsoft) Date: 12/05/2012