Are you tired of right-clicking on your Biml files to Check Biml for Errors or to Generate SSIS Packages? Did you know that you can create your own BimlExpress Keyboard Shortcuts? :)
Go to Tools → Options:
Select Environment → Keyboard, then type Biml in the Show commands containing box:
Select a Biml command, click in the Press shortcut keys box, click the keyboard shortcut combination of your choice, and click the Assign button. In this example, I have used Ctrl+Shift+C, Ctrl+Shift+B (I chose C then B for “Check Biml”):
Click OK, and that’s it! You can now use your keyboard shortcuts while having one or more Biml files selected. The shortcuts will appear in your BimlExpress menus in the toolbar and when you right-click on a file :)
Woohoo! 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 :)
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!
I’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 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.
Since 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.
On July 23rd I will be speaking at SQLSaturday Sacramento 2016! This will be my first time visiting California, so I’ve planned a day of sightseeing in San Francisco before heading up to Sacramento. There’s a big chance I’ll melt in the Californian summer heat and never come back, haha! But hopefully I’ll be able to finish my sessions first :D
This will be the first time I present two sessions at one SQLSaturday. My first session is Level Up Your Biml: Best Practices and Coding Techniques. Depending on your previous experience with Biml and C#, this is an intermediate or advanced session. I’ll cover things like code management, LINQ and how to create your own C# classes and methods.
My second session is Tools and Tips: From Accidental to Efficient Data Warehouse Developer. This is a fun, fast-paced session with a whole bunch of tips and tricks. I don’t really go into details on anything, but I hope that new developers can pick up a thing or two. And here’s a little secret for you: I will be giving away a free software license to one lucky attendee in this session! And maybe a book or two. And definitely some Norwegian chocolate if you want to try it.
The first time I submitted to PASS Summit was in 2015. My Lightning Talk was accepted, and I was so excited about getting the opportunity to speak at the largest SQL Server conference in the world! I had a fantastic time, so I decided to try again and submit for PASS Summit 2016 as well.
While on vacation in Spain with my family, I woke up to an e-mail from PASS HQ. The Call for Speakers Results! I was reading the e-mail on my phone, so it felt like I was scrolling and reading and scrolling and reading and scrolling and reading until I finally got to the actual results.
I didn’t just get one of my sessions accepted. I got 2 general sessions and 1 lightning talk accepted. I nearly fainted! I had to read it several times before it sunk in. I’m going to speak at PASS Summit 2016. Not once. Not twice. But three times in one week.
I have mixed feelings. I’m super excited, super happy, and extremely honored to be selected! But I also know several amazing speakers who definitely should speak at the PASS Summit who weren’t selected this year. In one way it feels like I stole a session from someone who deserves it more than me. At the same time, I literally jumped around of joy when I read my e-mail. It’s difficult. I’m happy that I was selected, I’m happy for the other speakers who were selected, I’m especially happy for my friends who are speaking at the PASS Summit for the first time, but I’m also sad to hear about all my friends who weren’t selected. But next year! I’ll cross my fingers that it’s their turn next year :)
My sessions at PASS Summit 2016
I will present three sessions at PASS Summit 2016:
The Biml for Beginners session is one of my favorites, and I’m so happy I get to present it at PASS Summit! :D I’m happy I have 15 minutes extra compared to the usual 60-minute sessions at SQLSaturdays. It allows me to go a little more into detail on some of my demos, or spend more time on audience questions. This is going to be fun!
I’m also really excited about presenting a Professional Development session and a Lightning Talk version of it. Volunteering has truly changed my life. I would not be where I am today if it wasn’t for getting involved in the PASS and SQL Server community. I hope that I can pay it forward and inspire someone else to get involved – maybe an upcoming SQLSaturday organizer or speaker? :)
Every PASS Summit I’ve been to has been a new and unique experience. I can’t wait to see what PASS Summit 2016 is going to be like! I’m sure I will be freaking out about my sessions :D But I also know I will have lots of fun, and I can’t wait to see lots of friends from all over the world again. YAY!
Several speakers have shared their abstract feedback after the results were made public. Brent Ozar has added a list of these speakers to his own feedback post. I appreciate the transparency, I learn a lot from reading other people’s feedback, and I hope that it will help the community as a whole and improve the selection process next year – so I’m jumping on the bandwagon :)