Yay! On Tuesday, April 12th, I will present my Tools and Tips: From Accidental to Efficient Data Warehouse Developer session for the PASS Women in Technology Virtual Chapter. The webinar starts at 12:00 EDT / 18:00 CEST and you can register for it here :)
Tools and Tips: From Accidental to Efficient Data Warehouse Developer
This session is a journey through some of my “Oh wow! Why did I not know this yesterday!?” moments. (Some of them are also known as my “Ooops!” moments.) I will talk about a variety of topics, including SSMS features, tools for query analysis and tuning, free tools and scripts, Biml for SSIS and even a couple of things I used to think were only useful for those scary DBAs. There was a time when these things were completely unknown to me, and I hope that I can help other accidental Data Warehouse developers so they won’t have to spend years discovering these things one by one.
This is the first time I’m presenting this session as a webinar, so I’m currently tweaking my slide deck while re-reading my own lessons learned about presenting webinars. I usually have a rather fast-paced presentation style, but that just doesn’t work as well in a webinar with lag. I also want to make sure that everything is easy to understand without me having to explain it with gestures.
(I will still be sitting alone in a room, gesturing wildly to my computer, but I promise to make my slide deck as informative as possible as well ;) )
My session is definitely not only for women, so why am I presenting for the Women in Technology Virtual Chapter?
Continue reading →
24 Hours of PASS (@pass24hop) is back! From June 24th 12:00 GMT to June 25th 12:00 GMT you can watch 24 free webinars back-to-back. Check out the great schedule and register today!
I’m super happy and excited to have been selected as a speaker at this edition of 24 Hours of PASS. The theme for this event is Growing Our Community. They only accepted abstracts from speakers who have not yet spoken at PASS Summit to give us the opportunity to gain experience and share our knowledge outside our local communities. I love this idea, and I’m so happy to see good friends and talented up-and-coming speakers selected :D
My session is called Don’t Repeat Yourself – An Introduction to Agile SSIS Development. It is based on my introduction to Biml session and I will reuse a lot of that content, but I have tweaked and expanded and changed a few things so it’s no longer just about the Biml language. Hopefully it can inspire those who are still developing SSIS in the traditional way to try a new approach to automating their development and work more efficiently :)
Presenting online is a completely different experience than presenting in-person. When you present online you lose the interaction with the audience, you are unable to read body language or facial expressions to see if they are interested or bored out of their minds, and you get absolutely no feedback on whether or not they understand what you are trying to explain. You have to trust yourself, talk to a screen for an hour, and hope that the technology does not suddenly decide to throw a tantrum and stop working for no reason.
I recently presented my first ever webinar. It went quite well, but there are many things I want to do better next time. Writing down what I learned will help me improve my own presentation skills and slide decks, but I also hope it can help other new speakers prepare for their first webinar. Please feel free to share your own tips and tricks, I would love to learn from you! :)
Continue reading →
Pragmatic Works hosts and records free webinars every Tuesday and Thursday, called Free Training on the T’s. In March 2015 they wanted to highlight Women in Tech (WIT) by hosting nine webinars with speakers from the SQL Server community. I was very honored and excited to be invited, and a little nervous since it was my first ever webinar.
The recording of my webinar Table Partitioning in SQL Server: A Magic Solution for Better Performance? is now available, and the slide deck is available on my SlideShare:
The introduction was not included in the recording, but it can be summed up as “thank you to Pragmatic Works for supporting WIT, thank you for attending my webinar, my name is Cathrine and this is an introduction to table partitioning” :) There were some technical issues so the sound is missing for about a minute in the middle of the webinar, and I couldn’t see any questions in the chat. To all of you who asked questions, I’m sorry for not answering during the webinar, but I have now received the transcript and will answer your questions in upcoming blog posts.
Upcoming blog posts
Ed Leighton-Dick (@eleightondick) recently announced a #SQLNewBlogger challenge where those who participate will write one blog post every week in April. I have decided to participate in this challenge, and I encourage everyone else to do the same! :) I got a lot of great questions during my webinar that I want to answer in more detail with scripts, step-by-step instructions and pictures, so I have picked Table Partitioning as my topic for the challenge. You can find all the blog posts in the Table Partitioning in SQL Server Archive, and check back every week in April if you want to learn more about Table Partitioning basics! :)
Pragmatic Works hosts and records free webinars every Tuesday and Thursday, called Training on the T’s.
In March they will focus on Women in Tech and have some great speakers lined up: Mickey Stuewe (@SQLMickey), Hope Foley (@hope_foley), Jessica Moss (@jessicammoss), Amy Herold (@texasamy), Ginger Grant (@DesertIsleSQL), Shannon Holck (@SQLShannon), Melody Zacharias (@SQLMelody) and Wendy Pastrick (@wendy_dance).
On Thursday, March 26th I will present Table Partitioning in SQL Server: A Magic Solution for Better Performance? This is actually a presentation I created for my coworkers during one of our projects, but I hope it can be useful for others as well :)
(It’s my first webinar, wish me luck!)