T-SQL Tuesday #108 – Learning Tech Beyond SQL Server

Malathi Mahadevan (b|t) is hosting this month’s T-SQL Tuesday, a monthly blog party for the SQL Server community.

Malathi has asked us to:

Pick one thing you want to learn that is not SQL Server. Write down ways and means to learn it and add it as another skill to your resume. If you are already learning it or know it – explain how you got there and how it has helped you. Your experience may help many others looking for guidance on this.

Earlier this year, I decided I wanted to create a home lab. I originally planned to build a domain controller and other virtual machines for the home lab. Then I realized that SQL Server on containers may be able to help me solve several issues regarding licensing and resources. At that time, I realized I could also use containers to create full build pipeline including TeamCity and Octopus Deploy.

At first I tried to start in sequential order and create a TeamCity container. I had previously used TeamCity on my desktop, so I figured it would be easy. I quickly realized I had no idea what to do to even get the TeamCity image running.

I was reminded that years ago I decided I wanted to be a Database Administrator. At the time I learned that I had no idea how to learn. I had to figure out how I learned. I ultimately came to realize that my primary learning method is auditory.

I also began to realize that I see all knowledge as interconnected building blocks. Some building blocks already have a foundation or points where I can join them with knowledge I already have. In other cases, I have no or little previous knowledge. In these cases, it takes me significantly longer to learn that topic.

Using this information, I started watching videos on pass.org. My next step was to install Docker for Windows. Once that was done, I started spinning up some images for SQL Server. Now that I’ve gotten comfortable with containers, I’m starting to look into using Kubernetes and potentially building an Availability Group on containers.

Advertisements