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...
The post illustrates the process of setup of the Oracle InstantClient with ODBC drivers, configuration of an ODBC data source and configuration of the SelectCompare Connection so you can use Oracle in your data comparison work.
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.
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...
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...
