SQL Server Management Studio add-ins

  • kast218

    SSCertifiable

    Points: 6355

    Comments posted to this topic are about the item SQL Server Management Studio add-ins

  • anthonyhorne@live.co.za

    SSC Journeyman

    Points: 79

    Supratimas buy link is invalid.  Should go to paypal, so user can rather just go to the site and link from there.

  • kast218

    SSCertifiable

    Points: 6355

    Anthony-203940 - Friday, July 21, 2017 1:56 AM

    Supratimas buy link is invalid.  Should go to paypal, so user can rather just go to the site and link from there.

    Thanks, fixed: https://github.com/ktaranov/sqlserver-kit/commit/427827ad10afd7278714f17cae5baa099dd46239

    Be free to post new errors and enchantments here or open issue or pull request on Github.

  • sebastien.sevrin

    SSC Enthusiast

    Points: 133

    Good initiative to have a summary of available add-ins.
    Though I prefer not to imagine what will happen to SSMS if you install all of the listed add-ins 🙂

  • kast218

    SSCertifiable

    Points: 6355

    sebastien.sevrin - Friday, July 21, 2017 3:17 AM

    Good initiative to have a summary of available add-ins.
    Though I prefer not to imagine what will happen to SSMS if you install all of the listed add-ins 🙂

    Thanks for your post, Seabstien.

    I works with 7 addins from this list on regular basis and SSMS works fast. Try it (especially SSMSBoost and Apex SQL Search) and after that it will be first step after fresh installation of SSMS.

  • gary.strange-sqlconsumer

    SSCommitted

    Points: 1800

    Can anyone recommend a free data generation tool?

  • kast218

    SSCertifiable

    Points: 6355

    gary.strange-sqlconsumer - Friday, July 21, 2017 4:04 AM

    Can anyone recommend a free data generation tool?

    https://github.com/ktaranov/sqlserver-kit#sql-server-test-data-generation

    Also DbForge Studio (https://www.devart.com/ru/dbforge/sql/studio/) have very nice GUI for data generation, its not free, but it has 30 days trial.
    Also developers can give you free license for Article and another promos - https://www.devart.com/discount-programs.html. Try it, its very robust solution.

    Also you can find tools with tag [G] here: https://rebrand.ly/gh-sql-server-tools

  • jonathan.d.myers

    Old Hand

    Points: 325

    I'd like to point out that the indicated version of "SQL Code Guard" is no longer available. The product was bought up by Red Gate and added to their existing product list with some new packaging. Their version is ONLY compatible with SSMS 2016, and provides no backwards compatibility.

    Oleksii's old site now redirects to the relevant Red Gate page, meaning it's unlikely the older installations compatible with prior SSMS versions would no longer be available.

    If anyone finds a link for the older versions, or finds another SSMS add-in that provides similar functionality for free, please post it here for reference.

    Thanks,
    Jonathan

  • kast218

    SSCertifiable

    Points: 6355

    jonathan.d.myers - Friday, July 21, 2017 12:08 PM

    I'd like to point out that the indicated version of "SQL Code Guard" is no longer available. The product was bought up by Red Gate and added to their existing product list with some new packaging. Their version is ONLY compatible with SSMS 2016, and provides no backwards compatibility.

    Oleksii's old site now redirects to the relevant Red Gate page, meaning it's unlikely the older installations compatible with prior SSMS versions would no longer be available.

    If anyone finds a link for the older versions, or finds another SSMS add-in that provides similar functionality for free, please post it here for reference.

    Thanks,
    Jonathan

    Hi, Jonathan. Thank you very much for your issue.

    I change SQLCodeGuard indo to red gate link: https://github.com/ktaranov/sqlserver-kit/commit/369c8550bd7619b4a1e397cff5f3091792a8761d.

    Also, you can try nuget package for not supported SSMS version, its old but works: https://www.nuget.org/packages/SqlCodeGuardNuget/

    One place for many distributives of SQL Server and SSMS with Addins you can find here: https://rebrand.ly/sql-server-distribs

  • sebastien.sevrin

    SSC Enthusiast

    Points: 133

    kast218 - Friday, July 21, 2017 3:31 AM

    sebastien.sevrin - Friday, July 21, 2017 3:17 AM

    Good initiative to have a summary of available add-ins.
    Though I prefer not to imagine what will happen to SSMS if you install all of the listed add-ins 🙂

    Thanks for your post, Seabstien.

    I works with 7 addins from this list on regular basis and SSMS works fast. Try it (especially SSMSBoost and Apex SQL Search) and after that it will be first step after fresh installation of SSMS.

    Even the right click on tables in the explorer on remote databases?
    With only Apex SQL search installed I had to wait for ages to get the contextual menu (and sometimes it did not appear at all).
    I googled and found others experiencing the same issue talking about removing the Apex extension. I did it and it was back to normal.
    The root cause seemed to be the several additional queries executed when you were doing a right click.
    It doesn't mean I find Apex SQL search useless, what I did was keep it on an older version of SSMS.
    That way when I need to do a DB search I use the "slow" SSMS, and for daily work I use the "latest and fast" one.

  • kast218

    SSCertifiable

    Points: 6355

    sebastien.sevrin - Saturday, July 22, 2017 6:48 AM

    kast218 - Friday, July 21, 2017 3:31 AM

    sebastien.sevrin - Friday, July 21, 2017 3:17 AM

    Good initiative to have a summary of available add-ins.
    Though I prefer not to imagine what will happen to SSMS if you install all of the listed add-ins 🙂

    Thanks for your post, Seabstien.

    I works with 7 addins from this list on regular basis and SSMS works fast. Try it (especially SSMSBoost and Apex SQL Search) and after that it will be first step after fresh installation of SSMS.

    Even the right click on tables in the explorer on remote databases?
    With only Apex SQL search installed I had to wait for ages to get the contextual menu (and sometimes it did not appear at all).
    I googled and found others experiencing the same issue talking about removing the Apex extension. I did it and it was back to normal.
    The root cause seemed to be the several additional queries executed when you were doing a right click.
    It doesn't mean I find Apex SQL search useless, what I did was keep it on an older version of SSMS.
    That way when I need to do a DB search I use the "slow" SSMS, and for daily work I use the "latest and fast" one.

    Thanks for feedback, what version of SSMS you have? Try another Search addin (from DbForge and Red Gate).

    I use Apex addin every day with SSMS 2017.1 on different workstation and didnt have big problems with SSMS performance.

  • VeritableHero

    Old Hand

    Points: 302

    Thank you for this post. For some reason, one of the tools had stopped working for me a few months back. I hadn't taken the time to look for alternatives.  This helped me find exactly what I was looking for and even one that was compatible with SSMS v17.  Thank you again!

  • kast218

    SSCertifiable

    Points: 6355

    VeritableHero - Monday, July 24, 2017 5:33 AM

    Thank you for this post. For some reason, one of the tools had stopped working for me a few months back. I hadn't taken the time to look for alternatives.  This helped me find exactly what I was looking for and even one that was compatible with SSMS v17.  Thank you again!

    You are welcome. Be free post here any issues and improvements for this list. If you have some questions about SQL Server (or R language) contact with me via my site: http://taranov.pro/en

  • Eric M Russell

    SSC Guru

    Points: 125032

    gary.strange-sqlconsumer - Friday, July 21, 2017 4:04 AM

    Can anyone recommend a free data generation tool?

    Define what your needs are regarding "data generation".

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • latish.sehgal

    SSC Enthusiast

    Points: 106

    Thanks for linking SqlSmash. I am the author. Just wanted to mention that it does support SSMS 2017 now.

Viewing 15 posts - 1 through 15 (of 28 total)

You must be logged in to reply to this topic. Login to reply