Skip to content

Technical Accomplishments and Happy Memories (T-SQL Tuesday #112)

Technical Accomplishments and Happy Memories (T-SQL Tuesday #112)

The March 2019 edition of T-SQL Tuesday is hosted by Shane O’Neill (@SOZDBA). This month, Shane wants us to share our cookies. Wait… what? Yes! Cookies :) In this analogy, cookies are accomplishments or memories you can look back on when things get tough. Something that will give you that little energy kick you need to keep you going when you think you’re completely done.

I’ve spent a lot of time reflecting on this since the topic was announced. My cookie jar definitely consists of two types of cookies: technical and non-technical. There are more of the latter, which I believe is a good thing :)

In this post, I’ll highlight some of the technical accomplishments I’m proud of, and share some of my happy memories that always make me smile. (I mean pictures. I will share lots and lots of pictures.)

Continue reading →

Why I’m a Business Intelligence Consultant (T-SQL Tuesday #111)

T-SQL Tuesday #111: Why I'm a Business Intelligence Consultant

This month’s T-SQL Tuesday is hosted by Andy Leonard (@AndyLeonard). Andy wants to know what is our “why”, or why we do what we do. Before I can answer the why, I will briefly explain the what :) I work as a Business Intelligence consultant, focusing on Data Warehousing, Data Integration, and Data Visualization.

The short answer to “why?” is because the work is both challenging and rewarding. As a Business Intelligence consultant, I get to use all my skills from programming to design. I get to satisfy my instinctive need to group, organize, and sort things when working with data. Then I get to make things shiny and pretty. Finally, I get to work with other people, learn about their industries, and help them do their jobs better.

The long answer is… longer :) I absolutely love my job now, but I ended up in the world of data completely accidentally. I’ve gone from Web Development to Graphic Design to Interactive Design to Java Programming to SharePoint Development to Data Warehouse Architecture to Community Evangelizing… And now I’m here :) (Phew!) So why am I a Business Intelligence consultant?

Continue reading →

Generating SQL using Biml (T-SQL Tuesday #110)

T-SQL Tuesday #110: Generating SQL using Biml

The first T-SQL Tuesday of 2019 is hosted by Garry Bargsley (@gbargsley), and the topic is “Automate All the Things“. Garry wants to know what this phrase means to each of us. What do we want to automate? What is our go-to technology for automation? To me, this was super easy. Surprise, surprise! It’s Biml, of course :) Since this post is part of T-SQL Tuesday, I wanted to go back to the basics and write about how you can generate SQL using Biml. But first, a little bit of background for those who are not that familiar with Biml.

Continue reading →

Online Tools for Data Professionals (T-SQL Tuesday #101)

T-SQL Tuesday #101: Online Tools for Data ProfessionalsT-SQL Tuesday #101 is hosted by Jens Vestergaard (@vestergaardj), and the topic is The Essential SQL Server Tools in my stack. There are several tools that I use every single day, such as Notepad++, Redgate SQL Prompt, and BimlExpress. In fact, there are so many amazing tools out there for data professionals that I created an entire session focusing on Tools and Tips For Data Warehouse Developers! Since I have already covered my favorite tools in other blog posts, I want to take a slightly different approach this time and share some of my favorite online tools.

Continue reading →

Collecting Geeky Norwegian Humor (T-SQL Tuesday #99)

T-SQL Tuesday #99: Collecting Absurd Norwegian HumorT-SQL Tuesday #99 is hosted by Aaron Bertrand (@AaronBertrand) and the topic is Dealer’s Choice. What does that mean? Aaron wanted us to choose between two topics: write about something we are passionate about outside the SQL Server community, or write about T-SQL bad habits and best practices. I’m too afraid to argue with Aaron about T-SQL, so I chose the first option ;)

But what did I want to write about? Truth be told, I’m pretty boring. I don’t have any real hobbies outside of tech, just a few interests. I first considered writing about hiking. I need to disconnect completely once in a while, and my favorite way of doing that is to get sweaty while walking for hours up a mountain or waterfall. My Instagram (@cathrinesqueee) is my highlight reel, full of pictures and happy memories from my trips.

Some of my favorite hiking memories are: descending into Thrihnukagigur Volcano, eating lunch on top of the Rocky Mountains, relaxing at the Alluvial Fan, exploring the Garden of the Gods, climbing Seven Falls, overlooking the Norwegian fjords, driving across the never-ending Jotunheimen mountains, watching the fog roll in over Trollstigen, hiking Dinosaur Ridge, crossing the Capilano Suspension Bridge, taking a break on Mount Falcon, visiting the Loveland Pass, and gazing at presidents at Mount Rushmore.

Mads Eriksen MHowever, instead of embedding all the pictures that are already on Instagram, I decided to write about something completely different. Something obscure. Something fun and geeky from way before I got involved in the SQL Server community. Something from my good old teenage fangirling days…

Continue reading →