Precon and Speaking at SQLSaturday Nashville 2018

SQLSatNashWoohoo! 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 Horner and Cathrine Wilhelmsen presents ETL Design Patterns at SQLSaturday Nashville 2018

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! :)

Speaking at SQLSaturday Denver 2017

Cathrine Wilhelmsen Speaking at SQLSaturday Denver 2017

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! :)

Cathrine + PASS = New Community Evangelist

Cathrine WIlhelmsen is the new PASS Community EvangelistIt’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!

Let’s rock!
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! :)

Speaking at Microsoft Ignite and SQLSaturday Minnesota

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!

Microsoft Ignite

Cathrine Wilhelmsen Speaking at Microsoft Ignite 2016I’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.

SQLSaturday Minnesota

Cathrine Wilhelmsen Speaking at SQLSaturday Minnesota 2016Since 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! :)

SQLSaturday Oslo 2016 Pre-Conference Workshops

SQLSaturday Oslo 2016 Pre-Conference WorkshopsSQLSaturday Oslo is back for the third time in 2016, and this year we are offering four amazing pre-conference workshops! We are very happy to welcome Microsoft Data Platform MVPs Grant Fritchey, Dejan Sarka, André Kamman and Mladen Prajdic to Norway :)

Early Bird Tickets

Early Bird tickets are available until July 1st. For as little as 1200 NOK you can attend a full day of high-quality training with some of the best experts in the world. (That’s less than 1/3 of what you usually pay for high-quality courses like these!) After July 1st the price goes up to 1600 NOK, so make sure you register soon – and bring your coworkers :)

SQLSaturday Oslo 2016 Pre-Conference Workshops

These four pre-conference workshops will be held on Friday, September 2nd in Oslo:

Grant FritcheyQuery Tuning with Execution Plans
by Grant Fritchey (@GFritchey)
Level 200 – Intermediate
At least 80% of all database performance problems can be related directly to your T-SQL code and your data structures. This full-day workshop gets right to the heart of that issue and shows you how to identify common performance problems using the tools available to you within SQL Server.
(…read more and register)

Dejan SarkaData Mining Algorithms in SSAS, Excel, R, and Azure ML
by Dejan Sarka (@DejanSarka)
Level 400 – Expert
Data mining as the most advanced data analysis technique is gaining popularity. With modern data mining engines, products and packages, like SQL Server Analysis Services (SSAS), Excel, R, and Azure ML, data mining has become a black box. This course explains how the most popular data mining algorithms work, when to use which algorithm, and advantages and drawbacks of each algorithm.
(…read more and register)

Andre KammanPowerShell for DBAs
by André Kamman (@AndreKamman)
Level 300 – Advanced – Half-day
DBAs will learn all they need to know today to start using Powershell as their main tool to deploy, manage and monitor their whole environment. We will talk about error handling, creating modules, building in pipeline support, whatif support, logging, parameters and more general Powershell concepts.
(…read more and register)

Mladen PrajdicSecurity Best Practices for SQL Server and Application Developers
by Mladen Prajdic (@MladenPrajdic)
Level 300 – Advanced – Half-day
In this precon we’ll look at how to implement security conscious patterns and practices for SQL and .Net application development like multilayer security architecture and the pessimistic approach. Demo attacks will include SQL Injection (SQLi), Cross Site Scripting (XSS), Cross-Site Request Forgery (CSRF), Distributed Denial of Service (DDOS), Social Engineering (SE) and respective protective measures. We’ll try to blow your mind with what malicious attackers can do to your organization and how to protect against it.
(…read more and register)

Spread the word

We hope you want to help us make SQLSaturday Oslo 2016 a great event for everyone, so tell your friends and coworkers about these pre-conference workshops! If you’re on Twitter, follow @SQLSatOslo and use the hashtag #SQLSatOslo. The SQLSaturday Oslo team and Microsoft Data Platform User Group Norway look forward to seeing you in September! :)

Page 1 of 5 1 2 3 4 5