Post reply

SQL Server Management Studio add-ins

  • July 21, 2017 at 12:04 am

    #331890

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

  • July 21, 2017 at 1:56 am

    #1952009

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

  • July 21, 2017 at 2:09 am

    #1952010

    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.

  • July 21, 2017 at 3:17 am

    #1952014

    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 🙂

  • July 21, 2017 at 3:31 am

    #1952016

    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.

  • July 21, 2017 at 4:04 am

    #1952019

    Can anyone recommend a free data generation tool?

  • July 21, 2017 at 4:22 am

    #1952022

    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

  • July 21, 2017 at 12:08 pm

    #1952180

    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

  • July 22, 2017 at 5:47 am

    #1952238

    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

  • July 22, 2017 at 6:48 am

    #1952240

    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.

  • July 22, 2017 at 2:14 pm

    #1952248

    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.

  • July 24, 2017 at 5:33 am

    #1952333

    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!

  • July 24, 2017 at 6:07 am

    #1952338

    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

  • July 24, 2017 at 6:57 am

    #1952351

    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

  • July 24, 2017 at 4:39 pm

    #1952480

    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 37 total)

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