Data blog RSS



New version of SelectCompare is available!

I am delighted to announce that a new version of SelectCompare has been released. Version 1.2 contains a number of improvements and optimizations, and two of them are directly available to the user: Support for the SQL Server stored procedures Now you can call a stored procedure that returns a rowset directly in the comparison query definition window. The valid syntax is  exec my_stored_procedure [parameter1[, parameter2, ...]] Sort columns in the comparison results User now can select either continuous or alternating view of the source and target columns. The alternating layout allows for quick visual comparison of values belonging to the same column on both sides of the comparison. To switch between the views, just click the appropriate option on the right of...

Continue reading




Installing Docker for Windows

The post covers installation process of the Docker for Windows client, a utility that allows to run and manage docker images on the local machine. Docker images can be used to facilitate component and regression testing and are very important tool in the hands of a developer.

Continue reading



Spectre, Meltdown and your database server

If you haven't heard news about the detected low level vulnerabilities called Meltdown and Spectre, perhaps you are on a wrong planet.  Both vulnerabilities have been recently in the focus of all mainstream media. They are quite severe, as all the blog posts and articles imply. The vulnerability is pretty much backed in to any CPU that has been on the market since mid nineties. Imagine that!  The Meltdown can be to some degree patched with an operating system update, and this is what all major OS vendors are doing, as we speak. Spectre can be more tricky to fix, but at the same time, it is understood that it may be also more difficult to execute an attack using...

Continue reading



Ranking of database engines

So it is January again and it is time for various trend reports and market share. Portal db-engines.com publishes, among other interesting content, periodic reports showing popularity of DBMS engines on the market. There is a number of factors taken into account, best described here. It is important to know that the report does not show the relative share of particular DBMS on the market, but rather its popularity among developers really.   What is striking though, that there are three leading technologies in terms of popularity - Oracle, MySQL and SQL Server. They are quite close to each other and quite apart from the fourth one - PostgreSQL. When you look at the historical trends chart, you can see that...

Continue reading