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, 7 August 2019

Discover Datasets

There are many thousands of data repositories around the world and to make it easy to access this data Google have launched a Dataset Search service.

https://toolbox.google.com/datasetsearch



This aimed to be a companion of sorts to Google Scholar, the company’s popular search engine for academic studies and reports.

Read more about the service here.

Thursday, 25 July 2019

SQL Server 2019 Workshop Lab

SQL Server 2019 is a modern data platform designed to tackle the challenges of today's data professional.






















There is a new self-paced free lab is available to learn some of the concepts and how to solve modern data challenges using a hands-on lab approach.

SQL Server 2019 provides many new capabilities including:

  • Data Virtualization with Polybase and Big Data Clusters to reduce the need for data movement
  • Intelligent Performance to boost query performance with no application changes
  • Security enhancements such as Always Encrypted and Data Classification
  • Mission Critical Availability including Availability Groups on Kubernetes and Accelerated Database Recovery
  • Modern Development capabilities including Machine Learning Services and Extensibility with Java and the language of your choice
  • SQL Server on the platform of your choice with compatibility including Windows, Linux, Docker, Kubernetes, and Arm64 (Azure SQL Database Edge)

Monday, 22 July 2019

Data Relay 2019 Registration is open

Data Relay is open for registration at all 5 venues.


Newcastle Monday 7 October
Leeds Tuesday 8 October 
Nottingham 9 October
Birmingham Wednesday 10 October
Bristol Friday 11 October





Data Relay is returning for its 9th year, and is heading your way in October 2019!

Data Relay features top quality Microsoft Data Platform content from Microsoft and internationally renowned speakers.

With over 1000 registrations on the last Relay, reserve your place quickly

The full agenda will be published shortly. The day will comprise of a series of 55 minute technical presentations, at beginner, intermediate and advanced levels. You can switch tracks at will throughout the day, to select the sessions that are most relevant to you.



Thursday, 18 July 2019

MVP Award Package

So excited to receive my #MVP award package and disk. It is such an honour to receive this for a second year. What an amazing  #data community we have. Thank you #Microsoft #MVPBuzz

On the award it says "We recognize and value your exceptional contributions to technical communities worldwide."

The thing I  value the most is helping and sharing data innovations with the community.  There are so many exciting developments, opportunities and benefits for the communities that data can bring. People are having extraordinary visions for the future, brought about with data and advanced analytics working together to solve complex problems.

I am looking forward to the next year of exciting data events.

Tuesday, 16 July 2019

Microsoft Inspire 2019 Corenotes

The Microsoft Inspire 2019 Corenotes with Satya Nadella and Brad Smith is being livestreamed tomorrow starting at 8:30AM PT. It can be watched on You Tube.  Microsoft Inspire is where partners meet to connect, collaborate and celebrate as one community.


Tuesday, 9 July 2019

What is Azure SQL Database Hyperscale

Azure SQL Database is based on SQL Server Database Engine architecture for the cloud environment. There are three architectural models that are used in Azure SQL Database:

  • General Purpose/Standard
  • Hyperscale
  • Business Critical/Premium

The Hyperscale service tier in Azure SQL Database is a new service tier in the vCore-based purchasing model. The Hyperscale service tier in Azure SQL Database provides the following additional capabilities:

  • Support for up to 100 TB of database size
  • Nearly instantaneous database backups 
  • Fast database restores that are based on file snapshots which take in minutes rather than hours or days
  • Rapid scale out to provision one or more read-only nodes for offloading your read workload 
  • Rapid Scale up and to accommodate intermittent heavy workloads 

To learn more watch the video.