Tag Archives: BIDS

SQL Server 2016 Management Studio Download

Posted on November 1, 2016 by mauriciorpp

It’s that time of the year. No, I’m not talking about christmas, I’m talking about new product cycles from Microsoft. For SQL Server it usually happens on even years, it’s 2016 so this year we have a new SQL Version. … Continue reading →

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

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

Posted on May 11, 2016 by mauriciorpp

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

Posted on May 2, 2016 by mauriciorpp

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

Posted on April 26, 2016 by mauriciorpp

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

SSIS: Integration Packages on 64bits

Posted on May 2, 2013 by mauriciorpp

And so I’m back to designing SSIS packages. Its a fun activity really. SQL Server Integration Services is a really powerfull platform to move data around. It can read anything and write anywhere (and even if it can’t directly access … Continue reading →

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

Choosing between SSMS Express and SSMS with Advanced Services

Posted on September 28, 2012 by mauriciorpp

So thats it. I could not make a new post for over one week. This is off my target, I want to share something at least once every week. So here we go for some quick posts, and I will … Continue reading →

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