Cathrine Wilhelmsen

Something went wrong. Please try your request again later.
Follow to get new release updates and improved recommendations
OK
About Cathrine Wilhelmsen
Cathrine loves data and coding, as well as teaching and sharing knowledge 🤓 She is based in Norway and works as a Senior Business Intelligence Consultant, focusing on Data Integration and Data Warehousing. Her core skills are Azure Data Factory, Azure Synapse Analytics, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the Azure and Microsoft Data communities as a Microsoft Data Platform MVP, international speaker, blogger, organizer, and chronic volunteer. She blogs at cathrinew.net and tweets at @cathrinew.
Customers Also Bought Items By
Are you an author?
Help us improve our Author Pages by updating your bibliography and submitting a new or current image and biography.
1 11 1
Author Updates
-
-
Blog postOn July 5th, 2022, I was re-awarded as a Microsoft Data Platform MVP 2022-2023. A few days later, I got some cool swag!
Continue Reading Microsoft Data Platform MVP 2022-2023: Swag Edition by Cathrine Wilhelmsen.
1 month ago Read more -
Blog postIn this post, we use Azure Synapse Analytics pipelines to ingest LEGO datasets into our data lake and then explore those datasets using Serverless SQL.
Continue Reading Ingest and Explore LEGO Datasets using Pipelines and Serverless SQL in Azure Synapse Analytics by Cathrine Wilhelmsen.
4 months ago Read more -
Blog postYou are organizing an event and find out an attendee has a history of stalking and harassment. What do you do? You need a Code of Conduct and plan for enforcing it.
Continue Reading Your event needs a Code of Conduct. You need a plan and process for enforcing it. Here's why. by Cathrine Wilhelmsen.
5 months ago Read more -
-
Blog postAfter publishing a storage event trigger in Azure Synapse Analytics, I got errors "failed to subscribe" and "failed to activate". Here's how I fixed them.
Continue Reading Failed to Subscribe / Failed to Activate Storage Event Trigger After Publishing in Azure Synapse Analytics by Cathrine Wilhelmsen.
8 months ago Read more -
Blog postIn this post, I describe how to create a linked service to connect to HubSpot from Azure Synapse Analytics or Azure Data Factory.
Continue Reading Connecting to HubSpot from Azure Synapse Analytics or Azure Data Factory by Cathrine Wilhelmsen.
8 months ago Read more -
Blog postOn Tuesday, March 8th, I will be delivering a training day at SQLBits 2022 called "Beginner's Guide to Data Integration using Azure Data Factory or Azure Synapse Analytics" 🤓
Continue Reading Training Day at SQLBits 2022: Data Integration using Azure Data Factory or Azure Synapse Analytics by Cathrine Wilhelmsen.
8 months ago Read more -
Blog postOn November 1st, 2021, I started my new job as a Senior Consultant in the Data Management and Analytics team in Skill! Yay 🥳😁🤓
Continue Reading First Day as a Senior Consultant in Skill! by Cathrine Wilhelmsen.
9 months ago Read more -
Blog postIn this post, I share my experiences preparing for and taking Microsoft Exam DP-900: Azure Data Fundamentals.
Continue Reading Preparing for and Taking Microsoft Exam DP-900 (Azure Data Fundamentals) by Cathrine Wilhelmsen.
9 months ago Read more -
Blog postOn November 17th, I will be presenting my Norwegian session "Bli en PowerPoint (Slide Master)-mester på 1-2-3!" at MVP Dagen 2021.
Continue Reading Speaking (in Norwegian!) at MVP Dagen 2021 by Cathrine Wilhelmsen.
10 months ago Read more -
Blog postOn Saturday, October 2nd, I'm guesting the anniversay show of Rockin' The Code World with dotNetDave! Hope you'll tune in 🤓
Continue Reading Guesting the Anniversary Show of Rockin' The Code World with dotNetDave! by Cathrine Wilhelmsen.
10 months ago Read more -
Blog postMigrating my website had immediate technical and financial benefits. In this post, I reflect on the personal benefits, like how I enjoy blogging again.
Continue Reading How migrating from WordPress to Hugo has helped me refocus and enjoy blogging again by Cathrine Wilhelmsen.
11 months ago Read more -
Blog postDid you know that the PowerPoint Presenter Coach can help you improve your presentation skills by providing real-time feedback while you're rehearsing?
Continue Reading Improve Your Presentation Skills by Rehearsing with PowerPoint Presenter Coach by Cathrine Wilhelmsen.
11 months ago Read more -
Blog postAt Data Saturday Oslo 2021, I delivered the keynote called Turning Discomfort into Personal Growth in a Fast-Paced World. The recording is now available!
Continue Reading I Can't Keep Up! Turning Discomfort into Personal Growth in a Fast-Paced World by Cathrine Wilhelmsen.
11 months ago Read more -
Blog postOn September 4th, 2021, I will deliver the keynote at Data Saturday Oslo 2021: Turning Discomfort into Personal Growth in a Fast-Paced World.
Continue Reading Keynote at Data Saturday Oslo 2021 by Cathrine Wilhelmsen.
11 months ago Read more -
Blog postIn 2021, I said goodbye WordPress and hello Hugo. Why? To learn new skills, improve website performance, AND save a lot of money! 🤓
Continue Reading Goodbye WordPress, Hello Hugo! by Cathrine Wilhelmsen.
12 months ago Read more -
Blog postIn T-SQL Tuesday #141, TJay Belt wants to know how we are balancing work and life. I share the 3 yeps and nopes I have implemented for myself.
Continue Reading My Yeps and Nopes for Balancing Work and Life (T-SQL Tuesday #141) by Cathrine Wilhelmsen.
1 year ago Read more -
Blog postIn T-SQL Tuesday #140, Anthony Nocentino asks about containers. I share how I got started developing in containers using Visual Studio Code.
Continue Reading Developing in Containers using Visual Studio Code (T-SQL Tuesday #140) by Cathrine Wilhelmsen.
1 year ago Read more -
Blog postOn July 1st, 2021, I got my first vaccine shot and I was also renewed as a Microsoft Data Platform MVP 2021-2022. Double yay!
Continue Reading Microsoft Data Platform MVP 2021-2022: Vaccinated Edition by Cathrine Wilhelmsen.
1 year ago Read more -
Blog postOn June 12th, 2021, I will be moderating an Ask the Experts session with Microsoft and Community members at Data Toboggan. Join us!
Continue Reading Ask the Experts: Data Integration in Azure Synapse Analytics (at Data Toboggan 2021) by Cathrine Wilhelmsen.
1 year ago Read more -
Blog postOn April 16th, 2021, I will be presenting my Introduction to Data Integration in Azure Synapse Analytics session at Global Azure Norway.
Continue Reading Speaking at Global Azure Norway 2021 by Cathrine Wilhelmsen.
1 year ago Read more -
Blog postOn January 30th, 2021, I will be presenting a session called Introduction to Data Integration in Azure Synapse Analytics at Data Toboggan.
Continue Reading Speaking at Data Toboggan 2021 by Cathrine Wilhelmsen.
2 years ago Read more -
Blog postIn this post, we go through the Azure Data Factory user interface and get an overview of the four Azure Data Factory pages.
Continue Reading Overview of Azure Data Factory User Interface by Cathrine Wilhelmsen.
2 years ago Read more -
Blog postIn this post, we go through how to rename the default branch from "master" to "main" in Azure Data Factory Git repositories.
Continue Reading Renaming the default branch in Azure Data Factory Git repositories from "master" to "main" by Cathrine Wilhelmsen.
2 years ago Read more -
Blog postIn this month's T-SQL Tuesday, Jess Pomfret wants to hear about life hacks. I share two keyboard shortcuts for moving text lines and windows.
Continue Reading Keyboard shortcuts for moving text lines and windows (T-SQL Tuesday #123) by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postWarning! This is a personal post full of tweets and pictures where I share my highlights from 2019 😊
Continue Reading Personal Highlights from 2019 by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we will look at resources for continued learning. We will cover where, how, and from who you can learn more Azure Data Factory
Continue Reading Azure Data Factory Resources by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we are going to look at some lessons learned about understanding pricing in Azure Data Factory. And today, it's a video!
Continue Reading Understanding Pricing in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at how to use lookups, what the difference is between First Row Only and All Rows, and how to control foreach loops.
Continue Reading Lookups in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at foreach loops and how to control them from arrays. We see how to use @item() to reference the current iteration.
Continue Reading ForEach Loops in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at variables, how they are different from parameters, and how to use the Set Variable and Append Variable activities.
Continue Reading Variables in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at parameters, expressions, and functions and how to use them to build dynamic pipelines in Azure Data Factory.
Continue Reading Parameters in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at pipeline templates, the template gallery, and how you can create your own templates in Azure Data Factory.
Continue Reading Templates in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at why you should use source control and how to set it up in Azure Data Factory using Azure DevOps and GitHub.
Continue Reading Source Control in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at SSIS Lift and Shift, creating an Azure-SSIS integration runtime, and executing SSIS packages in Azure Data Factory.
Continue Reading Executing SSIS Packages in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we create a self-hosted integration runtime and look at techniques for copying data from and into an on-premises SQL Server.
Continue Reading Copy SQL Server Data in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at the use cases for and differences between Azure, Self-Hosted, and Azure-SSIS integration runtimes.
Continue Reading Integration Runtimes in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at how to add annotations to factory resources, user properties to activities, and use both to customize monitoring.
Continue Reading Annotations and User Properties in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at how monitoring works in Azure Data Factory, and how to create and configure alerts.
Continue Reading Monitoring Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at schedule triggers, tumbling window triggers, event triggers, and how to trigger pipelines on-demand.
Continue Reading Triggers in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at what happens when debugging pipelines, how to see the debugging output, and how to set breakpoints.
Continue Reading Debugging Pipelines in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at orchestrating pipelines using branching, chaining, activity dependencies, and the execute pipeline activity.
Continue Reading Orchestrating Pipelines in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at Mapping and Wrangling Data Flows, link to useful resources, and share how to stay updated and keep learning.
Continue Reading Data Flows in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at linked services, how to configure them, the different authentication types, and how to securely store credentials.
Continue Reading Linked Services in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at dataset connections and schema properties, and explore how database and file datasets are different from each other.
Continue Reading Datasets in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we dig into the Copy Data Activity in Azure Data Factory and look at how it works and how to configure the settings.
Continue Reading Copy Data Activity in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we look at how to create and organize Azure Data Factory Pipelines, navigate the design canvas, and how to edit their JSON code.
Continue Reading Pipelines in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we go through the Copy Data Tool in Azure Data Factory step by step to copy a file from a demo dataset to a storage account.
Continue Reading Copy Data Tool in Azure Data Factory by Cathrine Wilhelmsen.
3 years ago Read more -
Blog postIn this post, we go through the Azure Data Factory user interface and get an overview of the different Azure Data Factory components.
Continue Reading Overview of Azure Data Factory Components by Cathrine Wilhelmsen.
3 years ago Read more
Titles By Cathrine Wilhelmsen
by
Andy Leonard,
Scott Currie,
Jacob Alley,
Martin Andersson,
Peter Avenant,
Bill Fellows,
Simon Peck,
Reeves Smith,
Raymond Sondak,
Benjamin Weissman,
Cathrine Wilhelmsen
$31.10
Learn Business Intelligence Markup Language (Biml) for automating much of the repetitive, manual labor involved in data integration. We teach you how to build frameworks and use advanced Biml features to get more out of SQL Server Integration Services (SSIS), Transact-SQL (T-SQL), and SQL Server Analysis Services (SSAS) than you ever thought possible.
The first part of the book starts with the basics—getting your development environment configured, Biml syntax, and scripting essentials.
Whether a beginner or a seasoned Biml expert, the next part of the book guides you through the process of using Biml to build a framework that captures both your design patterns and execution management. Design patterns are reusable code blocks that standardize the approach you use to perform certain types of data integration, logging, and other key data functions. Design patterns solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, design patterns improve your efficiency as a Biml developer.
In addition to leveraging design patterns in your framework, you will learn how to build a robust metadata store and how to package your framework into Biml bundles for deployment within your enterprise.
In the last part of the book, we teach you more advanced Biml features and capabilities, such as SSAS development, T-SQL recipes, documentation autogeneration, and Biml troubleshooting.
The Biml Book:
BI developers wishing to quickly locate previously tested solutions, Microsoft BI specialists, those seeking more information about solution automation and code generation, and practitioners of Data Integration Lifecycle Management (DILM) in the DevOps enterprise
The first part of the book starts with the basics—getting your development environment configured, Biml syntax, and scripting essentials.
Whether a beginner or a seasoned Biml expert, the next part of the book guides you through the process of using Biml to build a framework that captures both your design patterns and execution management. Design patterns are reusable code blocks that standardize the approach you use to perform certain types of data integration, logging, and other key data functions. Design patterns solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, design patterns improve your efficiency as a Biml developer.
In addition to leveraging design patterns in your framework, you will learn how to build a robust metadata store and how to package your framework into Biml bundles for deployment within your enterprise.
In the last part of the book, we teach you more advanced Biml features and capabilities, such as SSAS development, T-SQL recipes, documentation autogeneration, and Biml troubleshooting.
The Biml Book:
- Provides practical and applicable examples
- Teaches you how to use Biml to reduce development time while improving quality
- Takes you through solutions to common data integration and BI challenges
- Master the basics of Business Intelligence Markup Language (Biml)
- Study patterns for automating SSIS package generation
- Build a Biml Framework
- Import and transform database schemas
- Automate generation of scripts and projects
BI developers wishing to quickly locate previously tested solutions, Microsoft BI specialists, those seeking more information about solution automation and code generation, and practitioners of Data Integration Lifecycle Management (DILM) in the DevOps enterprise
Other Formats:
Paperback
Voices from the Data Platform (Volume Book 1)
Oct 10, 2017
by
Melody Zacharias,
Rie Irish,
Cathrine Wilhelmsen,
Jen McCown,
Kathi Kellenberger,
Meagan Longoria,
Mindy Curnutt,
Dave Kawula,
Cristal Kawula,
Kevin Klein
$9.99
The writing of this book was a collaborative effort taken up by 7 very talented IT professionals. All too often, books like this get derailed due to some, but usually most, of the authors getting bogged down by work, life, family, health, or some other unexpected ordeal. So, it needs to be acknowledged that these authors can be relied upon to complete the things they commit to.
Despite their collective talent, this book would not have been possible without the expert advice and guidance from MVPDays Publishing. This book was their idea, and they have guided its progress from the beginning. Dave has provided excellent advice and just the right amount of cajoling to keep us all on track.
Finally, the third leg of this structure is our sponsor. SentryOne has provided the light at the end of the tunnel that gives us all hope that the many hours spent after work (and family), is not all in vain. The avenues for distribution that they are providing was necessary for all of us to justify our efforts.
Thank you to all for your contributions to this book. Without any one of you, this book would not have been possible.
Despite their collective talent, this book would not have been possible without the expert advice and guidance from MVPDays Publishing. This book was their idea, and they have guided its progress from the beginning. Dave has provided excellent advice and just the right amount of cajoling to keep us all on track.
Finally, the third leg of this structure is our sponsor. SentryOne has provided the light at the end of the tunnel that gives us all hope that the many hours spent after work (and family), is not all in vain. The avenues for distribution that they are providing was necessary for all of us to justify our efforts.
Thank you to all for your contributions to this book. Without any one of you, this book would not have been possible.
Other Formats:
Paperback