June 23, 2017 at 7:09 am
Robert Sterbal-482516 - Friday, June 23, 2017 4:51 AMThere 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:
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).
June 23, 2017 at 7:12 am
databoffin - Friday, June 23, 2017 4:28 AMkast218 - Friday, June 23, 2017 3:55 AMdataboffin - Friday, June 23, 2017 3:09 AMHi, 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,
PhilThanks 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?
June 23, 2017 at 7:41 am
kast218 - Friday, June 23, 2017 7:11 AMdataboffin - Friday, June 23, 2017 4:28 AMkast218 - Friday, June 23, 2017 3:55 AMdataboffin - Friday, June 23, 2017 3:09 AMHi, 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,
PhilThanks 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.
June 23, 2017 at 7:52 am
That's quite a list, Konstantin. Thanks for putting it together.
June 23, 2017 at 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/)
June 23, 2017 at 9:04 am
Awesome. Thanks for taking the time to post this.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2017 at 9:36 am
Thanks for the great list. Surprised that Redgate's SQL Search wasn't listed, I use it nearly everyday.
June 24, 2017 at 2:42 pm
aksturgeon 40144 - Friday, June 23, 2017 9:02 AMYou 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.
June 24, 2017 at 2:44 pm
Jeff Moden - Friday, June 23, 2017 9:04 AMAwesome. Thanks for taking the time to post this.
Jeff, It is very pleasant to hear from you words of gratitude, thank you!
June 24, 2017 at 2:48 pm
robert.sheedy - Friday, June 23, 2017 9:36 AMThanks 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.
June 25, 2017 at 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
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
June 25, 2017 at 1:07 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.
----------------------
https://thomaslarock.com
June 25, 2017 at 2:35 pm
Solomon Rutzky - Sunday, June 25, 2017 9:14 AMGreat 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).
June 25, 2017 at 4:42 pm
What about DB Ghost (http://www.dbghost.com/)
June 26, 2017 at 3:06 pm
SQLRockstar - Sunday, June 25, 2017 1:06 PMYour 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