Automate SSMS 2016 with Visual Commander

Visual Commander v2.5 adds supports for SQL Server Management Studio 2016 (July v13.0.15500.91 and newer releases):

With Visual Commander you can record a text editing macro and play it back multiple times. You can save and edit the recorded macro as a C# or VB command to add more functionality to it.

You can create commands to quickly insert predefined or generated text to the editor, for example Insert current date and time.

You can access SSMS automation API not available with standard commands and controls. For example, SSMS doesn’t include an extension manager, but you can List installed extensions and you can uninstall an extension (Visual Commander) with the following C# command (References – Microsoft.VisualStudio.ExtensionManager):

public class C : VisualCommanderExt.ICommand
{
    public void Run(EnvDTE80.DTE2 DTE, Microsoft.VisualStudio.Shell.Package package) 
    {
        System.IServiceProvider serviceProvider = package as System.IServiceProvider;
        Microsoft.VisualStudio.ExtensionManager.IVsExtensionManager em =
           (Microsoft.VisualStudio.ExtensionManager.IVsExtensionManager)serviceProvider.GetService(
                typeof(Microsoft.VisualStudio.ExtensionManager.SVsExtensionManager));
	
        Microsoft.VisualStudio.ExtensionManager.IInstalledExtension vcmd = 
            em.GetInstalledExtension("e4b1fd83-b59d-41ca-a21d-19b10230ece5");
        em.Uninstall(vcmd);
        System.Windows.MessageBox.Show(vcmd.Header.Name + " has been uninstalled.");
    }
}

You can subscribe to internal SSMS events and perform automatic tasks with Visual Commander extensions. For example, AutoSave code when SSMS loses focus.

Please, share your ideas and code to automate repetitive SSMS tasks in comments.

Download link: Visual Commander for SSMS 2016 v2.5.

Posted in Vlasov Studio tools | Tagged | Leave a comment

Task Canvas v1.3 adds more options and commands

The Task Canvas extension for Visual Studio 2015 lets you edit multiple methods from different classes in one window and quickly switch between document groups.

v1.3 adds several Task Canvas window options, commands to open and activate the Task Canvas window, support for project reloading:

See the full what’s new list. Download the installer.

Posted in Vlasov Studio tools | Tagged , | Leave a comment

Visual Commander v2.4.1 adds support for C# v6.0

Visual Commander is a freemium extension for Visual Studio 2010+ allowing you to automate repetitive tasks in the IDE.

Visual Commander Professional v2.4.1 adds the option to select C# v6.0 compiler in Visual Studio 2015 (the free edition supports only C#/VB v4.0) and use features like string interpolation in your commands:

In Visual Studio “15” you can use C# v7 features like local functions:

Download the installer.

Posted in Vlasov Studio tools | Tagged , , | Leave a comment

Favorite Documents v2.2 adds support for Visual Studio “15”

Favorite Documents extension lets you create links to frequently used code files and then quickly open them as a group or individually in Visual Studio 2010+.

v2.2 adds support for Visual Studio “15” and sets the Favorite Documents tool window to dock near Solution Explorer by default. See the complete what’s new list.

Download the installer.

Posted in Vlasov Studio tools | Tagged , | Leave a comment

Tabs Studio v4.0 released

Tabs Studio is a Visual Studio and SSMS extension empowering you to work comfortably with any number of open documents.

v4.0 stops support for Visual Studio 2008/SSMS 2008 and adds Task Canvas tab tracking exclusion to the TrackEd add-in.

See the full what’s new list. Download the installer.

Posted in Vlasov Studio tools | Leave a comment

Visual Commander v2.4 adds support for Visual Studio “15”

Visual Commander is a freemium extension for Visual Studio 2010+ allowing you to automate repetitive tasks in the IDE.

v2.4 adds support for Visual Studio “15” Preview 3 and IntelliSense support for mscorlib.dll classes in VS 2015+ for the professional edition.

Download the installer.

Posted in Vlasov Studio tools | Tagged , | Leave a comment

Task Canvas v1.2 released

The Task Canvas extension for Visual Studio 2015 lets you edit multiple methods from different classes in one window and quickly switch between document groups.

v1.2 adds a tab tooltip with the full document path, fixes missing underscores in a tab title and prevents find in files results opening in a code block in the Task Canvas window.

Download the installer.

Posted in Vlasov Studio tools | Tagged , | Leave a comment