SQLBITS 2022

by Mar 14, 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.

Excel London

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

 

Feel free to leave a comment

0 Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Collection of all ADF Mapping Data Flow videos

ADF Mapping FlowDid you use the Dataflow preview functionality in Azure Data Factory? This has recently be renamed to Mapping Data Flows.  All video's which the ADF team has created, are collected. Start Here: ADF Data Flow: Overview ADF Data Flow: Data Flow...

Enable Pattern Rules in Azure Purview

How can I enable Pattern Rules?​Pattern Rules Last night I was preparing for a demo with Azure Purview. As always, I walk through all the activity hubs to see if there are any new options. This time I noticed that the Pattern Rules option was greyed out. Resource Set...

Microsoft Fabric pricing (Preview)

Microsoft Fabric PricingMicrosoft Fabric pricing in Public Preview is announced as of the 1 st of June.These are currently the Pay as You go pricing, later this year the Azure Reservation will follow. OneLake storage pricing is comparable to Azure ADLS (Azure Data...

SQLBits session: Microsoft Purview Data Policy App

SQLBits 2023 Thanks everyone for visiting my session during SQLBits. It's great to see such a full room and that so many people have started using Microsoft Purview.  SLIDES The slides can be downloaded via the link below, so that you can view them again at...

Restore a accidentally deleted Azure SQL Database

Help I deleted my Logical Server​OOPS Have you ever experienced that you accidentally deleted your Logical Server in Azure?  Because, for example, you made your Pipeline wrong. Surely. And of course you didn't have a backup in your storage either.Well I must confess...

Azure Purview March Updates

Azure Purview updatesAnnouncements 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:...

Calculate the Last Day of the Month using SQL

Calculate the Last DayToday I needed to calculate the last day of the previous month for a Customer.Ever heard from the function EOMONTH? Searching on the web I came across a function I never heard from before EOMONTH, this function can be used as of SQL Server 2012....

Proud to be an ADF Hackathon winner!

Azure Data Factory HackathonAround the clock During the event 'Around the clock Azure SQL and Azure Data Factory' event on Feb 3, 2021, they kicked-off the Azure Data Factory (ADF) Hackathon. Recording of this event can be found here.Winner I submitted a ADF Pipeline...

LEAP 2018

Lead Enterprise Architect ProgramFrom the 4th of December until the 6th of December I've joined the LEAP (Lead Enterprise Architect Program) 2018 Data/AI from Microsoft NL. Three  days on the Microsoft Campus in Redmond joining business and technical sessions from a...

Calculate Workingdays including Holidays with T-SQL

Calculate Workingdays between 2 Date columnsRecently I have been getting some questions from my customers, can I calculate the number of workdays between 2 dates? Of course my answer was, yes you can. But I do want certain closing dates and holidays of our company not...

Discover more from Erwin & Data Analytics

Subscribe to get the latest posts sent to your email.