Microsoft SQL Server Utilities and Tools

  • Robert Sterbal-482516 - Friday, June 23, 2017 4:51 AM

    There are a few steps to repurposing content to a wiki. I'd be happy to get the process started to see if it makes any sense.

    Essentially every resource will be given its own page, and one ore more categories. The main category will be:

    https://sqlserver.miraheze.org/wiki/Category:SQL_Server_KIT

    Robert, thanks for your initiative. But I think wiki for this type info is not good choice (hard to compare different types tools and too many clicks). If you want to contribute to this list - please, open issue or pull request in Github (here you can find simple steps to start contributing - https://github.com/ktaranov/sqlserver-kit/blob/master/CONTRIBUTING.md, if you need help with github I can teach you some basics).

  • databoffin - Friday, June 23, 2017 4:28 AM

    kast218 - Friday, June 23, 2017 3:55 AM

    databoffin - Friday, June 23, 2017 3:09 AM

    Hi, I tried to update this via git a few months back bu OmniCompare is now Aireforge Studio.

    It’s hard to categorise but I would say it falls into [IDX],[MG], [SC].

    Cheers,
    Phil

    Thanks for your useful product, update info and rename it: https://github.com/ktaranov/sqlserver-kit/commit/1101140c6200f4a8b962625f64a763899d51d276. Are you planing add support for SQL Server 2017?

    Yeah, we already support it and Azure SQL database.

    Awesome news, I will test it on our development environment with SQL Server 2017. Could you compare your tool with alternatives from Red Gate, DbForge and ApeSQL?

  • kast218 - Friday, June 23, 2017 7:11 AM

    databoffin - Friday, June 23, 2017 4:28 AM

    kast218 - Friday, June 23, 2017 3:55 AM

    databoffin - Friday, June 23, 2017 3:09 AM

    Hi, I tried to update this via git a few months back bu OmniCompare is now Aireforge Studio.

    It’s hard to categorise but I would say it falls into [IDX],[MG], [SC].

    Cheers,
    Phil

    Thanks for your useful product, update info and rename it: https://github.com/ktaranov/sqlserver-kit/commit/1101140c6200f4a8b962625f64a763899d51d276. Are you planing add support for SQL Server 2017?

    Yeah, we already support it and Azure SQL database.

    Awesome news, I will test it on our development environment with SQL Server 2017. Could you compare your tool with alternatives from Red Gate, DbForge and ApeSQL?

    There isn't a tool like Aireforge Studio, therefore it's hard to make a comparison.

    I guess the Compare module is like SQL Compare but for server, instance and database settings, rather than database objects. Although we do compare database object counts and provide the ability to launch SQL Compare should they differ.

    The closest tool to the new Advise module would be the Microsoft Best Practice Analyzer, although Advise has more features and provides functionality similar to an index management tool.

    Solving data & infrastructure issues via xTEN[/url] and our application, Aireforge[/url].

  • That's quite a list, Konstantin.  Thanks for putting it together.

  • You might consider adding these to your list. They're not free but they are very affordable.
    DbVisualizer  (http://www.dbvis.com/)
    DbSchema  (http://www.dbschema.com/)

  • Awesome.  Thanks for taking the time to post this.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • Thanks for the great list. Surprised that Redgate's SQL Search wasn't listed, I use it nearly everyday.

  • aksturgeon 40144 - Friday, June 23, 2017 9:02 AM

    You might consider adding these to your list. They're not free but they are very affordable.
    DbVisualizer  (http://www.dbvis.com/)
    DbSchema  (http://www.dbschema.com/)

    Great thanks for this tools, added: https://github.com/ktaranov/sqlserver-kit/commit/012653673734ba7c21797ac24eb2aedbd89c0883. Be free to post any others utilities here or on Github repo. Thanks again.

  • Jeff Moden - Friday, June 23, 2017 9:04 AM

    Awesome.  Thanks for taking the time to post this.

    Jeff, It is very pleasant to hear from you words of gratitude, thank you!

  • robert.sheedy - Friday, June 23, 2017 9:36 AM

    Thanks for the great list. Surprised that Redgate's SQL Search wasn't listed, I use it nearly everyday.

    Robert, thank you very much for your answer.

    SQL Search from Redgate you can find in SSMS Addins page - SQL Search. I highly recommend you try more robust alternatives: DbForge Search and Apex SQL Search
    Also must have SSMS Addon - SSMS Boost.

  • Great job putting this list together. It's a bit more detailed than other similar lists I have seen. Can you please add SQL# ( http://www.SQLsharp.com/ ) to your list? Sorry, I don't have time right now to edit it myself and do a pull request. Thanks 🙂

    And the other info available at your sqlserver-kit site is quite handy. The only issue I see is that you have some actual code copied up there that should either be attributed with the author's name and/or the source URL, or removed entirely. The following repository folder has examples of both:

    https://github.com/ktaranov/sqlserver-kit/tree/master/CLR

    • The two string split scripts: one looks like it came from the forum related to Jeff Moden's Tally Oh 8k splitter article (here on SQL Server Central), and the other maybe perhaps came from Adam Machanic?
    • The two SQLsharp (i.e. SQL#) scripts should not be there. Please remove them. Don't get me wrong, I certainly appreciate that you like and support SQL#, but it would be even more supportive (and more appropriate) to simply add SQL# to the list of SQL Server Utilities and Tools. Yes, that version of SQL# is free, but you don't have rights to distribute it any more than you are allowed to distribute (by itself) SQL Server Express Edition (which is also free).

    Thanks and take care, Solomon..

    SQL#https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lifthttps://SqlQuantumLift.com/ ( company )
    Sql Quantum Leaphttps://SqlQuantumLeap.com/ ( blog )
    Info sitesCollations     •     Module Signing     •     SQLCLR

  • Your information about SolarWinds Database Performance Advisor appears to be incorrect. For example, we are cross-platform, supporting many different databases (Oracle, Amazon RDS, MySQL, DB2, the artist formerly known as Sybase, etc.). And there is a free version of DPA. And SolarWinds has other tools for SQL Server, too, that should be on this list. Not sure how you compiled this list but given the length, I can certainly understand how some details might have been missed.

    ----------------------
    https://thomaslarock.com

  • Solomon Rutzky - Sunday, June 25, 2017 9:14 AM

    Great job putting this list together. It's a bit more detailed than other similar lists I have seen. Can you please add SQL# ( http://www.SQLsharp.com/ ) to your list? Sorry, I don't have time right now to edit it myself and do a pull request. Thanks 🙂

    And the other info available at your sqlserver-kit site is quite handy. The only issue I see is that you have some actual code copied up there that should either be attributed with the author's name and/or the source URL, or removed entirely. The following repository folder has examples of both:

    https://github.com/ktaranov/sqlserver-kit/tree/master/CLR

    • The two string split scripts: one looks like it came from the forum related to Jeff Moden's Tally Oh 8k splitter article (here on SQL Server Central), and the other maybe perhaps came from Adam Machanic?
    • The two SQLsharp (i.e. SQL#) scripts should not be there. Please remove them. Don't get me wrong, I certainly appreciate that you like and support SQL#, but it would be even more supportive (and more appropriate) to simply add SQL# to the list of SQL Server Utilities and Tools. Yes, that version of SQL# is free, but you don't have rights to distribute it any more than you are allowed to distribute (by itself) SQL Server Express Edition (which is also free).

    Thanks and take care, Solomon..

    Solomon, thanks for your detailed post and your patience. Your scripts removed: https://github.com/ktaranov/sqlserver-kit/commit/e588c10ef64f562c3bc6b98805be98ac460ab05f

    I am very sorry that I did not properly understand the EULA.

    Great thanks for your free scripts, its link maintained in main README file in Web Resource -> Other section (second link after sp_whoisactive).

  • What about DB Ghost (http://www.dbghost.com/)

  • SQLRockstar - Sunday, June 25, 2017 1:06 PM

    Your information about SolarWinds Database Performance Advisor appears to be incorrect. For example, we are cross-platform, supporting many different databases (Oracle, Amazon RDS, MySQL, DB2, the artist formerly known as Sybase, etc.). And there is a free version of DPA. And SolarWinds has other tools for SQL Server, too, that should be on this list. Not sure how you compiled this list but given the length, I can certainly understand how some details might have been missed.

    Hi, Thomas. First of all thank you very much for your blog - very useful and interesting articles, write more please). Also thanks for your reply - I updated info on Github about SolarWinds products (https://github.com/ktaranov/sqlserver-kit/commit/4158311c221b01258dedf292e70ca0aa788cb517). If you find some mistakes or new tools be free to post here or open pull request on Github.

    I trying to download trial version from Solarwinds site (guys, why are you ask me about my phone number? I don't want that anyone call to me, please make this field optional) but no letter with download link or anything happened. Could you provide some killer and unique feature of your product?

Viewing 15 posts - 16 through 30 (of 74 total)

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