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.
Chaos, complexity, curiosity and database systems. A place where research meets industry
Welcome
"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein
Friday, 29 April 2022
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
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
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 sustainable. Data 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
Reading
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