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! :)
I spent most of July 1st relaxing in the sun, reading The Hitchhiker’s Guide to the Galaxy and enjoying my vacation. I spent the rest of July 1st reading, re-reading and re-re-reading the e-mail I received from Microsoft congratulating me with my first MVP Award.
Unfortunately my copy of The Hitchhiker’s Guide to the Galaxy did not have Don’t Panic written in large, friendly letters on the cover. So I panicked a little. I think I may have panicked more than just a little. Actually, I’m pretty sure I panicked a lot:
You see, I had mixed feelings about becoming an MVP. I am truly honored and thankful, but it is also very intimidating to be part of a group with so many talented people that I admire. I don’t have decades of experience, I’m not a SQL Server expert, I haven’t published any books and I haven’t created any scripts that are used all over the world. Why should I deserve to become an MVP? I panicked a little (or a lot) because I compared myself to those who are years ahead of me down the road, and because it felt like I cut in line in front of amazing people who deserves the award more than me.
So I took a step back and thought about what the MVP Award means to me. To quote Microsoft: MVPs are community leaders who’ve demonstrated an exemplary commitment to helping others get the most out of their experience with Microsoft technologies. They share their exceptional passion, real-world knowledge, and technical expertise with the community and with Microsoft.”
To me, it’s all about community. I may not be the most experienced SQL Server expert, but I helped restart SQL Server User Group Norway. I was the main organizer of the first SQLSaturday in Oslo and currently organizing the second one. I’ve volunteered and presented sessions online, in Europe and in the US. I blog, I tweet and I do my best to help others.
And I love it. Being recognized by Microsoft and getting a thank you for what I have done this past year means so much to me. Thank you to everyone who has been there for me and believed in me, it means more to me than I can say. Receiving the MVP Award inspires me even more to give back and pay it forward, to keep learning and sharing my knowledge, to help grow the Norwegian SQL Server community.
T-SQL Tuesday #68 is hosted by Andy Yun (@SQLBek). Many SQL Server defaults are not ideal, and most of us have a list of defaults we always change. Andy wants us to Just Say No to Defaults and blog about what, why or how we change defaults.
If you are an SSIS developer like me, there is a big chance that the ProtectionLevel in SSIS Packages is on top of your list of defaults to change. The default ProtectionLevel is EncryptSensitiveWithUserKey (ugh), but most of the time it is not the best option. Raise your hand if you have ever asked your favorite search engine for advice on issues like “SSIS package fails in SQL Server Agent job” or if you have ever heard someone exclaim “but it works on my machine!?” :)
There are many great blog posts about the different ProtectionLevels, why you probably want to change to DontSaveSensitive as your default, and how to use configurations and parameters instead of encrypted SSIS packages. I will not go into details about any of that in this post, but I will use ProtectionLevel as an example default property you want to change in many SSIS packages at the same time.
How do you batch update properties in existing SSIS packages? You probably don’t want to open up every single package and change them manually?
This post was first published in July 2015, and was last updated in August 2018.
One of the main tasks in Biml projects is to import source metadata. The recommended method is GetDatabaseSchema. This method returns an ImportResults object that contains SchemaNodes (schema metadata) and TableNodes (table and view metadata).
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.