Hi!

I just made the switch from SSMS Toolspack to SSMSBoost and so far I like it a lot. The only thing I miss is the option that SSMS Toolspack did have which is to only format the keywords to UPPERCASE. Nothing more, nothing less.
If I set all options in SSMSBoost formatter to false and only leave UPPERCASE keywords on true, the SQL gets formatted all the same.

Could the "JUST UPPERCASE KEYWORDS" option be something that can be implemented in a future version?

Thanks and keep up the good work!

Cheers,
Erik

Hello Erik,
Thank you for your feedback !

Will it be enough for you, if we add a specialized "JUST UPPERCASE KEYWORDS" Format command, that will re-use current formatter as you described. Just some kind of shortcut for formatter with special set of settings ?

It would also could you tell shortly why you switched from tools pack ?

Thanks,
Andrei

Hi Andrei,

That would be perfect! I think everyone has his own preferences for formatting code but UPPERCASING the keywords is pretty common I guess...

Switching has two reasons. The first is simple: costs. Since the version of SSMS Toolspack for SQL Server 2012 is no longer free and yours is, the choice was easily made. My boss pays for a lot of my software but I expect him not to see a tool like this to be absolutely necessary.. And for the things I use these tools, mainly making coding faster and some very basic formatting, both offer about the same functionality. And SSMSBoost offers some more things I have yet to discover...

The second reason is that I simply did not know of the existence of SSMSBoost... When I was looking for a formatter a year or so back SSMSBoost simply did not turn up in my searches... And as SSMS Toolspack was free at the time for SQL 2008, I went for that... And I must say, that when you get used to such a tool, you really miss it when it is not available for SQL 2012...

Cheers,
Erik

Ok, I will add your request to to-do list. It coincides one of our current tasks for UI improvement.

SSMSBoost was some kind an internal tool before we decided to publish it. We have released it to the public only in March 2012, so you could not find it year ago ;)

Hi Andrei,
I made switch from SSMSToolPack to SSMSBoost for the same reasons as ErikvanD . And I miss the same feature "just uppercase keywords" as ErikvanD 😁.
SSMSBoost makes me happy, thanks!

Nice to hear ! :)
The task is already added. It will take some time to do it. We will add first statement logging and auto-sessions..

There is one problem with UpperCase when formatting 'WITH common_table_expression'.

expression_name is perceived as a keyword and is also subject to a case change, which worsens the readability of the code.

I think this is a mistake.