On Friday, April 16th, 2021, I will be speaking at Global Azure Norway! Global Azure is a virtual 3-day event where communities from around the world organize live streams that are open for everyone to join. All the live streams add up to one global event with more than 500 speakers and sessions, so you should be able to find something interesting 🤓
On Saturday, January 30th, 2021, I will be speaking at the first Data Toboggan event! This is a free event focusing on Azure Synapse Analytics. There are 14 sessions scheduled in 12 hours, covering topics such as data integration, machine learning, data warehousing, data governance, and more. Join us 🤓
Pipelines and Data Flows: Introduction to Data Integration in Azure Synapse Analytics
Do you regularly need to get data for your projects?
Data is at the core of every Business Intelligence, Data Science, and Machine Learning project. You need data to understand what has happened in the past, to predict what may happen in the future, to discover patterns and anomalies, and to gain the insight necessary for making faster and better decisions.
But before you can do any of those things, you need to ingest, store, transform, integrate, and prepare your data. Guess what? You can do all of those things in Azure Synapse Analytics – without having to write any code!
In this session, we will cover the fundamentals of data integration in Azure Synapse Analytics. First, we will go through what Pipelines and Data Flows are. Then, we will quickly build a solution for ingesting and transforming data. Finally, we will look at how to orchestrate and schedule our pipelines, and how to monitor our solution once it has been deployed.
Join us at Data Toboggan!
Check out the Data Toboggan schedule, because I’m guessing that there’s at least a session or two that’s interesting for you. And if this is not your thing, can you please share it with your coworkers and network who might be interested? Register today, follow @datatoboggan and #DataToboggan on Twitter, and I hope to see you there! 😊
Last week I visited Belgium for the first time to attend and speak at my first SQL Server Days 2015. It was a truly great event, and I would like to say a huge thank you to the organizers and volunteers for making it a wonderful couple of days for speakers and attendees!
The venue was spectacular, but unfortunately none of my pictures do it justice. Take a look at the great pictures on the SQL Server Days Facebook page instead. I loved the huge open area in the middle where everyone could meet during breaks, and I was so happy there was unlimited coffee and chocolate! :) The rooms were all unique and fun to present in. One room looked like a library, another like a bar, and I presented in the room that was decorated like a train station – with trains in it!
I presented my Don’t Repeat Yourself – Agile SSIS Development with Biml and BimlScript session. It is based on my Biml introduction session, but included some of the more advanced features like C# classes / methods and Transformers in Mist. My attendees were a mix of people who were completely new to Biml, people who had tried basic Biml and people who had already created advanced Biml frameworks. It was a bit tricky to cover everything for everyone in just one hour, and I know I went too fast through a couple of demos, but I hope it wasn’t a waste of time for those of you who attended :)
The slide deck is available on SlideShare, and I have uploaded all the demo files on my Biml Resources and Reference page for you to go through at your own pace. Some instructions are included in the README.txt file, and feel free to contact me with any questions. I will continue to update the demo files with new and improved examples. You can always find the latest version on my Biml Resources and References page.
Speakers! What a great bunch of people :)
First picture: Attendees eating lunch. Second picture: The room I presented in, wow!
Thank you so much for having me, and I hope I can come back in 2016! :)
SQLBits XIV Superhero Edition was my first SQLBits experience, and it was a truly amazing week!
I want to start with a massive thank you to the organizers: Darren Green, Simon Sabin, James Rowland-Jones, Chris Testa-o’neill, Allan Mitchell, Jonathan Allen and Annette Allen. You guys did one heck of a job to make this the best conference in the universe! :) I also want to say thank you to all the sponsors, volunteers and speakers who made this a great event. And to all the attendees, I hope you had a blast and that I’ll see you again next year!
I spent the past couple of days in Darmstadt, Germany for Deutsche SQL Server Konferenz 2015. This was the first time I spoke at a conference (not a SQLSaturday), and it was an absolutely amazing experience. I want to thank PASS Deutschland for doing a fantastic job to make this a great event!
The one thing I would like to have changed is that I should have learned German before going to Darmstadt :) The quality of speakers, sessions and topics covered was very impressive, and there were many sessions in German that I wanted to see. But I can’t complain at all, I got to see some great sessions and have learned new things that I look forward to trying.
Yesterday I had the pleasure of speaking at The Code Pub Oslo, a meetup for women who are interested in IT. It’s a great concept where they get together, learn about new technology, and spend the rest of the evening working on projects. It was their one-year anniversary and in just one year they have grown from 5 to over 130 members.
My presentation was an introduction to Business Intelligence and Data Warehousing, as well as how you can benefit from getting involved in a community like PASS. I like working on presentations because I learn so much from it. It was a bit of a challenge trying to sum up Business Intelligence because there is so much happening and things are changing rapidly. (And I only focused on the Microsoft world!) It was a bit of an eye-opener when I pulled out a book I bought less than two years ago and I realized it was already outdated. So many exciting things have happened in just a couple of years, things like Predictive Analytics and Machine Learning, all the Power BI tools, cloud services and real-time Big Data.
My focus was on what Business Intelligence is, why it’s important, and all the different things you can work with if you pursue a career in Business Intelligence. I explained what Data Warehousing is, and how it is evolving from the traditional to the modern Data Warehouse. I finished my presentation by telling my story of how I’ve gone from being the shy girl who didn’t know anyone to being part of the SQL community, and how life-changing it has been for me.
I hope it was interesting for the attendees, and I hope I’ve inspired some of them to get involved in their own communities. Thank you to Netlight for hosting The Code Pub and for giving me the opportunity to present!
SQLSaturday #337 Oregon was a great event, and I’m so happy I could be there and help out as a volunteer! Arnie, Paul, Vern, Sopheap, Rob, Theresa and everyone else who spent time working on this event, thank you so much. There were 52 volunteers helping out at this event. 52! That’s amazing. I hope you had a great time and I look forward to seeing you again next year!
Isn’t this one of the coolest name badges you’ve seen? Staff, speakers and volunteers all had name badges like this. Each group had a different color with their own pictures and text on it. The QR code takes you to a website where you can get in touch with the person. They were laminated and the same on both sides, so you didn’t have to worry about it flipping over. You didn’t have to worry about people not seeing it either, because it was large and very visible. I may have to borrow a few ideas from this name badge for our next SQLSaturday :)
My first and last assignment of the day was being a room proctor, but I didn’t actually get to see the session. There were quite a few people who arrived during the first session, so I stayed outside my room guiding them to where they wanted to go. It was nice that the organizers had put up maps of all the session rooms in the hallways, I could help attendees or just show them the map. A quick tip if you’re volunteering like this: don’t be afraid to walk up to people! A simple “hi, how can I help you?” if they look lost, or “hi, which room are you looking for?” if they’re staring at the schedule is all it takes. Most people are happy to ask when you approach them first, but they might not want to bother anyone or they might not even know you’re there to help.
Another tip is to hand out evaluation forms when people walk in and let them know that you’ll collect them at the end of the session. We noticed in Oslo that we got a lot more evaluation forms when we handed them out instead of placing them on the chairs, and it was the same in Portland. Feedback means a lot to speakers, so make sure you get them as much feedback as possible.
In the middle of the day I was assigned to monitor the speaker room, but speakers usually know how to take care of themselves :) I got to attend a session I wanted to see, and also tried to help out where needed. There was a great effort during multiple sessions and breaks to get all the SpeedPASSes printed, sorted and distributed. SpeedPASSes are a great idea, but they have been a major cause of headache at all the SQLSaturdays I’ve attended so far. Many people don’t know about them, many people forget them, and many people don’t have a printer available.
That means you will need a printer and scissors on-site and a dedicated volunteer to manage printing. The SpeedPASS files are named based on the registration number instead of the attendee name, so you will need to cross-check with your registration list to find the right SpeedPASS. There will most likely be a queue and attendees will spend time cutting their SpeedPASS instead of talking to sponsors or attending sessions. In Oslo we printed and cut the SpeedPASSes for all the attendees before the event. Unless I, PASS or SQLSaturday organizers come up with a better idea than SpeedPASSes, I will gladly spend hours next year getting blisters from cutting more SpeedPASSes – if that means that attendees get a better experience.
Turns out I wasn’t just going to be a volunteer that day. When we arrived a friend of mine was asked to do a SQL Excite presentation since they had open slots. These are 5-minute, fast-paced presentations with 20 slides set to advance every 15 seconds. I jokingly told my friend that it would be fun to do a Biml presentation, then I happily walked off to do my volunteer tasks and didn’t think much more of it… until I got a message that he had asked the organizers if I could present instead of him, they had said yes, and I would be speaking in 30 minutes.
I spent all 30 minutes creating a 5-minute introduction to Biml, and had literally just finished the last slide in the auditorium as I was called up on stage. The presentation was based on my 1-hour Biml session so I knew most of the content, but I had not prepared at all what to say to each slide until I was actually on stage. My timing was off on several slides, and it certainly was a challenge not being able to advance my slides myself, but it was so fun! I absolutely loved it.
Thank you to the organizers for giving me the opportunity to speak. Thank you to my friend who didn’t give me the option to say no, and who also filmed so I could watch my presentation after I had finished. And thank you to the attendees who gave me evaluation forms! My cats seem to be popular.
I hope to see you next year, Portland! Maybe with a proper, prepared session :)
I was honored to be selected as a speaker for SQLSaturday #341 in Porto, Portugal this weekend, and I had such a great time that I hope to come back next year for SQLSaturday Lisbon or SQLSaturday Porto.
First of all I want to say a huge thank you to everyone who organized and volunteered at this event. You guys did an amazing job and I hope you finally got some sleep after working around the clock for a week! Niko, Paulo, Ivan, Rui, André, Pedro, Vitor, Quilson and Nuno – thank you. I also want to thank Ines for being our photographer, she was running around everywhere all day taking pictures and filming. I can’t wait to see the result! :)
SQLSaturday #341 Porto Speakers and Organizers
This was a very special and memorable weekend for me. It was my first trip to Portugal and the first time I was selected as a speaker for a SQLSaturday other than my own event. It was a very different experience being there as a speaker compared to being an attendee, volunteer or organizer. As an attendee and volunteer I want to learn as much as possible and help out where needed, as an organizer I’m in the middle of a crazy whirlwind trying to remember everything I need to do, and as a speaker I have one main goal: that the attendees in my session will learn something they can start using in their projects right away.
The most interesting and important experience was when my presentation did not go as I had planned at all. My computer decided that “Nope! I do not want to be friends with the projector today!” and my demo-based session suddenly had no demos at all because I couldn’t use my computer. I panicked for a moment, but did my best using my presentation with screenshots of the demos. At the end of my session I invited those interested to come up on stage and see the demos on my computer. I just hope they learned something even though the session didn’t go as planned.
There was a SQL Clinic with Scott Klein and friends, where most of the speakers were available for an hour or more during the day. This was a great concept, but I think most attendees preferred to attend sessions because not many people showed up. I was happy fellow Biml enthusiast João (@SQLSniper) and I could help one attendee with some tasks he was struggling with at work :) Maybe it would have been better to have it closer to the sponsors and snacks where attendees spent most of their time during breaks? Maybe it just needed a bit more promotion? I hope to see something like this again, it was a great way to meet attendees and share even more knowledge.
The speaker room was located in a separate hallway with direct access to the classrooms, which made it really easy to bring laptops and equipment in and out of the sessions. There was also a coffee bar at the venue where they served the cute, little caffés that are like caffeine shots compared to the liters of coffee I usually drink every day ;) I was also happy to see a lot of activity and pictures on Twitter, that’s always fun!
Except for my session problems it was a great day and a well organized event. The organizers did an amazing job, from an exciting keynote with lots of announcements to the fun end-of-day raffle where international speakers tried to read Portuguese names :)
Thank you all for a great event, thank you for taking such good care of my the whole weekend, and I hope to see you again soon!