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

Speaking at Microsoft Ignite 2018 (Twice!)

I am so happy and honored to have been invited to speak at Microsoft Ignite 2018! This year, I’m presenting two sessions focused on Azure Data Factory (ADF). The first is a 45-minute breakout session that I’m presenting with Jason Horner. The second is a 20-minute theater session that I’m presenting by myself :)

Cathrine Wilhelmsen Speaking At Microsoft Ignite 2018
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!

Speaking at SQLSaturday Oslo 2018

SQLSaturday Oslo 2018In exactly one month from now, on September 1st, I will be speaking at SQLSaturday Oslo 2018! This year is a small milestone for us, as it is our fifth SQLSaturday in Oslo. Woohoo!

SQLSaturday Oslo 2018 Schedule

I will be presenting… Actually, hang on! I will get back to that in a bit. Scroll down for some rambling about my session :) But first, the important stuff:

There are 30 sessions by 27 speakers from 11 countries scheduled this year.

Of the 27 speakers, there are 7 women, and 4 of the women are Norwegian! These are amazing numbers for an event like this. I am SO proud and SO happy :D Thank you to the organizers for encouraging and supporting women in tech, and a huge thank you to these amazing women for being great role models: Dagrun Haugland, Gabi Münster, Ida Bergum, Kathi Kellenberger, Sara Jønvik, and Steph Locke.

There are also 3 Norwegian men speaking! Very happy to see Helge Rege Gårdsvoll, Martin Keseler Barland, and Antonio Abalos Castillo back at SQLSaturday Oslo. That makes it a total of 7 Norwegian speakers this year. Woohoo!

Finally, there are 4 precons scheduled: You can learn about Azure SQL Data Warehouse from Simon Whiteley and Terry McCann, SQL Server Tools for Query Tuning from Grant Fritchey, PowerShell and SQL Server from Rob Sewell and Drew Furguiele, or R for Everyone from Steph Locke.

You definitely don’t want to miss this event. Register now! And follow @SQLSatOslo and #SQLSatOslo on Twitter to join the conversation. Hope to see you in September! :)

From SQLSaturday Oslo 2014 to SQLSaturday Oslo 2018

Ok, now that we have the important parts out of the way, let’s return to my session. Did you know that the very first technical session I ever presented was at the first SQLSaturday Oslo in 2014? I presented a session called Generate SSIS packages automatically with Biml and BimlScript. This year, I will be presenting my updated Biml for Beginners: Script and Automate SSIS Development session.

Same topic, same basic concept and ideas, some similar visualizations, but a very different session. And I mean in more ways than going from 4:3 to 16:9:

I have changed

SQLSaturday Oslo 2014 - Cathrine Wilhelmsen - Slide 1 SQLSaturday Oslo 2018 - Cathrine Wilhelmsen - Slide 1
My hair is much longer and my URL is much shorter. I’ve become a BimlHero and Data Platform MVP, and I’ve co-authored two Biml books. And it all started with this one Biml session back in 2014! Crazy :)

Continue reading →

Speaking at SQLGrillen 2018

SQLGrillen 2018On Friday, June 22nd, I will be eating bratwurst, drinking beer, and talking about Biml at SQLGrillen 2018 in Lingen, Germany. I will leave it up to you to rank the importance of those three things. What I will say is that I’m thrilled and honored to be a part of it this year! I have watched the event grow from a small, local event to breaking all records this year. There will be three precons, five tracks, 35 sessions, 200 attendees, and lots and lots and lots of fun. The tagline is literally “SQLGrillen: Databases, Bratwurst & Beer” – how can that not be an amazing event :)

If you think this sounds fun and want to squeeze in a trip to Lingen, this is your lucky day! There are a few last-minute tickets left. Go grab one before it sells out!

SQLGrillen 2018 Schedule

I will be presenting my brand new session Biml Tips and Tricks: Not just for SSIS packages! That’s right, I won’t be generating a single SSIS package in my session. (If you want to learn how to do that, go to Ben Weissman’s session Let’s build SSIS packages with Biml – live!) In my session, I will show you how to use Biml for other things, like generating T-SQL, creating test data, populating static dimensions, and comparing tables and views across databases. I really should have called my session “Cathrine does crazy things with Biml”, haha!

If Biml is not really your thing, check out the rest of the schedule and speaker list. Wow.

Newcomer Track at SQLGrillen 2018

My favorite part of SQLGrillen 2018 is the Newcomer Track. Seven brand new speakers will get the chance to speak at a conference for the first time! Each newcomer was assigned a mentor to help them prepare for their session. I have been helping Robert French (@sql_bob) over the last few months, and I think I’m even more excited to watch him present than I am about my own session! Robert is presenting his great session Soft Skills for Success. I know it’s great because I got a sneak peek while he was rehearsing :D

See you there?
While we are waiting, join the conversation on Twitter by following @SQLGrillen and using the hashtag #SQLGrillen.

Please let me know if you are attending SQLGrillen 2018 so I can say hi! :)

Page 1 of 16 1 2 3 4 5 ...10 ...Last »