Getting Started with SSIS

I am relatively new to the world of SQL Server Integration Services (SSIS). I knew sort of what it was and that it existed, but I didn’t start working with it and learning how to use it until about 3 years ago.

I started by following through the Stairway to Integration Services. This is a great way to jump start if you are just starting out. This program assumes you know absolutely nothing about SSIS and walks you through from beginner to a solid intermediate.

It was shortly after completing the Stairway that I began my first consulting job and was heavily working with SSIS. At this job, I was designing and maintaining packages that would grab FTP files, put the information from the files into a table, and push that information to production. Sometimes, they would also grab data from the database, place it in a flat file, and send that file via FTP or SFTP to a client.

This job was also a great way to start with SSIS. I wasn’t doing anything too complicated, and if I ever hit a snag, a quick google search would most likely bring me to a resolution.

It was also in this job, that I met my first “monolith” package. This was a package that was running for over 4 hours at a time and then timing out. The job was to move data from a MSSQL data source into a MySQL data source housed in AWS. My Dad and I worked together on this package and we were able to break it down into smaller chunks – 1 controller package, and a package for each step that needed to run. When we were finished, the whole project ran successfully in less than 18 minutes!

I recently spent some time talking to my Dad about my experience in getting started with SSIS. If you’d like to listen to it, you can find it here.

Young Moms in Technology

I hosted a webinar with my Dad called Young Moms in Technology. We touched on the types of discrimination women (and especially moms) face in the field of technology (really, it’s applicable to any field, but my experience is in technology). We also talked a bit about my experience as a young person in technology.

Unfortunately, I’ve experienced discrimination for being a woman and a mom first hand. I’ve had co-workers not believe me when I tell them I’ve solved a problem. I’ve had my work scrutinized closely. I’ve been passed over for promotions for which I was the more qualified candidate. I’ve been paid less than male counterparts who had less experience and education than I did at the time.

These situations were not ok. And I’ll admit that I didn’t stand up for myself and demand justice (really, though, I was raised as a polite, southern girl – I rarely demand anything. I would have asked politely instead). I do think that you should ask for justice. I believe that the more awareness we bring to the discrimination, the more opportunities we create to fix the problem.

Another point we touched on in the webinar is about what it’s like to be young in a field where experience is everything. From my experience, it’s not easy. Employers, clients, and companies want people who know what they are doing, and young people (millennials) have a stigma for being inexperienced. This is not to say that every young person you meet/interview will be qualified, but don’t be so quick to judge on appearance of youth alone.

I do appear much younger than I actually am, and it can be frustrating to get people to take me seriously sometimes. Even if I work hard, I have had to continuously “prove myself” to a client just to be seen for the talent and knowledge that I have.

I guess my moral of the story is: give everyone a fair chance. Being a mom, a woman, a millennial is just a part of my life; labels that I own. I also possess the labels Consultant, SSIS developer, hard worker, and dependable.

Do you need help with a project? Hire me!

Hello world!

The very first thing you learn when you are learning a new computer language is how to write “Hello world!” to the screen/output desired. True to that standard, here is my “Hello world!” blog post.

I’ve been working with computers all of my life. I built my first server at the age of 13 with nothing but a box of parts and a book. I taught myself Visual Basic in the same manner. I continued my studies at Liberty University’s computer science program where I was first introduced to relational databases. I happen to love databases and data for that matter. Today, I work as a consultant and do work with Microsoft SQL Server Integration Services, Microsoft SQL Server, MySQL, and anything else that happens to come up. I love learning about new technologies. I currently work with my dad, Andy Leonard, at Enterprise Data and Analytics.

As for my personal life, I am a wife to Antony Trupe. We’ve been married since July 26, 2006. We have three awesome children: Alex, Gabe, and Ellie. We homeschool all three of them for now. I am active in our homeschool co-op as a teacher and the current webmaster for the group. In addition to our kids, we also have two cats (Jack and Ginger), three goats (Rosabell, and her two little boys), a collection of chickens, and thousands of bees. I enjoy baking and making novelty cakes. I also dabble in sewing a little bit. I am an avid coffee drinker as well – my favorite right now is either Joe Bean’s (a local drive thru coffee shop) or Death Wish Coffee.

I’m hoping to use this blog to help spread any knowledge that I have acquired throughout the years, whether it be about computing, baking, animal husbandry, homeschooling, or homesteading. Thank you for visiting!