Skip to content

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 →

Preparing for and Taking Microsoft Exam 70-768 (Developing SQL Data Models)

Microsoft Exam 70-768: Developing SQL Data Models

After taking a break from exams and certifications for a few years, I decided to resume studying. On May 29th, 2018, I shared my Updated Microsoft Certification Goals. On June 5th, 2018, I achieved my first goal by passing Microsoft Exam 70-767. On July 31st, 2018, I achieved my second goal! I passed Microsoft Exam 70-768: Developing SQL Data Models. By passing this exam, I became a Microsoft Certified Solutions Associate (MCSA): Business Intelligence Development :)

In this blog post, I share how I prepared for the exam and what my experience was like on the day of the exam.

Continue reading →

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 →

Organizing Visual Studio Projects in Solution Folders

Organizing Visual Studio Projects in Solution FoldersDo you have large Visual Studio solutions with many projects? Are you looking for an easy way to hide some projects while working on others? Maybe you are a fellow speaker looking for a way to group and organize your demo files? Solution Folders may be what you are looking for!

What are Visual Studio Solution Folders?

In Visual Studio, you can add virtual folders to group and organize your projects and files. Folders can be nested, collapsed, expanded, and even hidden in the Solution Explorer. Please keep in mind that these folders are entirely virtual. That means that you will still have to physically organize your projects the way you prefer in your file system.

Create Solution Folders

Visual Studio - Add Solution Folder
Right-click on the solution → Add → New Solution Folder (or with the solution selected, click the Project menu → Add New Solution Folder)

Hide Solution Folders

Visual Studio - Hide Solution Folder
Right-click on the folder → Hide Folder (or with the folder selected, click the Project menu → Hide Folder)

Show Solution Folders

Visual Studio - Unhide Solution Folders
Right-click on the solution → Unhide Folders (or with the solution selected, click the Project menu → Unhide Folders)

Continue reading →