Skip to content

Speaking at SQLSaturday Oregon 2018

Cathrine Wilhelmsen is Speaking at SQLSaturday Oregon 2018

Anniversary, yay! That’s right, this year I will be attending my fifth SQLSaturday Oregon :D

In 2014, I was a volunteer who ended up doing an impromptu lightning talk about Biml. I returned as an actual speaker in 2015 and 2016, presenting my Biml sessions. 2017 was a different experience when I attended as a PASS representative. In 2018, I’m back as a speaker.

SQLSaturday Oregon 2018 Schedule

But for the first time at SQLSaturday Oregon, I will not be speaking about Biml :) This year, I will present a brand new session called Uhms and Bunny Hands: Tips for Improving Your Presentation Skills.

Continue reading →

Interview about Azure Data Factory Updates

Last year at Microsoft Ignite, I was fortunate enough to interview Mike Flasko and Sanjay Krishnamurthi. This year, I got to have a follow-up chat with Mike Flasko and Sharon Lo! We talked about the recent and upcoming Azure Data Factory updates :)

In this interview, Mike and Sharon share the highlights from their session at Microsoft Ignite 2018. What are visual Data Flows? How are Azure Data Factory Data Flows different from the recently announced Power BI Dataflows? What’s on the Azure Data Factory roadmap? And finally, how can you provide feedback and get involved in private previews?

Azure Data Factory Updates with Mike Flasko and Sharon Lo

(I apologize for the unsteady video :( Unfortunately, I didn’t see how shaky it was until post-production. If it gets too distracting to watch, please just listen. Mike and Sharon share a lot of interesting things :) )

Thank you so much to Mike and Sharon for chatting with me on a busy day!

Continue reading →

Ready for Microsoft Ignite 2018!

My Microsoft Ignite week is just about to start, and I’m SO excited! I’ve been looking forward to this week since last year, and it’s finally here, yay :) 

Microsoft Ignite: See you in Orlando!

Since this is such a huge, special event, I try to make the most of it. And funnily enough, that means… Attending fewer sessions! Yep, that’s right. It sounds a little strange for a conference, I know. But to me, the biggest value comes from meeting other people, and maybe even help someone else. So while I have a few sessions on my must-see list, my schedule is packed with other fun things:

Sessions

Cathrine Wilhelmsen Speaking At Microsoft Ignite 2018

I’m presenting two sessions this year, so they are obviously on my list of things to do ;) You can read about my sessions in my previous blog post Speaking (Twice!)

Live Streams and Recordings

Microsoft Ignite: Stream it Live from September 24-28

If you can’t make it to Microsoft Ignite this year, don’t worry! You can live stream all the sessions from September 24-28th, or watch the recordings on-demand from September 25th.

Group Idea Swaps and Mentoring

In addition to presenting two technical sessions, I will be leading two Group Idea Swaps and Mentoring sessions. Each group consists of only 8-10 attendees, so it will be much more like a conversation than a presentation. I’m really looking forward to this! I love how Microsoft has added this to focus more on interaction and personal connections this year :)

My two Group Idea Swaps are:

Continue reading →

SSMS Results Grid Not Showing Ellipses

Earlier today, I ran into an interesting “feature” in the SQL Server Management Studio (SSMS) Results Grid.

During development, I found what appeared to be duplicate data. Uh-oh! I spent three hours debugging my query, looking into the underlying ETL, and doing all kinds of tests. I absolutely could not figure out what was wrong!

Then it hit me. Maybe my query was fine? Maybe the problem was how the results were displayed in the SSMS Results Grid? I tried expanding the columns. And sure enough. There it was. All my data, perfectly fine.

Facepalm.

After facepalming, I started laughing. One of my Norwegian phrases is “erre mulig!?” It roughly translates into an exasperated, humorous “how on earth is that possible!?” I kept laughing. And of course, I had to tweet about my fail of the day:

Continue reading →

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