Robert Sterbal-482516 - Friday, June 23, 2017 4:51 AM
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
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
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.
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.
Awesome. Thanks for taking the time to post this.
Change is inevitable... Change for the better is not.
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
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
Jeff, It is very pleasant to hear from you words of gratitude, thank you!
robert.sheedy - Friday, June 23, 2017 9:36 AM
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:
Thanks and take care, Solomon..
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • 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.
Solomon Rutzky - Sunday, June 25, 2017 9:14 AM
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
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)