logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
m60freeman  
#1 Posted : Wednesday, May 29, 2019 10:45:29 PM(UTC)
Rank: Newbie
I installed SMSS 18 and SSMSBoost 3.5 and found that the text in the status bar was an unreadable white on light gray, even for connections that SSMSBoost knows to show with a red background. Upgrading to 3.6 didn't help.

I looked through the SSMS options and couldn't find a way to change the status bar text or background colors. Did I miss something? Is this a known problem with SSMS 18 or SSMSBoost with SSMS 18?

Edited by moderator Monday, August 19, 2019 1:38:53 PM(UTC)  | Reason: Not specified

SSMSBoost  
#2 Posted : Thursday, May 30, 2019 3:03:19 PM(UTC)
Rank: Administration
This is new default color in SSMS. You can customize it SSMS Settings:
Status_Bar_Color_Setting_SSMS_2018.png (24kb) downloaded 26 time(s).
m60freeman  
#3 Posted : Thursday, May 30, 2019 7:50:18 PM(UTC)
Rank: Newbie
Thanks for letting me know where to find that! It seems like a highly non-optimal default. They only let you change the background color, not the text color. And the change doesn't have any effect, even after a restart.

I'd post an image, but this web site seems to only provide a way to link to an image URL.

SubmarineWipers  
#4 Posted : Tuesday, June 4, 2019 1:23:43 PM(UTC)
Rank: Newbie
Please fix this, I am fairly certain this is a SSMS boost error, and not a SSMS default... The suggested change also does not have any effect for me, presumably because SSMSBoost overrides style selection for the status bar.
thanks 4 users thanked SubmarineWipers for this useful post.
m60freeman on 6/4/2019(UTC), Giles Sutcliffe on 6/20/2019(UTC), MarkFreeman on 6/22/2019(UTC), djhislop on 6/24/2019(UTC)
nlaslett  
#5 Posted : Friday, June 21, 2019 6:06:06 PM(UTC)
Rank: Newbie
Originally Posted by: SubmarineWipers Go to Quoted Post
Please fix this, I am fairly certain this is a SSMS boost error, and not a SSMS default... The suggested change also does not have any effect for me, presumably because SSMSBoost overrides style selection for the status bar.


I am having the same problem with the newest SSMS 8.1. I have tried changing the "Status Bar Layout and Colors" as suggested but that has no effect. The results are inconsistent; I can sometimes get the status bar colors to stick, but usually after opening a new query window or executing a query the default back to white-on-light-grey, which is unreadable. I uninstalled SSMSBoost and now things are better.

Neil
thanks 4 users thanked nlaslett for this useful post.
m60freeman on 6/21/2019(UTC), MarkFreeman on 6/22/2019(UTC), djhislop on 6/24/2019(UTC), Giles Sutcliffe on 7/5/2019(UTC)
NYCITGuy  
#6 Posted : Wednesday, July 17, 2019 4:02:03 PM(UTC)
Rank: Newbie
I have tried various tasks to try to remedy this situation, and I have come up short. The setting in Tools --> Settings --> Text Editor --> Editor Tab and Status Bar --> "Single server connections" continues to reset when I close and re-open SSMS. When I uninstall SSMSBoost, I do not experience the issue, so it must be an issue with the interaction with SSMSBoost and SSMS. I am running SSMS 15.0.18131.0, and SSMSBoost 3.6.7072.32963. My issue is that for non-preferred connections, the status bar is a light grey color and the font is white. This is a very annoying problem...
thanks 1 user thanked NYCITGuy for this useful post.
m60freeman on 7/17/2019(UTC)
m60freeman  
#7 Posted : Wednesday, July 17, 2019 4:17:18 PM(UTC)
Rank: Newbie
Originally Posted by: SSMSBoost Go to Quoted Post
This is new default color in SSMS. You can customize it SSMS Settings:
Status_Bar_Color_Setting_SSMS_2018.png (24kb) downloaded 26 time(s).


This is clearly incorrect information. There is a bug in SSMS Boost when used with SSMS 18.0 and 18.1 as reported by several users in this thread. Will you fix it?
L Towles  
#8 Posted : Wednesday, July 24, 2019 4:21:15 PM(UTC)
Rank: Newbie
Just to add one more voice into this mix.

This is broken in 18.x and it is so bad I've had to stick to 17.x. Not being able to read execution time or record counts is just a deal breaker.

I have messed with settings, deleted preferences, uninstalled SSMS boost (works fine), and reinstalled it (broken again). Any changes to the SSMS color setting are ignored, or more to the point you can see them for half a sec when you create a new windows then you're back to grey with white text.

Don't get me wrong I love SSMS boost as just the searchable history alone justified the price - I just want to get this fixed so I can swap to the new SSMS.
thanks 1 user thanked L Towles for this useful post.
m60freeman on 7/24/2019(UTC)
nlaslett  
#9 Posted : Wednesday, July 24, 2019 5:03:02 PM(UTC)
Rank: Newbie
Originally Posted by: L Towles Go to Quoted Post
This is broken in 18.x and it is so bad I've had to stick to 17.x. Not being able to read execution time or record counts is just a deal breaker.


Agreed! I found that I love/need SMSSBoost more than I love/need SSMS 18.x, so I'm back to using SMSS 17 with SSMSBoost and am fine with that. SSMS 18.x removes a number of things (like debugging) and adds things I don't need, so until I *need* 18.x I'm sticking with 17 + SSMSBoost.
thanks 1 user thanked nlaslett for this useful post.
m60freeman on 7/24/2019(UTC)
Brad Harris  
#10 Posted : Tuesday, August 13, 2019 4:40:07 PM(UTC)
Rank: Newbie
Adding my voice to this post. I opened a new thread last week not realizing this was here. Please get this fixed! I'd like to stick with SSMS 18 but I switch connections constantly during my day to day and not having the current connection visible is a big pain point. Please fix this!
Botulism  
#11 Posted : Tuesday, August 13, 2019 11:37:20 PM(UTC)
Rank: Newbie
Based on some debugging with dnSpy, I believe this is an issue with SSMS. However, I think SSMSBoost can work around it.

Issue
When SSMSBoost sets the BackColor of the status bar, it triggers code which sets the ForeColor based on the BackColor brightness.

SQLEditors.dll!Microsoft.SqlServer.Management.UI.VSIntegration.Editors.QEStatusBarManager.UpdateStatusBar()
Code:
this.statusStrip.ForeColor = (((double)this.statusStrip.BackColor.GetBrightness() < 0.5) ? Color.White : Control.DefaultForeColor);


Explanation
In spite of it's wide use by Microsoft, GetBrightness() does not consistently produce good results for this usage. GetBrightness() returns the (HSL) Lightness which is just a mathematical average of the color intensity values. But the human eye perceives the brightness of Blue, Green, and Red differently. A perceived brightness function would product better results.

Solution
I don't have a way to test this. But I believe if SSMSBoost set the ForeColor after setting BackColor, the desired ForeColor value would persist.

Here is a perceived brightness function that I use regularly. There are many opinions about what constants to use. I like the results product by these.
Code:
private const double redPart = 0.299;
private const double greenPart = 0.587;
private const double bluePart = 0.114;

public static double GetPerceivedBrightness(this Color original) {
    return Math.Sqrt(
        original.R * original.R * redPart +
        original.G * original.G * greenPart +
        original.B * original.B * bluePart) / 255;
}


Then SSMSBoost would do something like:
Code:

statusStrip.BackColor = connection.CustomColor;
statusStrip.ForeColor = connection.CustomColor.GetPerceivedBrightness() < 0.5 ? Color.White : Control.Black;
thanks 1 user thanked Botulism for this useful post.
Brad Harris on 8/14/2019(UTC)
Botulism  
#12 Posted : Friday, August 16, 2019 8:18:31 PM(UTC)
Rank: Newbie
@SSMSBoost, will you please comment on this? Multiple people have said your response wasn't quite right. And you haven't responded to any of them.

Frankly, this is concerning to me. I'm still using the trial version of your software. For $150 + $30/year, I expect more than 2-3 releases/year and unresponsive support.
SSMSBoost  
#13 Posted : Monday, August 19, 2019 1:38:33 PM(UTC)
Rank: Administration
We have released v3.7 where we have addressed this issue.
The cause was SSMSBoost was applying default color setting, which had a breaking change since 18.0.
Giles Sutcliffe  
#14 Posted : Monday, August 19, 2019 1:58:57 PM(UTC)
Rank: Newbie
Originally Posted by: SSMSBoost Go to Quoted Post
We have released v3.7 where we have addressed this issue.
The cause was SSMSBoost was applying default color setting, which had a breaking change since 18.0.


Thank you for (eventually) fixing this.
thanks 1 user thanked Giles Sutcliffe for this useful post.
SSMSBoost on 8/19/2019(UTC)
Rss Feed  Atom Feed
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.