This episode of #TSQL2SDAY is hosted by Mikey Bronowski (b | t) with a super cool topic: T-SQL Tuesday #135: The outstanding tools of the trade that make your job awesome.
Cheatsheet as a learning tool!
Cheatsheet is definitely one of my tools to learn new things. From learning bash (unix/linux), PowerShell, KQL, markdown, Docker, Python or R!
As I learn a new programming language, I need a quick way to look things up. So I start researching for a great cheatsheet as it helps to quickly get a glance of the program construct and get the essence of the programming language. The first time I saw a cheatsheet printed on a yellow card paper, was back when I was doing to my study at The Australian National University.
The good news is for most popular programming languages, you can find cheatsheets online easily.
So here’s a couple that I compiled from different sources related to Azure Data Studio:
- Markdown Cheatsheet (for Azure Data Studio) borrowed and compiled from different other sources for editing Notebook text cells / markdown.
- Useful Azure Data Studio keyboard shortcuts.
Here are some other ones that have saved quite a bit of my time in the past five years:
- SQL To KQL translation: I learned this quite a bit as I’m analyzing quite a bit of data in ADX clusters and Azure Log Analytics these days.
- Data wrangling with R: My past work in Business Analytics mean that I had to learn R quite fast to do data transformation and some statistical analysis.
- Docker CLI cheatsheet: This was particularly useful when I first started with spinning up SQL in docker. I also use this doc (not quite a cheatsheet, but close enough). These days I use Azure Data Studio New Deployment feature (from the Connections viewlet) instead of remembering all the commands.
Hope this inspires you to use cheatsheets as a tool to learn and to look something up quickly. But if you truly want to learn something new, you may want to create / compile your own cheatsheets!
A cheatsheet example
5 Responses
That is a good set of cheetsheets to start with. I never really have used those much yet, but I can see how useful they would be. Thanks for putting that list together!
Thanks Glenn! As I learn new things / rediscover the cheatsheets that I’ve previously used, I’ll add them to the list.
I’m sure there are PowerShell, DAX and SQL ones there 😀
I love cheat sheets. I always find something new in them. Although, the biggest cheatsheet for me is Google 🙂 I might borrow some of your work from GitHub too.
Thank you for taking time and writing this up.
Thanks Mikey for sharing such an awesome topic for us to write! I had a lot of fun writing it up 🙂
[…] Koesmarno (blog|twitter)On Julie’s blog, we can read about cheatsheets. The two of them she made for Azure […]