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

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