Top
JohnKlann / Posts tagged "settings"
sqlThemeSmall

SQL Sever Management Studio 2014 Custom Solarized Theme (JK_Solar)

I was looking for a really good SQL Sever Management Studio Solarized theme and I found it rather difficult to find any themes that were created specifically for SQL Sever Management Studio. There are a lot of Visual Studio themes that are out there that you can load but the syntax highlight for TSQL was never great. So I took some colors from a collection of Visual Studio themes and created a custom SQL Sever Management Studio theme specially for TSQL. You can find the download link to the vssettings Theme file below. I haven’t tested this with any other version of SQL Sever Management Studio other than 2014 but I don’t see why it wouldn’t work on earlier versions.

JK_Solar SSMS Theme

JK_Solar SSMS Theme

To import this theme into SSMS follow these steps:

  1. Open the Tools menu and select Import and Export Settings.
  2. Select Import selected environment settings then click Next.
  3. Select a place to backup your current settings.
  4. Select the JK_Solar.vssettings file you downloaded then click Next.
  5. Click Finish and you’re done!

Download Link: JK_Solarized.vssettings Count: 2,291 FileSize: 1.9 kB

Link to Script in Screen Capture: Stack Overflow Script

jklann
these files cannot be opened.

These files can’t be opened. Your Internet security settings prevented one or more files from being opened.

I came across this today while trying to run an unsigned, potentially harmful executable. There are plenty of recommendations out there on the web on how to fix this, but I found the fastest solution to be as follows.

Open internet explorer and select internet options:

internet_explorer_settings

internet_explorer_settings

Next select the security tab then restricted sites:

internet_explorer_settings_security+restricted_sites

internet_explorer_settings_security+restricted_sites

Now Select custom level and in the new window scroll down and enable “launching applications and unsafe files(not secure)”:

internet_explorer_settings+security_settings-restricted-sites-zone

internet_explorer_settings+security_settings-restricted-sites-zone

Select ok and agree to the warning:

internet_explorer_settings+warning!

internet_explorer_settings+warning!

Now try to run your executable. If this still does not work try using the above steps on the internet, local intranet, and trusted sites zones:

internet_explorer_settings+main_menu

internet_explorer_settings+main_menu

Hope this helps!

jklann