I like visualisations, particularly map-based ones. Done well, it’s as if they give you superpowers or a microscope or telescope – you can see something that normally is hidden from you. They help you to understand something, and in business that often means they help you to make a decision. Below is a visualisation that … Continue reading How far away from here is the most distant bit of the UK?
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
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