I use columnstore indexes on SQL 2014. What would be the advantages of upgrading to SQL 2016?

I use columnstore indexes on SQL 2014. What would be the advantages of upgrading to SQL 2016?

SQL Server 2016 really represents a drastic change for the better in regards to general performance. And the proof is that, thanks to the engine changes, this is the first SQL Server version where Microsoft actively provides a widespread increase in performance levels by simply upgrading. But what impact can it have in your daily loads if you use columnstore indexes in SQL server 2014 datawarehouse? There was already an amazing increase in performance levels with SQL Server 2014 and the columnstore indexes. Is it worth upgrading to SQL 2016? (more…)

Generating SSIS Packages Programmatically (Part I)

Generating SSIS Packages Programmatically (Part I)

Taking into account the projects we carry out, Advanced Business Intelligence (BI) consulting is one of the most in-demand jobs, as stated in some digital newspapers, including Finanzas.com. Therefore, having powerful tools that are simple and adaptable to our changing requirements will mean an increase in the quality of our services. Solid Quality Mentors is considered the leader of global solutions for the entire Microsoft Data Platform, which provides us and others the tool SQL Server Integration Services (SSIS), which is the subject of this article. BI projects inevitably require the consolidation of efficient information. Since such consolidation is achieved through SSIS, and its design is personalized as potentially “similar” in all scenarios in which we have worked to date, automating its creation is a good idea. (more…)