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

Submit a Comment

Your email address will not be published. Required fields are marked *

4 + 2 =

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

Control my Nest Thermostat on my Domoticz Server running on a Synology DiskStation

Control your Nest Thermostat  in DomoticzNormally I always write Azure related, but today I'm writing about something different, on how I can control my Nest Thermostat on my Domoticz Server (Home automation). A while ago I have upgraded my  Nest Thermostat to login...

Service Health Alerts in Azure

Maintenance and Service Healths in AzureI get often questions, is there no maintenance in Azure. Like every data center, the Azure data center also needs maintenance. You can even be notified when a specific service, in a specific data center, has scheduled...

My Sessions at DataSaturdayNL 2019

DataSaturday NL 2019Date: 5 th October Location: Pathé Leidsche Rijn Data Saturday Holland is the new name for SQL Saturday Holland. A new start a new location and wow what a top location, Pathé Leidsche Rijn. A cinema with 7 screens and ranging from 180 to 668 seats....

Parameterize Linked Services in ADF

Parameterize Linked Services For my Azure Data Factory solution I wanted to Parameterize properties in my Linked Services. Not all properties are Parameterized by default through the UI. But there's another way to achieve this.    Linked Service Open your existing...

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:...

Goodbye 2020 Hello 2021

Goodbye 2020 Started to work for InSpark Last year was certainly an eventful year. Started with a new job at InSpark and after 10 weeks we all know what happened, the first intelligent lockdown. The Netherlands was partially locked, but our office was immediately...

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....

Microsoft Build 2022 Book of News

Microsoft Build 2022MSBuild 2022 has just started. A lot of new Announcement will be released or demonstrated the upcoming days. Like every year or event most of these announcement are added to the Book of News.The book of news can be downloaded from the link below...

Goodbye 2021, Hello 2022

Goodbye 2021Recap First of all, I would like to wish everyone a very beautiful and healthy 2022. We are now 3 days on the road into the new year and it is always good to look back at what happened last year. It's certainly been an eventful year, topped off with my MVP...

High Concurrency Notebook Activity in Microsoft Fabric

Microsoft Fabric is a cloud-based platform that provides integrated data engineering and data science solutions. One of the key features of Microsoft Fabric is the support for Apache Spark, a distributed computing framework that enables large-scale data processing and...