Ok, ok, ok, I may have gotten a little carried away :) But I am excited to announce that I will be presenting a precon at SQLSaturday Chicago 2018! The precon will be held on Friday, March 16th, and is called Level Up! From Basic Biml to Automated Data Warehouse Frameworks. I will also present a general session on Saturday, March 17th.
Woohoo! 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 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! :)
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! :)
It’s November, and that means I’m now officially a PASS employee! Yep, that’s right, I will be taking over as the PASS Community Evangelist after the wonderful Karla Landrum (@KarlaKay22). And to tell you the truth, it’s both extremely terrifying and super exciting at the same time :)
Many of you heard the news at PASS Summit 2016 after we announced it during the SQLSaturday organizers meeting, and I would like to say a huge thank you to everyone who congratulated me afterwards. You are the community, and it truly means a lot to me to hear that you think I’m the right person for this role.
Why did you accept the job as a Community Evangelist?
My family and best friends in the community weren’t surprised when I told them :) The PASS and SQL Server community has been such an important part of my life for the past three years. Getting involved has literally changed my life. At my first PASS Summit in 2013 I was a shy, socially awkward person who was terrified of talking to people. At PASS Summit 2016 I was a speaker presenting two regular sessions and a lightning talk, and my favorite part of it all was getting to know lots of amazing new people. Volunteering in this community has given me so much, and this is my chance to give something back.
Does that mean you won’t be working in tech anymore?
Well, yes. I won’t work as a consultant or architect or developer and I won’t get hands-on experience with projects and clients. This is a full-time community job. I’m sure I will miss working in tech, but I will try to keep up with everything that’s going on in the Microsoft Data Platform world at events and on weekends. (Because, you know, once a geek, always a geek!)
What will you do as a Community Evangelist?
Support regional mentors, chapter leaders and SQLSaturday organizers, and look for opportunities to establish new chapters and SQLSaturdays. I will also be administering the SQLSaturdays and help events go live, blog, monitor social media, and work with the PASS Board of Directors and PASS Headquarters to support global growth.
Will you continue speaking and blogging?
Part of my job as a Community Evangelist is to share everything that PASS has to offer and opportunities for volunteering, especially at events where people are new to the PASS community. That means I will still be speaking, but I will be speaking as a PASS representative, for example doing lunch sessions at SQLSaturdays. However, I will no longer be submitting to speak at PASS events like I used to. I will definitely still be blogging, and I hope that I actually may get back to blogging more regularly – especially when my fingers start itching to get some hands-on experience with Biml and SQL Server again :)
WHAT WILL WE DO WITHOUT KARLA!?
PANIC! No, hopefully not :) Karla has been a fantastic Community Evangelist and I know people all around the world will miss her terribly! We have started the onboarding and handover process, and we will be working together for a couple of weeks so I can learn as much as possible about the job from her. While I know I won’t be able to fill Karla’s shoes, I promise I will do my absolute best for this community!
This is all you, #SQLFamily. You’re the heart and soul of PASS, just continue doing amazing things for your local communities and I will do what I can in this new role to support you. This is already the best community in the world, let’s make it even better in the next couple of years! :)
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 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.
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.
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! :)