Performance Tuning Using Free Tools, Part 2 (20 22-01-14)

Daily Coping Tip

Learn something new and share it with others

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

A New Language

In my life, I've mostly dealt with people that speak English. I tried Latin in high school and Japanese in university, but I wouldn't say I learned a lot. This past year I've been working on Japanese (konichi wa) and French (Bonjour) on a regular basis, but I'm still fairly uni-lingual. At least compared to many of the people I've met in my travels that speak multiple languages. I'm mostly just trying to read a bit, and that's quite hard.

In my career, I haven't met many technologists that only know one programming language. Even the SQL professionals know a little C# or a scripting language. Quite a few people know a bit about many languages, and some are very competent. I used to think it would be good to master one language before moving on, but I find that trying different languages can give you an appreciation for others, or even an appreciation for your primary one.

These days many of us are being asked to handle more tasks, and we may be required to support or work with code that others have written. As a result, I think it makes some sense to have a basic knowledge of other languages that you might encounter. I can often look at code in different languages and get an idea of what's happening. I might even think about fixing simple bugs if needed.

I saw a Data Exposed edition recently with Hamish Watson that was titled KQL: The Next Query Language You Need to Learn. I had heard of it, but never used it. After watching the episode I played with it a little. While I don't know how important it is, I do appreciate I may run into it and will likely spend a small amount of time writing some queries and familiarizing myself with some of the common aggregates and other types of structures.

Today I'm curious, what do you think you would learn as a next language? Not that you'd give up your current work in T-SQL or something else, but what else might be good for your career, or perhaps be exciting to your personally?

I've enjoyed doing some work in Python and PowerShell over the last year, and time spent in R before that helped me appreciate those languages. There are places I'd choose to work in those over T-SQL, especially for data not already in a SQL Server.

Take a moment and leave a comment: what new language would you like to learn and why?

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums