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 April 2022

Podcast: A Recap of SQLBits 2022

Excited to be a part of a podcast with Jessica Healy and Niall Quinn, hosted by Justin Langford chatting about SQLBits 2022 highlights and benefits. It was amazing to hear the various view points of others who attended the event.  Coeo have been an amazing sponsor of the event for many years.  Tune in an have a listen.

Wednesday, 20 April 2022

Monitor scan runs in Microsoft Purview

In Microsoft Purview the monitoring of scan performance is now in the data map menu hierarchy

Microsoft Purview account -> open Microsoft Purview Studio -> Data map -> Monitoring.

You can now register, scan data sources and view the scan status history in one place.  This is in Preview.

Azure Purview becomes Microsoft Purview

 A major change was announce yesterday with the future of compliance and data governance combined. The naming has changed from Azure Purview to Microsoft Purview. Watch the announcement here

The announcement can be read here . Microsoft talk about the lines between risk roles are blurring. 

  • The pandemic 
  • Nation-state attacks  
  • Remote work 
  • Evolving regulations 
  • Data sharing 
  • Growing CDO responsibilities 
  • Governance and compliance

It is interesting that Microsoft mention that the CDO role may go beyond data management and protection to include business intelligence, AI and machine learning. I am not sure how that would work with the chief analytics officer (CAO) and CISO and overlapping roles.

The new Microsoft Purview is explained in the article as it:

  • Helps you gain visibility into assets across your entire data estate.
  • Enables easy access to all your data, security, and risk solutions. 
  • Helps safeguard and manage sensitive data across clouds, apps, and endpoints.
  • Manages end-to-end data risks and regulatory compliance.
  • Empowers your organization to govern, protect, and manage data in new, comprehensive ways.

The article also talk about enhancing data governance with Microsoft Priva.

Read more about Azure Purview is now Microsoft Purview where it is shared the Microsoft Purview is a comprehensive set of solutions to help you govern, protect, and manage your entire data estate. They have brought together  Azure Purview and Microsoft 365 Compliance portfolio under one brand.

Watch Go Beyond with Microsoft Purview


Sunday, 17 April 2022

The SQLBits Buddies at SQLBits

I am part of an amazing new venture  - SQLBits buddies. An initiative to help people feel more comfortable and have a friend when they are attending the conference. 

The SQLBits Buddies was a new idea that was trialled at SQLBits Arcade!

They were there to help you have a fantastic experience at SQLBits and give you that person to talk to and ask about all things SQLBits! Did you need someone you can talk to about the social side of SQLBits? Did you know about the game’s night, pub quiz and party? Ask a SQLBits Buddy!

You can read more here

There are interviews with a few of the Bits buddies

Angela Henry 

Malcolm Smith

Steph Martin

Victoria Holt

We had lots of fun at the event and spoke to lots of people first timers, people who had been before but work colleagues were online or simply they had come to the conference on their own this time. We shall see you all at the next event.

Saturday, 2 April 2022

How to get started with Data Governance

This is a question that is being asked by many at the moment. The term data governance still comes with the old stigma of control and costly and requiring teams of people. There are those that still believe that going in under the radar and growing once value is shown is a way to start. Then there are those that think we should utilise tools to help with data governance to enable speed of adoption. Myself I think considering business value must be the place to start to have great data and business buy in. After all why do we want to collect the data in the first place. So don't talk about governance but about understanding that data, data erudition, and knowing your current data quality state.  Once the business is in place, embed the process for each use case.

Data governance needs to be simple clear messaging to the business based on an agile method. The benefits of each use case must be measurable and bring value. To be successful it relies on cross team communication and diversity in views. That strong cross functional collaboration, ethical understanding which is sustainableData governance underpins all data tasks.

Start with an agenda item in an existing meeting and the program will grow over time. 

Don't follow a framework as every business is different but pull from DAMA (body of knowledge) and CDMC (playbook of best practice )

Start with a data readiness assessment with four areas that looks at the current usage, data quality, how data is managed and business readiness.

Think about the two core questions that are trying to be solved are 

1.             what business problem are you trying to solve

2.             What tooling would help solve the business problem

Start small and create an iterative roadmap based on business value


A Guide to Data Governance – Microsoft   https://bit.ly/3hDe5Sn

Chief Data Officer (CDO) Seat at the Cloud Table    https://bit.ly/375px7e

Get started with Azure Purview   aka.ms/azurepurview/getstarted

Microsoft Learn: introduction to Azure Purview   aka.ms/intro-to-azure-purview

Azure Purview Documentation   https://docs.microsoft.com/en-us/azure/purview/

Azure Purview Readiness   Checklist  https://bit.ly/3HIytMy