As you know, as long as you are not totally oblivious to the technological world you will have heard about one of the biggest bugs in the history of computer science (Spectre and Meltdown) and that its effects are real. So real, that we ourselves at SolidQ ourselves have experienced it in our own Query Analytics software. In this post I will try to shed some light on how to proceed if you detect performance regression in your solution with SQL Server, explaining how I have solved it in my own system.
I have uploaded a repository containing a helper to analyse the Data Migration Assistant tool results to GitHub. I have compiled and improved Microsoft’s version released last March in order to process aggregated results from multiple servers using Microsoft’s static code analysis tool. (more…)
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…)
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…)