DataGrillen 2022

DataGrillen 2022

DataGrillen 2022

Microsoft Purview

When we say: Data, bratwurst and beer, we are of course talking about DataGrillen. After more than 2 years of absence, it was time again in recent days, with speakers from all over the world with almost 50 sessions, good weather and a large group of participants, quite a bit of knowledge has been shared again.
And as is traditional with this event, the first day will be finalized with a barbecue for all participants.
The organization is in the hands of Ben and WIlliam and you can leave that up to them. Everything was well organized again.
My session on Microsoft Purview was well attended, the slides can be found in the link below.

Datagrillen_4

Azure Purview March Updates

Azure Purview March Updates

Azure Purview updates

Announcements

Last week during SQLBITS, quite a few new updates were announced. I would like to include you in these announcements.

March updates

Support for SAP Business Warehouse (Preview)

Blogpost:

https://techcommunity.microsoft.com/t5/azure-purview-blog/azure-purview-adds-support-for-sap-business-warehouse/ba-p/3253404

Documentation:

https://docs.microsoft.com/en-us/azure/purview/register-scan-sap-bw

Azure Purview SAP BW

Dynamic lineage extraction from Azure SQL Databases (Preview)

Documentation:

https://docs.microsoft.com/en-us/azure/purview/register-scan-azure-sql-database?tabs=sql-authentication#lineagepreview

Video:

 

Certify assets in the Azure Purview data catalog

Blogpost:

https://techcommunity.microsoft.com/t5/azure-purview-blog/certify-assets-in-the-azure-purview-data-catalog/ba-p/3249460

Documentation:

https://docs.microsoft.com/en-us/azure/purview/how-to-certify-assets

Purview_Certified_Datasets

Ability to delete child terms when parent term is deleted

Documentation:

https://docs.microsoft.com/en-us/azure/purview/how-to-create-import-export-glossary

Connect to and manage an on-premises SQL server instance in Azure Purview

Documentation:

https://docs.microsoft.com/en-us/azure/purview/register-scan-on-premises-sql-server

Approval workflow for business terms (Preview)

Before you can start Authoring your workflows make sure you the correct user to the role assignment Workflow administrators, if you haven't done that correctly the option will be greyed out.

Purview_Workflow_Admin

workflow-authoring-experience

Blogpost:

Approval workflow for business glossary

Documentation:

https://docs.microsoft.com/en-us/azure/purview/how-to-workflow-business-terms-approval

Self-service data access workflows for hybrid data estates (Preview)

Purview-data-access-request

Documentation:

https://docs.microsoft.com/en-us/azure/purview/how-to-workflow-self-service-data-access-hybrid

Azure integration runtime supports scanning more source types

Azure Purview now supports scanning Snowflake, Salesforce, PostgreSQL, MySQL, Cassandra and Looker using managed Azure integration runtime.

Blogpost:

https://techcommunity.microsoft.com/t5/azure-purview-blog/azure-integration-runtime-supports-scanning-more-source-types/ba-p/3254148

Documentation:

https://docs.microsoft.com/en-us/azure/purview/manage-integration-runtimes

Localization

Azure Purview is localized in 18 languages. To change the language used, go to the Settings from the top bar and select the desired language from the dropdown.

Purview-Localization

Blogpost:

https://techcommunity.microsoft.com/t5/azure-purview-blog/localization-generally-available-in-azure-purview-studio/ba-p/3249453

Documentation:

https://docs.microsoft.com/en-us/azure/purview/use-azure-purview-studio#localization

SQLBITS 2022

SQLBITS 2022

SQL BITS 2022

What a great time I had

Wednesday 9th of March the time had finally come, at 1830 my plane would leave for London City. After all the preparations over the past few weeks, the time was there. After arriving in London City and checking in at the hotel, I went straight to the Venue. Wednesday evening was dominated by Games and Burgers. But for me it's mainly about having a chat with many people. Wow that was a really long time since I'd seen some of them.

Volunteer

This year I volunteered for the first time. That means being at the site early every day at 7:30 AM. After we have had the briefing, each volunteer can take up his task. For me, these tasks mainly consisted of monitoring and moderating various sessions, so that the speaker can focus on his sessions and that any questions from the Virtual attendees could be passed on to the speaker. In addition to monitoring this session, you serve as a source of information and an example for visitors and you are part of the Orange Family.

SQLBITS Volunteer

Sessions

On Friday it was finally time to present my own sessions. I started the day with my session on:

Lake Database with Database Template and Mapping Data with Azure Synapse Analytics

Microsoft asked me to present me this session during SQL Bits in the Cloud Scale Analytics solution area.
Once again thank you Tony and Wee Hyong for inviting me.
The room was well filled and there were quite a few questions, which is always very nice as a speaker.
One of the questions I didn't have the answer on was:
If you use Power BI on a Lake Database, will the data be read via the Synapse SQL Serverless Pool or directly from the Data Lake.
Reply:
The data is read via the Synapse SQL Serverless Pool and the costs are also charged for this.
A good question that I hadn't thought about beforehand.

Lakedatabase_query

My slides can be found on SlideShare

SQLBITS 2022

Data Governance with Azure Purview - Ask the Experts

In this session, everyone had the opportunity to ask Victoria, Wolfgang, and me for all of their questions about Azure Purview. During the session we were helped by Richard, who moderated all the questions. We had received a decent set of questions in advance and also during the session many questions were asked by both the Virtual attendees and the in Person. All in all we have given good answers, got some great feedback. It was the first time that we did an Ask the Expert session and we said to each other that we should definitely do this more often.

Final Word

The Friday evening was traditionally closed with a theme party and some can empathize with that. I've seen the craziest costumes pass by.
Saturday I attended sessions all day. We ended the day with the some and drinks in an Italian restaurant.
Sunday was the day of departure, testing and checking in. I can look back on this event tired and satisfied. Once again a big compliment to the organisation, volunteers and speakers for organizing this fantastic event. See you next year.

And Sponsors thank you for making this event happening. Thank you

 

Speaking at SQL BITS 2022

Speaking at SQL BITS 2022

SQL BITS 2022

We’re Hitting the Arcade

SQL Bits is back this year in London from March 8-12 2022. SQLBits is the largest data conference in the world and this year's theme is to bring us back to our incandescent youth, so prepare to level up your data skills and reach a new high score at the arcade-themed 2022 conference!

Not 1 but 2 sessions

This year I will not present 1 session but 2 sessions.

Data Governance with Azure Purview - Ask the Experts

In this session you have to chance to ask any question on data governance for your business using Azure Purview.

We have a panel of 3 MVPs, Victoria, Wolfgang and myself. Richard we help us out with moderating the session.
If you have an urgent question, feel free to ask it via this form https://forms.office.com/r/dTP38LnmsJ
Of course you can also ask your question live during our session on Friday 11 March from 14:10-15:00. You will find us in room 04.

Looking forward to you all

Lake Database with Database Template and Mapping Data with Azure Synapse Analytics

Microsoft asked me to present a session during SQL Bits in the Cloud Scale Analytics solution area.
Of course I wanted to do that, it is an honor to be asked to do so. Once again thank you Tony and Wee Hyong for inviting me.

In this session I will take a closer look at Database Template in Azure Synapse Analytics

Database templates in Azure Synapse Analytics are blueprints which can be used by organizations to plan, architect and design solutions.

How can we use these Database Templates in a day-to-day business, in order to speed up to automate this process? Map data tool can help us with that. The map data tool can generate a mapping data flow without having to start from a blank canvas. In this presentation, you will see how this all works in a step-by-step demo-based session.

The session is on Friday 11 March from 12:00-12:50 and will be like the above session in Room 04

Do you want to know more which sessions Microsoft is delivering:  Ready for SQLBits 2022? - Microsoft Tech Community

Oh yeah, Thursday 10 March, 9:00 am, the keynote will start, which is being led by Bob Ward, along with Buck Woody, Anna Hoffman, Patrick LeBlanc, Evangeline White, and Pedro Lopes, to show you, from SQL Server on-prem to Azure Data in the cloud, the latest and greatest data platform on earth! You better not miss this one, promises to be a nice keynote.

 

My first Virtual session in 2022 for Dataminds

My first Virtual session in 2022 for Dataminds

DataMinds

This Tuesday I've joined the DataMinds user Group to talk about Azure Purview.