My Virtual Session at SQLBits 2020

My Virtual Session at SQLBits 2020

Month: October 2020

by Erwin | Oct 5, 2020

SQL BITS 2020, the greatest data show 

Last week was SQL BITS week.

After the event was moved from April to September, it eventually became a Virtual event. Setting up a Virtual event requires a lot of adjustments in the Organization.

Recording

All regular sessions had to be recorded in advance so that during the event itself it could not go wrong.
For some of us this was new and others have done it before. In any case, it was new to me, but the organization did everything it could, to help us with various sessions in which everything was explained and in which we could ask all kinds of questions. Thanks for that.

Is it strange to pre-record a session?

Yes, it is, you are trying to find an environment in which you have no ambient noise, a good microphone and a good camera. But you don’t always have an influence on ambient sounds. And presenting to a webcam is strange.

After practicing my session again, I recorded my session in one go and did not edit anything in the session. After all, something can always go wrong or go in a different way in a session, even if you record it in advance. Once you start adjusting or editing that, the end is lost and a lot of time goes into it. But also the charm of  a session is gone. After all, we are data professionals and not movie stars.

My Session

Back to the day itself, half an hour in advance I could log in to my session and must say that it was quite exciting. Would the video start, how do I come across and some more questions where in my head?
But all nerves for nothing, the session started right on time. In the meantime I had created a few polls which you could have the audience answer in between.
But also being able to answer the questions live during the session and sometimes even with a link to some extra information was now easy.SQL BITS Poll

I was delighted to see at the outcome of the last poll, most of the people who attended my session will now start using Azure Key Vault in their day-to-day work. In the end that’s why we do it for(help or advice others).

My presentation can me found here.

Conclusion

I saw a very great event, the quality of the sessions were very high. And there was so much choice, but luckily they will be soon available to watch On-Demand.
A big round of applause to the entire organization, you have organized a fantastic event with a super nice portal, including exhibitor hall, networking, chat rooms and much more. Thank you for having me and see you next year.

 

 

Feel free to leave a comment

Are you using Azure DevOps?

Month: October 2020 Azure DevOps More and more users are starting with Azure DevOps. Azure DevOps can be used for up to 5 users free of charge and is therefore a great start to start a project.     Build and Release I will not describe what Azure DevOps can do,…

ADF: Get Metadata Activity stopped working

Month: October 2020 Meta Data Activity Today my pipelines in Azure Data Factory (ADF) suddenly stopped working. The output structure was not found. Quit strange while these pipelines have been running for weeks.     Invalid Template After debugging my Pipeline I found…

Goodbye 2020 Hello 2021

Month: October 2020 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…

How to check your SQL Server Quota in Azure?

Month: October 2020 Azure Subscription Usages for SQL Server   Last week we reached our Logical server Quota in Azure. By default you’re only allowed to add 20 Logical Servers, but we wanted to have some more for testing purposes. Microsoft Support You can submit a…

Parameterize Linked Services in ADF

Month: October 2020 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…

Azure Purview MSIgnite Spring 2021 Announcements

Month: October 2020 Azure Purview Ignite 2021 Annoucement Pricing This week the Azure Purview announced that they will extend the Azure Purview offer to provision 4 Capacity Units of the Data Map for free till May 31, 2021! Charging will start on June 1, 2021. Great…

Calculate the Last Day of the Month using SQL

Month: October 2020 Calculate the Last Day Today 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…

High Concurrency Notebook Activity in Microsoft Fabric

Month: October 2020 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…

A new year with a new job

Month: October 2020 Changing jobs After almost 11 years and 4 months I have decided to leave Axians and to start a new adventure in the new year. On January 2, 2020 I will start my day as Lead Data and AI at Inspark The past years have flown by. I started at Eniac BI,…

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

Month: October 2020 Control your Nest Thermostat  in Domoticz Normally 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…

Watch the MS Ignite sessions on-demand

Watch the MS Ignite sessions on-demand

Month: October 2020

by Erwin | Oct 5, 2020

MS Ignite Sessions

MS Ignite 2020 was this year a virtual event.

Most of the sessions were live in the evenings and the other sessions were available at different times in different time zones. Compliments to the MS Ignite team for organizing such a great event

Most of the sessions are ready to watch on demand. If you have not done this yet, here is the link to be able to do this.

Feel free to leave a comment

Calculate Workingdays including Holidays with T-SQL

Month: October 2020 Calculate Workingdays between 2 Date columns Recently 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…

Data Factory Pricing

Month: October 2020 Data Factory pricing Are you also having problems to understand the Pricing Model for Azure Data Factory?  After some research on the internet I came across an article which I wanted to share with you. ADFV2 Pricing Examples Feel free to leave a…

10 Days of Azure Synapse Analytics

Month: October 2020 10 Days of Azure Synapse Analytics For the next 10 days, every day a different topic is explained about Azure Synapse Analytics. The shortest and easiest way to see how Azure Synapse Analytics can help you, to make decisions within your data…

Service Health Alerts in Azure

Month: October 2020 Maintenance and Service Healths in Azure I 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…

Book of News Microsoft Ignite 2019

Month: October 2020 Microsoft Ignite 2019 MSIgnite 2019 has almost come to an end. A lot of new Annoucement have been released and presented.  Would you also like to know which announcements have been made? Microsoft has released during MSIgnite a “Book of News”. This…

Microsoft Fabric pricing (Preview)

Month: October 2020 Microsoft Fabric Pricing Microsoft 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…

Updated competency exams and certifications Data Platform and Data Analytics for 2020

Month: October 2020 Retiring and new exams and certifications as of June 30 2020 A lot of Exams and certifications for Data Platform and Data Analytics are retiring on June 30 2020. All retired Exams and certifications will remain eligible for competency attainment…

How to check your SQL Server Quota in Azure?

Month: October 2020 Azure Subscription Usages for SQL Server   Last week we reached our Logical server Quota in Azure. By default you’re only allowed to add 20 Logical Servers, but we wanted to have some more for testing purposes. Microsoft Support You can submit a…

My Sessions at DataSaturdayNL 2019

Month: October 2020 DataSaturday NL 2019 Date: 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…

Goodbye 2022, Hello 2023

Month: October 2020 Goodbye 2022 ​Recap It’s that time of year again to reflect on the past year. Also think it’s really good, to see what you’ve done in the past year. It is also the time again to traditionally bake Oliebollen on this day, a Dutch Tradition that we…