Skip to content

SQL Data Partners Podcast – Is SSIS Still Relevant?

SQL Data Partners Podcast

In 2015, I was invited to record a SQL Data Partners podcast about Biml. This year, I got to do it all again, yay! :) I joined Jason Horner and our host Carlos L Chacon to discuss several data integration topics. Is SSIS still relevant? What is the difference between ETL and ELT? How is Azure Data Factory and Azure Databricks different from SSIS? How do patterns and frameworks fit into all of this? And much, much more :)

SQL Data Partners Podcast – Part 1

Moving data with SSIS is a forgone conclusion for most of us — it is part of SQL Server, it has a interface we are somewhat familiar with, and connects to lots of common data sources like csv, excel, and of course SQL Server. Are our needs changing as our environments become more hybrid — as we introduce cloud services? Are you still building packages the same way you were 10 years ago? Just as our data sources have grown, the capabilities needed to move data around have increased. This episode, with Jason Horner and Cathrine Wilhelmsen, challenges some of the thoughts around data movement and gives some things to think about as new tools are available to move data around.

Listen to Episode 144: Is SSIS still relevant? Part 1

SQL Data Partners Podcast – Part 2

In this episode we finish up our conversation with Jason and Cathrine and talk about how they keep up with all the changes in data conversions. The advent of Azure services is great, but can be tricky to navigate. We also get to hear Jason’s answers to the SQL Family questions.

Listen to Episode 145: Is SSIS still relevant? Part 2

Don’t Repeat Your Biml – C# Extension Methods

Don't Repeat Your Biml - C# Extension Methods

In a previous blog post, we looked at how to use C#/VB Code Files in Biml. There are several benefits to moving custom C# code into separate files. It allows you to reuse that code across multiple projects and solutions. You can maintain the code in your editor of choice, taking advantage of intellisense and syntax highlighting. And finally, my personal favorite: you can create custom extension methods.

In this post, we will look at how to simplify our Biml projects by creating and using C# extension methods. We will build on the examples from the previous C#/VB Code Files in Biml blog post.

Continue reading →

Speaking at SQLGLA 2018

Cathrine Wilhelmsen is speaking at SQLGLA 2018

On Friday, September 14th, I will be speaking at SQLGLA 2018! This is the only free Data Platform community event in Scotland. I’m super excited about being part of it this year, and I can’t wait to visit Scotland for the first time :)

I will be presenting my Tools and Tips for Data Warehouse Developers session. This is a fast-paced beginner-level session where I share things I’ve learned over the years. Topics include features in SSMS and SQL Operations Studio, keyboard shortcuts, free tools and scripts, and of course – Biml!

SQLGLA 2018 Schedule

There are a total of 4 tracks and 24 sessions, so there should be something for everyone: PowerShell, Containers, R, Power BI, Azure Data Factory, SSAS… You name it. Just take a look at the full schedule!

(This will be a fun, friendly, and inclusive event, so please also read the Code of Conduct.)

In addition to speaking, I also signed up as a volunteer. I get to room monitor a few of the sessions that I was already planning to attend, yay! This is such an easy way to give back and help the organizers. If you have never volunteered before, I recommend giving it a go. Volunteering helped me get over my shyness, and got me into speaking! A community event like SQLGLA is the perfect place to start :)

Hope to see you at SQLGLA 2018!

TENK Tech Camp 2018 – Experiences Volunteering

TENK Tech Camp 2018 was a 2-day event for teenage girls who are interested in technology and science. On August 9-10th, 2018, over 200 girls gathered at Teknisk Museum (Norwegian Museum of Science and Technology) in Oslo, Norway to attend workshops about coding, hacking, artificial intelligence, chatbots, design thinking, app development, web development – and rocket engineering!

TENK Tech Camp 2018 Attendees

I was honored to participate as a mentor alongside more than 50 other talented women working in STEM. It was an absolutely fantastic experience, and I’m already looking forward to being part of this event again in 2019!

In the videos below, you can see some of my memories from TENK Tech Camp 2018, and the official recap of the event :)

TENK Tech Camp 2018
Cathrine’s memories from TENK Tech Camp 2018
TENK Tech Camp 2018
Official video from TENK Tech Camp 2018
Continue reading →