To error is human and sometimes the errors / mistakes we make can easily put our jobs at stake. Such horror stories are something I keep hearing from people and they are super cool in a way because you learn from their experiences. In a recent corridor conversation with a friend, he said how cool he found my blog on: SQL SERVER – Color Coding SQL Server Management Studio Status Bar. He personally felt this was a cool thing. But he said even after that, it is sometimes difficult because the status bar location is at the bottom. I asked what is your screen resolution – he replied (2560 x 1440).
I was pleasantly surprised because these days, the screen sizes are increasing and we are getting ridiculous resolutions making things even worse. But the solution was always around with SQL Server Management Studio. Trust me on this.
I recommended him to move his status bar from bottom to top so that it becomes easy for him and come on top of his eyeline as he is reading code. I did the below steps to show how this was easily possible.
If you hit the Tools -> Options and go to the “Text Editor” -> “Editor Tab and Status Bar”. Change the location of the “Status bar location”.
It is as easy as I have shown above. After this, press on “Ok”. Open a new query window to see the effect of the same. Your new query windows will look like below:
I found this as a cool addition that has been there for a long time but less explored. I am curious to know if you have ever used this option in your environments? How has it been useful for you? Has it saved you from making mistakes in a wrong environment? I would love to hear the stories you have with these options and settings. Let me know via the comments.
Reference: Pinal Dave (https://blog.sqlauthority.com)