Tag Archives: ETL

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

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