Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein

Monday, 15 August 2016

DocumentDB Tools

There is a useful cheat sheet to help with writing DocumentDB queries. This can be downloaded here

Estimate Request Units and Data Storage

Query Playground converts T-SQL Syntax to JSON

Friday, 5 August 2016

OpenMinds 2016 Database Research

The 'Get Animated about Research' article shares details about my research with the kind help of my friend Andrew Fryer. The article on page 10-12 is in the annual OpenMinds 2016 magazine dubbed 'the journal for enquiring minds', The Open University alumni publication.

Thursday, 4 August 2016

Document Database Comparisions

Azure DocumentDB is a NoSQL database that leverages a write-optimised, latch-free database engine service for highly available and globally distributed apps.

An interesting comparison of DocumentDB offerings.

Thursday, 14 July 2016

Database Lifecycle Management

This survey report released discusses the expertise required for managing data complexity. The findings identify the need for database expertise to manage this challenging environment.

Tuesday, 12 July 2016

Systems Thinking can help Database Management

A different way to think about managing database systems is using systems thinking. A fun animation about systems thinking and evaluation.

Wednesday, 6 July 2016

DBaaS - Transforming Database Management

There have been various reports about Database as a Service.

The 451 Research October 2015 report on the state of Database as a Service 

The Report

IBM State of DBaaS 2016 report - Database-as-a-Service

The Report

Sunday, 19 June 2016

The State of DevOps

Puppet labs have been reporting on the current state of DevOps over the last 4 years.  They promote the need to get on board with DevOps or be left behind. The 2015 report can be found here.

Modern IT: DevOps to ITIL, Creating a Complete Lifecycle for Service Management free training.

The training looks at merging the DevOps movement of DevOps into existing ITIL service management practices. DevOps practices and techniques can be used with established ITIL service management framework, to get the best of both worlds from development and operating environments.