Slapout Tech

I recently wanted to create an SSMS plugin so I was happy to run across Red Gate’s SSMS ecosystem project . It comes with the C# code for a sample plugin, which is nice. But I couldn’t find any documentation on how to setup a new plugin from strach. It wasn’t hard to figure out though. One Time Setup The first thing you need to do is to install the Red Gate SSMS Ecosystem Framework . This only has to be done once – it doesn’t have to be repeated for every plugin you write. Each Time Setup Here are the steps to follow in Visual Studio for every plugin you create: 1) Create a new Class Library 2) Search Nuget for “Redgate SSMS” and install the RedGate.SIPFrameworkShared package. 3) Rename Class1 to something more fitting. 4) At the top of your code add “using RedGate.SIPSharedFramework”. 5) Create a registry entry for your plugin. The location will depend on whether you’re running a 32-bit or 64-bit version of Windows. 32-bit: HKLM\SOFTWARE\Red Gate\SIPFramework\Plugins 64-bi...

I’ve been working a lot with Sql Server Management Studio (SSMS) lately and thought I’d share some tips I’ve ran across to make it easier to use. 1) Change the number in Select & Edit. When you right-click on a table in SSMS two of the options you are given are “Select Top 1000 Rows” and “Edit Top 200 Rows”. You can change these numbers. To do so, select Tools –> Options in the menu. In the Options dialog select “SQL Server Object Explorer”. Under Table and View Options you can change the default values. 2) Change the connection color You can change the color at the bottom of the query window based on the database you are connected to. On the connection dialog select “Options >>”. Then select the “Use custom color” dialog and use the “Select” button to pick a color. Now when you’re connected to the database, the bottom of the query editor window will be the color you selected. I like to set my TEST database to green and the PROD database to red. 3) Change the Edit ...