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

Monday 31 August 2020

Data Governance Roles

To enable data governance programs to be successful it is important to establish the key roles and define the responsibilities within those. 

Chief Data Officer - a corporate officer responsible for enterprise-wide governance and utilization of information as an asset, via data processing, analysis, data mining, information trading and other means. Wikipedia

Data Stewards - this label describes accountability and responsibility for data and processes  to control the use of data assets. There are varying types of Stewards: 

Enterprise data stewards- oversite of the data domain across business functions

Business data stewards - those who are subject matter experts

Technical data stewards - database administrators, BI specialists , data quality administrators 

It is necessary the every data set has a data owner. A person responsible for the decision regarding the data. They normal are a business data steward. 

Then often there is a data governance steering committee to manage the progress and invoke innovation. 

Saturday 22 August 2020

Data Governance

Data Governance plays a key role in ensuring data is managed. Data Governance as defined by DAMA is 

"the exercise of authority and control (planning, monitoring, and enforcement) over the management of data assets. "

The successful management of data requires a program that includes:



Standards and quality



Issue management

Data management projects for improvement

Data Asset Valuation

The goals of data governance are to bring about a sustainable program of work that is embedded in the day to day management of data. Together this should be measured to ensure improvements can be demonstrated and show positive financial impact.

Azure has Governance features and services to explore. 

Wednesday 12 August 2020

SQLBits 2020 goes Virtual

Very excited to here about the change of event from a face to face event to a virtual event. I don't think a year would be complete without SQLBits. With so many virtual tech conferences this year there is so much choice. My number 1 choice is always SQLBits. I have attended and helped at every event since inception. Further information and how to book your tickets: http://sqlbits.com . The event is running 29th September - 3rd October 2020