Data Saturday Stockholm
Data Saturday Stockholm
My slides can be found on SlideShare
Handy links:
Azure Data Factory Naming Conventions - Erwin & BUSINESS ANALYTICS (erwindekreuk.com)
My slides can be found on SlideShare
Handy links:
Azure Data Factory Naming Conventions - Erwin & BUSINESS ANALYTICS (erwindekreuk.com)
Recording of my session during the Data Toboggan January 2022 conference.
Last week during SQLBITS, quite a few new updates were announced. I would like to include you in these announcements.
Blogpost:
Documentation:
https://docs.microsoft.com/en-us/azure/purview/register-scan-sap-bw
Documentation:
Video:
Blogpost:
Documentation:
https://docs.microsoft.com/en-us/azure/purview/how-to-certify-assets
Documentation:
https://docs.microsoft.com/en-us/azure/purview/how-to-create-import-export-glossary
Documentation:
https://docs.microsoft.com/en-us/azure/purview/register-scan-on-premises-sql-server
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.
Blogpost:
Approval workflow for business glossary
Documentation:
https://docs.microsoft.com/en-us/azure/purview/how-to-workflow-business-terms-approval
Documentation:
https://docs.microsoft.com/en-us/azure/purview/how-to-workflow-self-service-data-access-hybrid
Azure Purview now supports scanning Snowflake, Salesforce, PostgreSQL, MySQL, Cassandra and Looker using managed Azure integration runtime.
Blogpost:
Documentation:
https://docs.microsoft.com/en-us/azure/purview/manage-integration-runtimes
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.
Blogpost:
Documentation:
https://docs.microsoft.com/en-us/azure/purview/use-azure-purview-studio#localization
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.
On Friday it was finally time to present my own sessions. I started the day with my session on:
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.
My slides can be found on SlideShare

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.
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
This year I will not present 1 session but 2 sessions.
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
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.