Tuning an SQL server isn’t like tuning a guitar or another musical instrument. According to the video, SQL server tuning with formatting production code properly, using CTEs over subqueries, and utilizing a window function to add extra columns. SQL server tuning can be a useful skill for data professionals to develop.