Data blog — sql server RSS



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



Unit testing for databases

Database applications can - and should - benefit from unit tests, but it is surprising how rarely database code is covered by such tests. One of the problems I suppose is with the fact that it can be pretty tricky to write an isolated test that does not modify the state of the system, so it is fully re-runnable and yields the same results each time. Martin Fowler wrote a good article discussing the unit tests concept - well worth having a look! Even if you decide not to implement unit tests for your stored procedures or queries, you can still implement them to ensure that the coding standards are observed. You can use unit tests to check naming conventions...

Continue reading



SSMS 17.4 has been released

The SQL Server Management Studio became a standalone product that has a separate release cycle from the SQL Server itself. I think this is a good direction, as the SSMS can be developed now in much faster pace and meet the demand for features more timely.

Continue reading