Data blog RSS

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

Temporal data tables in SQL Server

I came across a very interesting post about creating temporal tables in SQL Server and Azure SQL. In the past it was always a bit of a mission to set up a combination of tables that would track each change to the state of a particular row and allow you to browse through the history easily.  It turns out that now you can just declare such table using pure DDL, no triggers, no stored procedures. It is as simple as the following DDL instruction (taken from Peter's article): Create Table dbo.SalesOrder ( ID int Not Null Primary Key Clustered, ...remaining columns... StartDate datetime2 GENERATED ALWAYS AS ROW START HIDDEN, EndDate datetime2 GENERATED ALWAYS AS ROW END HIDDEN, PERIOD FOR SYSTEM_TIME...

Continue reading