This article is the first in a series: How far away is the most remote part of the UK?How far away is the closest bit of the EU?Which bits of the EU are the closest? I like visualisations, particularly map-based ones. Done well, it’s as if they give you superpowers or a microscope or telescope … Continue reading How far away from here is the most distant bit of the UK?
Category: JSON
Documenting ASP.NET REST APIs with Swagger / Swashbuckle
Introduction Swagger is a way to document a REST API, and tools can automate much of this process (but not all of it). At the centre of things is a JSON file that describes the API. You can create this file by hand or use a tool to generate e.g. from the API source code. … Continue reading Documenting ASP.NET REST APIs with Swagger / Swashbuckle
Reading JSON in SQL Server 2016
Introduction There's a lot of this that I won't have time or space to cover, so for more information, I suggest you look at Microsoft's blog on SQL Server + JSON. What I will cover is the OPENJSON table-valued function, which lets you turn JSON text into a result set, i.e. rows and columns. One … Continue reading Reading JSON in SQL Server 2016