Precon and Speaking at SQLSaturday Nashville 2018

SQLSatNashWoohoo! I’m very happy to announce that Jason Horner (@jasonhorner) and I will be presenting a precon at SQLSaturday Nashville 2018! The precon will be held on Friday, January 12th, and is focused on SSIS and Biml. We will also be at the SQLSaturday where Jason will be presenting about Dimensional Modeling and I will be presenting about Biml. This will be my first time visiting Nashville, so I’m very much looking forward to it :)

SQLSaturday Nashville 2018 Precon (Jan 12)

Jason Horner and Cathrine Wilhelmsen presents ETL Design Patterns at SQLSaturday Nashville 2018

Jason had been working on a precon idea for a while that would bring together all his experience using SSIS to deliver ETL projects. I wanted to develop a new precon focusing on Biml and SSIS. Instead of working on two separate precons, we decided to team up and combine our knowledge. We will be delivering this precon for the first time in Nashville, and we’re looking forward to helping attendees by providing guidance on how to solve challenges they might face in their projects.

You can read more about why we wanted to present this precon in our interview on the Nashville BI User Group website.

Check out the full abstract and register for our precon on bit.ly/ETL-Precon-Nash. A regular full-day is only $129, and for only $165 you can also attend one of the half-day precons on Thursday. What a bargain!

SQLSaturday Nashville 2018 Sessions (Jan 13)

Jason and I are also presenting a regular session each. Jason will be presenting his Dimensional Modeling Design Patterns: Beyond the Basics session, and I will be presenting my Biml for Beginners: Speed Up Your SSIS Development session.

Check out the full SQLSaturday Nashville schedule and register today to get all the news and updates. You can also follow @SQLSatNash on Twitter and use the hashtag #SQLSatNash to join the conversation. Please help spread the word to all your friends and coworkers, and make sure you sign up before the event is full.

Hope to see you in Nashville in January! :)

Speaking at SQLSaturday Denver 2017

Cathrine Wilhelmsen Speaking at SQLSaturday Denver 2017

On Saturday, September 16th, I’m speaking at SQLSaturday Denver 2017! I’m presenting my Level Up Your Biml: Best Practices and Coding Techniques session: Learn how to centralize and reuse code with include files and the CallBimlScript methods. Make your code easier to read and write by utilizing LINQ (Language-Integrated Queries). Share code between files by using Annotations and ObjectTags. And finally, if standard Biml is not enough to solve your problems, you can create your own C# helper classes and extension methods to implement custom logic.

Since I last presented this session, BimlExpress 2017 has been released with a bunch of new features. I have updated my session to include some of these new features, and I’m looking forward to presenting with the new preview expanded Biml pane. Being able to see the expanded Biml is hopefully going to make it a lot easier for me to explain some of these things and for attendees to follow along :)

If you really like Biml, check out the three other Biml sessions at SQLSaturday Denver: Biml 101: Automation and Patterns by Yuliya Quintela, Stop Repeating Yourself – Automating Azure Data Movement With BimlScript by Levi Syck (@levisyck), and Metadata driven development by Bill Fellows (@billinkc).

Will you be attending SQLSaturday Denver? Come and say hi when you see me! :)

3 Mistakes I Made While Presenting Remotely

3 Mistakes I Made While Presenting RemotelyTwo years ago I wrote about my experiences presenting a webinar for the first time. I learned a lot that day, and it helped me prepare for presenting remotely. But, a webinar is not the same as a remote presentation. And as much as you prepare and rehearse, you just won’t be prepared for every little thing that might happen until you’ve experienced them. So in addition to the advice I shared in my other blog post, here are 3 of my mistakes you don’t want to make if you’re planning to start presenting remotely :)

I didn’t ask the organizers enough questions before I started presenting

How many people are attending? What does the room look like? Is the screen large or small? Are people sitting close to the screen or in the back of the room? Can you see my webcam? Where is my webcam placed on the screen that the attendees see? Will I see your webcam?

I should have asked the organizers to spend 5-10 minutes with me before the session started so I could get a better idea of who I was presenting for and what they would see. When presenting live, I walk to the back of the room to check how much I need to zoom in during demos. I can see what everyone else sees on the screen. I can adjust to different room layouts. When presenting a webinar, I know that everyone will see the same as me on their own screens. I can watch my own webinar on a second screen so I can adjust to the lag. When presenting remotely, I don’t know anything about what the attendees see unless I ask. Maybe my webcam covered parts of my demo? Maybe I clicked too fast through my slides? I don’t know, but I should have known.

I didn’t test running all my software at the same time

We did a test call and Skype, my camera and my microphone all worked. But generating SSIS packages from Biml in Visual Studio at the same time as sharing my webcam plus my sound plus my screen? Uh, yeah, that didn’t really go too well on my old and tired laptop. Demos that usually take 2-3 seconds ran for nearly 30 seconds. Demos that usually take 30 seconds (and make my Visual Studio stop responding just long enough for me to grab a sip of water and joke about it) ran for several minutes. It felt like an hour. I don’t have that many jokes! I ran short on time because of this.

Waiting... Waiting... Still waiting...

I should have tested more before starting my presentation. While asking the organizers questions before the meeting (see previous point), I should also have asked them to do a quick dry run with me. They could have given me feedback on the most important part of my demos: Was everything visible from the back of the room? Is the call quality good enough to present in regular speed, or do I need to slow down more? And most importantly – does everything actually work with all the software I’m running at the same time?

I stared at my microphone while presenting

I used a Jabra speakerphone, that flat, round gadget that looks like a hockey puck. It was next to my keyboard, and I kept staring at it all through my presentation. Because, you know, all the attendees were sitting inside it, and I was presenting for them :)

I should have looked more into the camera. I didn’t, I looked at where the sound came from. I also leaned down several times to hear questions better, which must have looked rather funny. I’ve only presented with headphones in the past, so this was a new experience for me. I should have rehearsed more with this camera and microphone setup to get used to where to look and what gestures to make.

I made these mistakes so you won’t have to!

Well, ok, I didn’t do it on purpose ;) But I do hope you can learn something from my mistakes, so you will become a way better remote speaker than me! I also hope you can learn something from my previous experiences. What advice would you give to new speakers who are presenting remotely?

Presenting remotely for Malta Microsoft Data Platform User Group

Cathrine Wilhelmsen Presenting for Malta Microsoft Data Platform User GroupWoohoo! On Tuesday, March 28th, I will be doing a remote session for the Malta Microsoft Data Platform User Group. I will be presenting my Biml for Beginners: Speed up Your SSIS Development session, one of my favorites :)

The meeting starts with my remote session, then there’s a short break before moving on to Gossip Geek – “… your one and only source into the fabulous lives of Geek’s elite…”. I have no clue what that is, but it sounds fun, so make sure to attend if you’re in the area :D And if Business Intelligence, SSIS and Biml is not your thing, maybe Columnstore Indexes are? The meeting finishes with Slawomir Drzymala (@sdryzmala) presenting Columnstore Index – do we need another one?!.

The Malta Microsoft Data Platform User Group is brand new. It was started in January 2017, and this will be their third meeting. I’m very happy I get to help support a new local group! If you’re a speaker and want to do a remote (or on-site!) session, you can find Malta Microsoft Data Platform User Group on Meetup, Facebook and Twitter (@MMDPUG).

And of course, if you’re from Malta, make sure you join and attend the meetings! If the sessions that day aren’t super interesting, attend anyway for the networking :)

Wow, I haven’t written one of these posts for a long time! It feels great to slowly move back into the world of speaking again. Thanks for inviting me to speak, MMDPUG! I wish I could be there in person, but I’m really looking forward to presenting for you :)

Speaking at Microsoft Ignite and SQLSaturday Minnesota

Hello, cold weather! I can’t believe it’s the middle of September already. Since I last wrote here I’ve been on vacation in Colorado, organized the third SQLSaturday in Oslo, road tripped around the fjords and mountains on Norway’s west coast, and worked three days a week for my client in Stockholm. But those are stories for later blog posts, Instagram, Facebook and Snapchat :) Now we’re back to speaking season!

Microsoft Ignite

Cathrine Wilhelmsen Speaking at Microsoft Ignite 2016I’m speaking at Microsoft Ignite! Whoa! I decided to give it a try and submit a session, but I never thought I had a chance since I’m speaking about Biml, a third-part product. But whaddayaknow, they selected my session! And my hubtalk! I was shocked, now I’m just nervous :) I’ve never been to a conference this large before, so I don’t really know what to expect.

On Tuesday, September 27th, I will present Avoid repeating yourself – an introduction to Agile SSIS development. It’s a 20-minute version of my Biml for Beginners session. Since I don’t have a lot of time I will focus more on the why than the how. Exciting!

On Thursday, September 29th, I will host an Automate Data Warehouse and Business Intelligence development hubtalk. A hubtalk is more like a discussion than a presentation, and I will be drawing on a Surface Hub. (So nervous!) I will be talking about Biml and metadata-driven development, and I hope to get a good discussion going with the attendees and learn from their experiences as well.

SQLSaturday Minnesota

Cathrine Wilhelmsen Speaking at SQLSaturday Minnesota 2016Since I was already going to the US, I wanted to try to squeeze in a SQLSaturday as well. I may be slightly addicted :D I really wanted to go to Kansas City since they have a Biml track, but I just couldn’t get it to work this time. However, I managed to get good tickets to Minnesota the weekend after! I originally registered as an attendee, but offered to step in as a speaker when someone had to cancel.

So – I’m speaking at SQLSaturday Minnesota as well! :) On Saturday, October 1st, I will present my Level Up Your Biml: Best Practices and Coding Techniques session. Dave DuVarney (@daveduvarney) will present Building Metadata Driven ETL Solutions with BIML before me, so I hope it will be a great day for those interested in learning Biml.

Are you going to Microsoft Ignite or SQLSaturday Minnesota? See you there! :)

Page 1 of 7 1 2 3 4 5 ...Last »