Welcome

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 . Microsoft Data Platform MVP

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



Wednesday, 28 February 2018

SQLBits Lightning Talks















This year at SQLBits I was asked early Friday afternoon if I would put my name forward for the lightning talks. As a helper for 8 years I wanted to be helpful and agreed stating I had no laptop, access to material or pre-prepared slides. I quickly thought of the only topic I could reasonably cover with very little preparation, that being ‘how I became a doctor’.  As a first-time speaker it was quite daunting to stand up in front of lots of people. Without slides you have nothing to distract the attendees, at the session, from watching you.

I received a mail late afternoon confirming I had been chosen to present. I was originally down to room monitor another session at the same time. This resulted in my frantic search to find another helper who would swap room monitoring sessions. Luckily another helper kindly agreed.
Friday evening, knowing I had to get up early Saturday morning to help and monitor a few sessions, it left no time to prepare. I left the party early Friday evening to pack and to write some semblance of order for a 5 minute presentations.

I felt quite embarrassed to speak alongside others who had prepared slides, those who had presented before or those who had given lightning talks before. I was surprised with the first run though live I finished 10 seconds early, thus keeping to the strict 5 minute time limit.


After the end of the presentation the judges gave their constructive feedback to the room. I knew before they provided feedback that the lack of slides and laptop was against me obtaining great feedback. As another lightning speaker said, this was all a very daunting experience for a first-time speaker and wouldn’t encourage new speakers.





I would say standing on the stage takes courage and all the lightning talk presenters should be proud they did it. Now after returning home after a very exhilarating and exhausting week of helping, learning and networking, I have created the set of slides  for the presentation in case anyone wanted more information. 




Saturday, 24 February 2018

SQL Relay 2018

If you enjoyed SQLBits come to SQLRelay in October 8-12. We are visiting 5 venues around the UK. More details will follow in due course. We look forward to seeing you there,



Friday, 23 February 2018

Become an Azure Cosmos DB hero











There is an Azure Cosmos DB Technical Training Series available to sign up for. It has 7 parts covering a range of topics including a technical deep dive.

  • Technical overview of Azure Cosmos DB
  • Build real-time personalized experiences with AI and serverless technology
  • Using Graph API and Table API with Azure Cosmos DB 
  • Build or migrate your Mongo DB app to Azure Cosmos DB
  • Understanding Operations of Cosmos DB
  • Build Serverless Apps with Azure Cosmos DB and Azure Functions
  • Apply real-time analytics with Azure Cosmos DB and Spark

The training series has interactive Q&A throughout.

Saturday, 17 February 2018

SQLBits 2018 The Magic of Data



It is nearly time for the 2018 edition of SQLBits. The four day conference is at Olympia, London. It is the leading data professional conference in Europe. It offers the op3portunity to learn, network, develop and share your data knowledge. There is a great shift in the provision of data management allowing operational and predictive insight and embedded AI on any platform. This conference offers attendees the chance to experience new paradigms and to access an array data related events.  
  •          4 days of world class training
  •         Over 170 specialist sessions
  •          More than 10 hours of best practice sharing with your peers
  •          Networking events with the Microsoft Product Group
  •          Introductions to software vendors and consultants
  •          The infamous SQLBits Party
The conference has grown from strength to strength over the years and it is privilege to be a conference helper for an 8th year.

Tuesday, 13 February 2018

Introduction to Splunk for operational intelligence


Machine data is everywhere. Machine data is digital information created by computers, mobile phones, embedded systems, sensors and other networked devices. The data types:




Machine data can intersect with and improve human lives. A summary is in this video




Splunk, a software platform, has the capability to leverage machine data for data management and analytics.  It can be used for

  • Data driven decision making
  • Alerts for network security threats
  • Report on system failures
  • Analyse and improve functionality

It enables performance analysis, dashboard creation, monitoring, troubleshooting and investigation of the real-time data collected. A Edureka learning video showed the Splunk components.  



















and an overview of Splunk.





















The very useful Splunk free fundamentals 1 course is a self paced learning course covering search, navigation, use of fields, statistics, reports, dashboards and alerts.

Friday, 9 February 2018