Voice of the DBA

Tag: Redgate

  • The Database DevOps Roadshow Continues (with fun photos)

    At SQL Saturday Denver 2023, I had a few people ask me about the Redgate Database DevOps roadshow and how it was going. A few people asked about the van as well.

    Here’s the van, with my ready to rock in Chicago:

    IMG_5860

    Chicago is done, but we have a few more dates coming:

    • Oct 11 – Atlanta
    • Oct 19 – Jacksonville
    • Oct 26 – San Diego
    • Nov 1 – San Francisco
    • Nov 14 – Seattle

    All these are on the Redgate Events page.

    IMG_5776_copy

    I won’t be doing any in October, as you can see above, I’m tired. With the 3 US ones and the 3 UK ones I did across Aug/Sept, I was gone 24 days from Aug 23-Sept 21. I need a break, as shown below:

    IMG_6182

    The show goes on, and I’ll see (some) of you in Nov.

    Redgate-on-the-move

  • Visiting the New Jersey Office

    I’m in the Redgate Software New Jersey office today (actually yesterday as well) for the first time. This is a new location for us, and Grant, Ryan, and myself are trying to visit the offices regularly to meet with other employees, do some training, and help them become more successful in their jobs. Regularly seems to be 1-2x a year in each office, but that’s better than zero.

    We also do some company wide training, and we’re doing this month’s from New Jersey, which is kind of cool. While lots of attendees are virtual, it’s always nice to have a few people in the room.

    I’m also going to spend a few hours at a PostgreSQL conf in New York, which isn’t something I’ve done. Redgate is doing more cross-db platform work, so this is a new area for me.

    I’m also taking advantage of the opportunity to take Friday off and go see my daughter in upstate New York. I’ll be back next Wed Winking smile

  • SQL Prompt Quick Access to Helper Code

    We’ve been doing some events as part of the Redgate Roadshow, and at one of the events, we had a customer ask about something that we demo’d. This post looks at quick access to snippets.

    This is part of a series on SQL Prompt that I’ve written. If you’ve never tried SQL Prompt, it’s amazing. Download an eval today.

    The Command Palette from the Query Editor

    When typing a query in SSMS, I can hit the CTRL button and get the palette on the side. Here’s a basic query:

    2023-09-04 04_39_35-SQLQuery3.sql - ..dlm_1_dev (WAY0UTWESTHP_way0u (89))_ - Microsoft SQL Server Ma_thumb[1]

    I might want to add the begin and end around my code in the proc. If I highlight some code and hit CTLR, I see this:

    2023-09-04 04_40_25-SQLQuery3.sql - ..dlm_1_dev (WAY0UTWESTHP_way0u (89))_ - Microsoft SQL Server Ma_thumb[1]

    On the left, I have opened the palette where I can down arrow to pick something relevant or search for a command that helps me. As you can see, the first one is the very common “add begin end” to the code. If I pick this, it will surround my code with begin end, as seen here:

    2023-09-04 04_43_07-SQLQuery3.sql - ..dlm_1_dev (WAY0UTWESTHP_way0u (89))_ - Microsoft SQL Server Ma_thumb[1]

    I can also get other helper code, like the CTE outline, as you can see below:

    2023-09-25 15_16_58-SQLQuery14.sql - ARISTOTLE.sandbox (ARISTOTLE_Steve (75))_ - Microsoft SQL Serve

    SQL Prompt is amazing, as this video shows. Download an eval today.

  • Opening the SQL Prompt Command Palette

    A few years ago SQL Prompt added a command palette to let you search the commands available. This is similar to the same concept in Visual Studio Code, ADS, and various other tools. This post looks at how to get to this tool in SSMS.

    This is part of a series of posts on SQL Prompt, which is an amazing productivity tool from Redgate Software.

    Opening the Palette

    You can also open the Command Palette from the menu. In the SQL Prompt menu, it is the first item. You can also see there is a shortcut of ALT+S below here.

    2023-09-04 04_44_26-

    When I click this, I’ll see the full list of palette commands. This is a large window, and across the top I can filter things. In the complete list, you see various things: objects, snippets, and refactoring commands. We also have the Prompt behavior settings as well.

    2023-09-04 04_44_43-SQL Prompt_ Command Palette

    For example, I could look for things with “brackets”. I see a few things that are relevant. I can pick any of them if I want that apply to my code or change the behavior of the tool

    2023-09-04 04_52_25-SQL Prompt_ Command Palette

    Adding to the Menu

    If you can’t remember the shortcut. or don’t want to use the menu, you can add this as a button in the toolbar. Here’s the easy way. When you installed SQL Prompt (or the Toolbelt), there is a Redgate toolbar added. Mine looks like this:

    2023-09-04 07_29_16-SQLQuery3.sql - ..dlm_1_dev (WAY0UTWESTHP_way0u (92)) - Microsoft SQL Server Man

    I clicked the “Add or Remote buttons ” and got a list of buttons on this toolbar. I can click “Customize if I like. That opens the dialog below.

    2023-09-04 07_51_53-Customize

    Now click “Add Command”. That gives you a list of items in all the menus in SSMS. Pick the SQL Prompt menu on the left (first one). Then scroll down and find “Open command palette” in the right side. Select it and click OK.

    2023-09-04 07_52_16-SQLQuery3.sql - ..dlm_1_dev (WAY0UTWESTHP_way0u (92)) - Microsoft SQL Server Man

    Now you have this in your toolbar.

    2023-09-04 07_52_25-SQLQuery3.sql - ..dlm_1_dev (WAY0UTWESTHP_way0u (92)) - Microsoft SQL Server Man

    Now one click, and you have the palette.

    FWIW, you can use this trick to add any menu item to a toolbar that you want.

    UPDATE: A comment asked about partial matches, and you can see I see partial matches for “Addre”.

    Partial match of a word in the command palette