Today we are going to see a quick tip which is suggested by SQL Server Expert Nicklas Bågvinge, whom I met in the Gothenburg earlier this week during a SQL Training. He recently sent me an email about a very interesting SQL Server Management Studio (SSMS) tip. Let us learn how we can select vertical text in SSMS using ALT + SHIFT keys.
It is quite common that we want to select often vertical text in SSMS and make our edits like adding spaces, deleting the text or changing the case of the text. It is very difficult to do that as there is no out of box way to select the text. However, if you hold the short cut keys ALT + SHIFT and select any highlighted text vertically they will be selected easily.
Though this is for SQL Server Management Studio (SSMS), it also works in notepad++ and few other text editors as well. If you know any such trick, please send me an email and I will be happy to post on the blog with the due credit to you.
SQL SERVER Management Studio – Removing Completion Time in Messages
I have researched a bit on SSMS and asked a few friends but I could not find the answer to this one. I am super glad that SQL Server Expert Oz posted the solution for Removing Completion Time in Messages.
SQL SERVER – Check for Update in SSMS
My client asked me quite a few questions about SQL Server Management Studio and also about how the execution plan works overall. During the session, I advised them to check out the latest SQL Server Management Studio (SSMS), which works with many of the previous versions of SQL Server flawlessly.
SQL SERVER – Generate In-Memory OLTP Migration Checklists – SSMS
First, go to SQL Server Management Studio and right-click on the database for which you want to generate the checklist. The next is to go to Tasks and select the option of Generate In-Memory OLTP Migration Checklists.
Reference: Pinal Dave (https://blog.sqlauthority.com)