Poor Man's T-SQL Formatter

Hi guys again, I fixed the files to work with SMSS 19 and 20, also changed visualstudio shell to 14 so you don't need manually changes smss config file, Enjoy

https://geogensoft.com/PoorMansTSqlFormatterEditedbyGeoGenSoft.Setup.msi

Via: https://github.com/TaoK/PoorMansTSqlFormatter/issues/283#issuecomment-2393744502

Plugin for SQL Management Studio, Visual Studio, Visual Studio Code, ...

http://architectshack.com/PoorMansTSqlFormatter.ashx

---

If, after an SSMS update, you have this exception:

Could not load 'The 'FormatterPackage' package did not load correctly.' - cannot find the file Microsoft.VisualStudio.Shell.12.0

This is the solution:

The issue seems to be with a binding redirect missing from SSMS. If you edit ssms.exe.config (by default at C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE) and add the following line inside the assemblyBinding element the package will load:

There's one for shell 9.0, 10.0, and 14.0 just not one for 12.0. I took the above from the visual studio exe.config. This will get cleared and have to be re-done any time you update SSMS.

2023-11-15 update - If copy/pasting the above xml doesn't work:
copy the same block directly from the ssms.exe.config file, and change it to .Shell.12.0

---

If modifyng the .config file doesn't work, try replacing Poor Man's DLL with those recompiled ones.

---

SQL Management Studio 2019 Setup

1. Install the Extension in a previous version of SSMS (tested on v18 -- install it, if needed)
2. Copy all files from

   C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Extensions
   

   to

   C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Extensions 

3. Add this in ssms.exe.config:

4. Uninstall Mangement Studio 18 (if installed only for this fix).

User gggirj on github made a working version for SMSS v19: https://simul-europe.com/PoorMansTSqlFormatterSSMSPackage.Setup.msi


Via GitHub and SSMS 19 and working version for SMSS v19

Clickpad settings don't save

Everytime you enable/disable something in TrackPad setting Control Panel, it turns back on after restart.

Open RegEdit.exe and go to:

HKEY_LOCAL_MACHINE\SOFTWARE\Synaptics\SynTP\Install

Look for a key in that Install folder called DeleteUserSettingsOnUpgrade and change the value to 0 (zero).


So, this is a sign something weirder is going on behind the scenes, if the driver thinks it is "upgrading" after every reboot... but anyway, if it works for now, good enough for me



Via.