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

Friday 29 July 2022

Microsoft Purview Data Sharing

Microsoft Purview Data Sharing allows in-place data sharing for Azure Data Lake Storage (ADLS Gen2 ) and Blob Storage. This solves the problem of data proliferation where you can often end up with multiple copies of the same data resulting in higher storage costs and tracking issues from data movement. This also reduces the need for more ETL packages to manage and reduces the time it takes to get access to the data. Managing the data movement can be time consuming so this data sharing feature will help reduce this.

This new feature will enable better data management, controlled access to the data with automated data sharing.  The feature works as as below:

 A few things to note   

  • the data provider pays for data storage and their own data access  
  • the data consumer pays for their own data access transactions.

 Access can be changed 

  • the data provider can revoke access to the share or set a share expiration time for time-bound access to data. 
  • the data consumer can also terminate access to the share at any time.
More details can be found here

Watch demo video

Read How to share data

Read How to receive share

Thursday 28 July 2022

Azure Synapse Community Resources

Microsoft have released a collection of community resources to help accelerate learning and enable interaction with other members of the community. Resource guide here

In addition to the Microsoft resources are those created by presenters at the Data Toboggan set of Azure Synapse conferences. Follow, share and like us. 

Social Media

Twitter: https://twitter.com/datatoboggan  @datatoboggan

LinkedIn: https://www.linkedin.com/company/data-toboggan

Conference Session recordings

YouTube: https://www.youtube.com/c/DataToboggan 

Download Microsoft guide here

Community Call to Action

 Follow us on Twitter: @Azure_Synapse

 Read and comment on our blog: https://aka.ms/SynapseBlog

 Check out our monthly updates blog: https://aka.ms/SynapseMonthlyUpdate

 Subscribe to our YouTube channel: https://aka.ms/SynapseYouTube

 Share and vote for ideas to improve Azure Synapse: https://aka.ms/SynapseIdeas

 Join the Azure Synapse Influencers program: https://aka.ms/SynapseInfluencers


 Product page: https://aka.ms/Synapse

 Documentation: https://aka.ms/SynapseDocs

 Reference architectures: https://aka.ms/SynapseArchitectures

 Security whitepaper: http://aka.ms/SynapseSecurity

Technical Discussions and Q&A

 Microsoft Q&A: https://aka.ms/SynapseQuestions

 StackOverflow: https://aka.ms/SynapseStackOverflow


 Get started in 60 minutes: https://aka.ms/SynapseGetStarted

 Azure Synapse Analytics Toolkit: https://aka.ms/SynapseToolkit

Free Learning

 MS Learn – Learning paths: https://aka.ms/SynapseLearningPaths

 Synapse Practitioner : https://aka.ms/SynapsePractitioner

 Microsoft Virtual Training Days: https://aka.ms/SynapseMVTD

 30-Day Cloud Skills Challenge: https://aka.ms/SynapseSkillsChallenge

Samples & Accelerators

 Samples on GitHub: https://aka.ms/SynapseSamples

 Accelerator – End-to-End Analytics: https://aka.ms/azsynapsee2e-git

Friday 15 July 2022

Data Toboggan - Cool Runnings event summary

On Saturday 9th July 2022 the Data Toboggan - Cool Runnings event took place. This event was the 4th large conference since its inception in December 2020. Cool Runnings is the summer edition conference for Data Toboggan. The name was influenced by the film Cool Runnings about the Jamaican bobsleigh team. The phrase ‘Cool Runnings’ is defined in the film to mean ‘peace be the journey’.

There were so many amazing speakers from 16 countries worldwide with the Piste Maps becoming a speciality depicting the agenda. For the first time, Data Toboggan ran two parallel tracks to enable more content to be delivered. There was a wide variety of Azure Synapse Analytics sessions to watch in these categories:

  • General Synapse and Data
  • Dedicated SQL Pools
  • Serverless SQL Pools and Lake databases
  • Spark
  • Data Explorer pools
  • Integration
  • Security
  • Power BI
  • Machine Learning and AI
  • DevOps.


The keynote and endnote was delivered by Kim Manis, Partner Director of Product Management, Azure Synapse Analytics & Power BI at Microsoft. I felt there was an amazing change in the middle of the day - from in-depth technical sessions - to a Knee-Deep in Tech Special Synapse Podcast.

To start your Azure Synapse learning subscribe, follow and like Data Toboggans YouTube Channel, Twitter and LinkedIn .  The majority of previous session recordings are available on YouTube and keep an eye out for the latest event videos.

Also now published Data Toboggan - Cool Runnings event (coeo.com)

Sunday 10 July 2022

PASS Data Community Summit 2022

I am really excited to announce that I will be speaking at the Summit for the first time on Microsoft Purview. 

I also have privilege to be part of an ask the experts session with Wolfgang, Erwin and Richard. Submit your questions in advance here https://forms.office.com/r/dTP38LnmsJ