T-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.
T-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.
However, 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…
It’s that time of year again… The largest, coolest, geekiest, most awesome party of the year is just around the corner! Oh, and there’s this conference attached to the party as well. SQLBits 2018: Magic Edition. You may have heard of it? :D
SQLBits is the largest SQL Server and Microsoft Data Platform conference in Europe. It has 4 days of training and over 170 sessions by both the Microsoft Product Group and community speakers. It’s a professional conference in all ways, and it’s organized entirely by a group of dedicated volunteers. That’s right, it’s a pure community event, and it’s fantastic.
I was a speaker and volunteer at SQLBits 2015 (Superhero Edition), a precon speaker at SQLBits 2016 (Space Edition), a PASS representative at SQLBits 2017 (Disco Edition), and I’m very happy to go back to where I started as a speaker and volunteer at SQLBits 2018 (Magic Edition). I was actually really bummed when I wasn’t a volunteer, it’s so much fun helping out to make it a smooth conference for attendees and getting to know all the other wonderful volunteers. This year, I’m back! Yay :)
Ok, ok, ok, I may have gotten a little carried away :) But I am excited to announce that I will be presenting a precon at SQLSaturday Chicago 2018! The precon will be held on Friday, March 16th, and is called Level Up! From Basic Biml to Automated Data Warehouse Frameworks. I will also present a general session on Saturday, March 17th.
Woohoo! I’m very happy to announce that Jason Horner (@jasonhorner) and I will be presenting a precon at SQLSaturday Nashville 2018! The precon will be held on Friday, January 12th, and is focused on SSIS and Biml. We will also be at the SQLSaturday where Jason will be presenting about Dimensional Modeling and I will be presenting about Biml. This will be my first time visiting Nashville, so I’m very much looking forward to it :)
SQLSaturday Nashville 2018 Precon (Jan 12)
Jason had been working on a precon idea for a while that would bring together all his experience using SSIS to deliver ETL projects. I wanted to develop a new precon focusing on Biml and SSIS. Instead of working on two separate precons, we decided to team up and combine our knowledge. We will be delivering this precon for the first time in Nashville, and we’re looking forward to helping attendees by providing guidance on how to solve challenges they might face in their projects.
You can read more about why we wanted to present this precon in our interview on the Nashville BI User Group website.
Check out the full abstract and register for our precon on bit.ly/ETL-Precon-Nash. A regular full-day is only $129, and for only $165 you can also attend one of the half-day precons on Thursday. What a bargain!
SQLSaturday Nashville 2018 Sessions (Jan 13)
Jason and I are also presenting a regular session each. Jason will be presenting his Dimensional Modeling Design Patterns: Beyond the Basics session, and I will be presenting my Biml for Beginners: Speed Up Your SSIS Development session.
Check out the full SQLSaturday Nashville schedule and register today to get all the news and updates. You can also follow @SQLSatNash on Twitter and use the hashtag #SQLSatNash to join the conversation. Please help spread the word to all your friends and coworkers, and make sure you sign up before the event is full.
Hope to see you in Nashville in January! :)