Sometimes after massive MSSQL schema update to online scalable production environment there is a need to recompile all stored procedures, user-defined functions and views in the database in order to MSSQL will refresh stores procedures execution plans stored in memory in order to reflect recent schema changes. Below is a small MSSQL code snipped written [...]

Here are instructions for setting SQL Explorer up with the extension, and connecting to a SQL Server database using the Microsoft SQL Server JDBC drivers. The extension is independent of the JDBC driver so while this example uses the Microsoft drivers, it should work with any JDBC driver that you can get working in SQL [...]