How can we help you today? How can we help you today?

How has SQL Prompt helped you?

Hello Friends,

Hope you're well and you enjoyed PASS Data Community Summit.

I've recently moved roles and I'm now the Product Marketing Manager for SQL Prompt and SQL Toolbelt Essentials  >:O

I've looking for some new SQL Prompt success stories to share with fellow database professionals on Redgate's website and social channels, and wondered if you can help?

If you've used SQL Prompt before, I'd be so grateful if you can share how SQL Prompt has helped you in the thread below.

Thanks,

Roseanna
Roseanna
0

Comments

4 comments

Sort by
  • robrich
    I'll break the seal.  It's very frequent that I want to select most but not all the columns.  Yeah, I could script the table definition in SSMS, flip over to VS Code, regex the column names out, string them together, then start editing.  Or I could just `select *`, copy results into Excel and delete columns.  Instead I type `select * from mytable`, move my cursor back to the `*` and push tab.  Up pops the full list of columns, and I'm nearly there.  Just saying, it's elegantly simple.
    robrich
    0
  • ScottSauber
    I like highlighting a row in the SSMS results and saying "Script as Insert" to automatically create an insert script for me. Super handy when I need to move that data over somewhere else (i.e. from my local Docker database into a migration script in Flyway).
    ScottSauber
    0
  • Roseanna
    Thanks so much @robrich and @ScottSauber >:O

    I'd love to hear more SQL Prompt success stories!
    Roseanna
    0
  • @dsfog
    I am a frequent user - and have been for the past 10 years or so.

    Star-expand is what got me onboard years ago.
    Now I use tab coloring for environments.
    F12 and Ctrl+F12 for definitions.
    MS intellisence has been disabled in favor of the help from Prompt.
    I use styling, CASE-formatting, and the aliasing (with automated prefixing of objects)
    snippets for frequently used code.
    Tab history for infrequently used code.

    Script as insert is frequently used to transport small data set between systems, and securing reference data.
    Export to Excel is a key selling point from Business Analysts in my organisation.

    When time available, I want to play with the use of integrating our data catalog with Extended Properties to allow descriptions to be shown on data sources directly within SSMS.

    In short - I'd be witing ssf and the like for hours if I had not a Prompt installation om my machine.
    @dsfog
    0

Add comment

Please sign in to leave a comment.