Category Archives: BI

Get a taste on the cloud: MS Azure Free Trial

Continuing with the inevitable move to the sky, and trying to self-quote myself here (well, self-post actually), I’m back to tell you that you can have one month of free experimentation with all Azure platform for free. You can set-up … Continue reading

Posted in Azure, BI, Cloud, SQLServer, Windows | Tagged , , , , , , | Leave a comment

SQL Server: ranking your data

This is the kind of query that kills some servers – ranking. It’s a bit hard to make programmers understand how important the performance of their code can have a big impact on server speed – they all seems to … Continue reading

Posted in BI, MongoDB, MySQL, Oracle, SQLServer | Tagged , , , , , | Leave a comment

Some fancy BI stuff: SSIS training, Data Tools add-ins and BIML academy

A few days ago I posted a link to one BIML introduction webcast. Now I now it will be a series of webcasts this week, it’s a great oportunity to learn more about it! Stay tuned and subscribe to the … Continue reading

Posted in BI, SQLServer | Tagged , , , , | Leave a comment

SSIS / Data Tools compatibility between 2014 and 2012

Well, to be simple: there is no backwards compatibility when you create a package in SQL Server 2014 Data Tools (formerly SSIS/BIDS). 2014 files only run on 2014 servers. 2012 on 2012, and that’s it. Microsoft acknowledge this issue but … Continue reading

Posted in BI, SQLServer | Tagged , , , | Leave a comment

BIML first steps

BIML stands for Business Intelligence Markup Language. It adds some things on top of SSIS (SQL Server Integration Services, now called SQL Data Tools,¬†or BI Development Studio, or even DTS – Microsoft should really make up their mind and stop … Continue reading

Posted in BI, SQLServer | Tagged , , , , , , | Leave a comment