It’s that time of year again… The largest, coolest, geekiest, most awesome party of the year is just around the corner! Oh, and there’s this conference attached to the party as well. SQLBits 2018: Magic Edition. You may have heard of it? :D
SQLBits is the largest SQL Server and Microsoft Data Platform conference in Europe. It has 4 days of training and over 170 sessions by both the Microsoft Product Group and community speakers. It’s a professional conference in all ways, and it’s organized entirely by a group of dedicated volunteers. That’s right, it’s a pure community event, and it’s fantastic.
I was a speaker and volunteer at SQLBits 2015 (Superhero Edition), a precon speaker at SQLBits 2016 (Space Edition), a PASS representative at SQLBits 2017 (Disco Edition), and I’m very happy to go back to where I started as a speaker and volunteer at SQLBits 2018 (Magic Edition). I was actually really bummed when I wasn’t a volunteer, it’s so much fun helping out to make it a smooth conference for attendees and getting to know all the other wonderful volunteers. This year, I’m back! Yay :)
Continue reading →
Do you want to learn more Biml? Have you always wanted to visit Chicago? Are you free on March 16-17? Then check out this amazing, once-in-a-lifetime offer just for you! …
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.
Continue reading →
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! :)
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 :)