Yay, I’m so excited to finally share these news! Join Scott Currie (@ScottCurrie) and me for a Biml Training Day at SQLBits XV in Liverpool on May 4th: Learn Biml Today: Start Using It Tomorrow.
Biml Training Day at SQLBits XV
Scott and I will guide you through everything you need to start using Biml in real projects. From installing the free Biml tools, to the basics of Biml and BimlScript, to creating a staging environment, to building a metadata framework, and finally how to organize your code, work in a team, and automate deployment. Yep, that’s a lot of content to go through in one day, but you will get all the sample code so you won’t have to start from scratch.
We have very different backgrounds and experiences. Scott created Biml and I work in-house with teams in different countries. We will focus on best practices and code standards, but I’m also looking forward to sharing how we’ve solved problems in different ways. We hope the day will be interesting for everyone, from those of you who are completely new to Biml to those of you who have already built a Biml solution. Bring your questions and real-life problems! And if one day isn’t enough? I’ll be there for another three days :)
Continue reading →
I was a volunteer at SQLSaturday #337 Oregon last year, but to my surprise I also ended up doing a 5-minute SQL Excite session about Biml. It was the first time I spoke in the US, I had so much fun, and I ended my summary blog post with: “I hope to see you next year, Portland! Maybe with a proper, prepared session :)”
And Portland, I’m so happy to announce that I will see you again in just a few days, yay! :D
On Saturday, October 24th I will present my new Biml session called S.M.A.R.T. Biml: Standardize, Model, Automate, Reuse and Transform. It’s a session for those who are already familiar with Biml where I will talk about the more advanced features of Biml and Mist, such as metadata modeling, C# development and transformers.
If you’re not already familiar with Biml, don’t worry! The organizers have done a fantastic job with the schedule so you can attend the What is Biml and why are SSIS people talking about it? session by Bill Fellows (@billinkc) right before mine. Double Biml fun!
I will also spend an hour in the Performance Clinic from 15:30 to 16:30 where I will be happy to answer your questions, chat about Biml or go through code or demos in more detail.
Looking forward to seeing you in Portland! :)
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! :)
The very first SQLSaturday in Sweden, SQLSaturday #433 Gothenburg 2015, will be held on September 5th. I’m very happy to announce that I will be speaking! I will be presenting an updated version of my Biml for Beginners session, and I will also be available the rest of the day if anyone wants to chat about Biml or learn more about the advanced features :)
I was planning to attend this event even if I wasn’t selected to speak since it is the first SQLSaturday in Sweden. It’s so great to see the Nordic PASS community grow, and I want to help and support my neighbors in any way I can. It’s going to be a fun couple of weeks for me doing the whole Scandinavian SQLSaturday tour: SQLSatOslo on August 29th, SQLSatGothenburg on September 5th, and SQLSatDenmark on September 19th. Yay!
Take a look at the great schedule, register, and I hope to see you in Gothenburg! :)
On Tuesday, September 29th I will present my Don’t Repeat Yourself – Agile SSIS Development with Biml and BimlScript session at SQL Server Days 2015! This time I will dive a bit deeper into Biml and BimlScript and show some of the more powerful features like how to create your own methods and transformers.
I’ve heard so many great things about this conference and I’m super happy that I was selected to speak! I’ve never visited Belgium before, so I can’t wait to see some of the country, try some delicious beer and chocolate, and of course – attend great sessions :)
Monday, September 28th – Precon Sessions
50 Things All SQL Server Developers Need to Know by Aaron Bertrand (@AaronBertrand)
Understanding SSIS internals and performance tuning by David Peter Hansen (@DPHansen)
Practical SQL Server Performance Troubleshooting by Klaus Aschenbrenner (@Aschenbrenner)
Prepare and serve machine learning models with AzureML by Nico Jacobs (@SqlWaldorf)
SQL Server In-Memory OLTP and SQL Server 2016 New Features! by Tim Chapman (@chapmandew)
Tuesday, September 29th – Conference Sessions
Conor Cunningham will deliver the keynote on Microsoft’s Data Tier Strategy, followed by great 1-hour sessions that cover all kinds of topics from new SQL Server 2016 Business Intelligence features to SQL Server migrations with PowerShell to Azure Machine Learning and SQL Server security. Check out the great lineup and register before July 15th to get the Early Bird price.
Will I see you there? Come and say hi! :)