Data blog RSS



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



December release of SQL Operations Studio is now available

Microsoft has published an update to the new tool in the portfolio, the SQL Operations Studio. The utility is implemented as a cross-system, universal tool that allows you to work with SQL Server databases, Azure SQL and SQL Data Warehouse on Windows, Linux and Mac OS. The new release contains a number of improvements, and you are most welcome to download and test the utility.  It is open source now! What is more, if not most, important though is that the SQL Server team decided to open source the utility and publish the source code in a GitHub repository. This means that the changes to the tool will reflect the real users' needs and the utility will evolve in the direction desired by...

Continue reading



Graph extensions in SQL Server 2017

We have been talking a bit about graph databases in recent posts. Data Modelling and Monty Python What are the advantages of using a graph database? The rise of the graph databases. Well, it turns out that also SQL Server jumps on the bandwagon and makes first steps towards graph processing.  In the first release, the functionality will be a bit limited, but you can write some workaround code for certain types of graph traversals. The functionality of the first release is explained in the FAQ article on the Technet blog.   There are advantages of the SQL Server solution. SQL Server has become an industry standard and one of the main players on the RDBMS market. The graph functionality...

Continue reading