Post reply

SQL Features Explorer

  • August 6, 2021 at 12:00 am

    #3915467

    Comments posted to this topic are about the item SQL Features Explorer

  • August 6, 2021 at 6:28 am

    #3917353

    Intresting

    I always feel like im not using so much of the available stuff that SQL Server offers.

    Most of the stuff i discover is from reading forum replies here.

    I want to be the very best
    Like no one ever was

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

  • August 6, 2021 at 7:27 am

    #3917366

    This looks super-handy, thanks for sharing.

    Note the small typo on the web site though: EnterpriCe instead of EnterpriSe. Unless this was intentional, given the price for Enterprise Edition 🙂

     

  • August 6, 2021 at 12:35 pm

    #3917467

    Nice, but it would be nicer, if I could also search for

    • functions as CONCAT_WS(), STRING_AGG(), APPROX_COUNT_DISTINCT(), TRIM(), TRANSLATE()
    • OPTIMIZE_FOR_SEQUENTIAL_KEY (Index option for faster inserting MANY rows with increasing key)
    • WITHIN GROUP (belongs to STRING_AGG)
    • pausing index rebuild
    • "Memory optimized" instead of "Memory-optimized" -> ignore at least dashes in the search engine
    • Linux

    • This reply was modified 2 years, 11 months ago by  Thomas Franz.

    God is real, unless declared integer.

  • August 6, 2021 at 1:16 pm

    #3917495

    Adding all language feature changes would be great (I recently had to port code from 2016 to 2008 and relied on error messages to identify some of the differences.) However, this would be a big task for one person!

  • August 6, 2021 at 1:26 pm

    #3917497

    Does this SQL Features Explorer try to find all SQL Server instances that are on the network? Where I work, we have hundreds, perhaps thousands of SQL instances, most of which I don't have access to. What happens when I run it and it fails to access most SQL instances?

    Rod

  • August 6, 2021 at 3:29 pm

    #3917538

    Did you just click onto the link and tried it out? It is only a simple database / table on a webserver and a web frontend where you could enter a search text and it will do something as

    SELECT * from dbo.feature_table WHERE feature_name LIKE '%' + @search_text + '%'

    It is nothing you can download and does nothing local on your network (and if it COULD do that, you should check your security 🙂

    God is real, unless declared integer.

  • August 7, 2021 at 1:58 am

    #3917636

    No, I didn't. Thank you!

    Rod

  • August 7, 2021 at 5:13 am

    #3917661

    Sure Thomas,

    We will try to incorporate all the above features on our explorer tool.

    Thanks for your feedback.

    -Thiru

  • August 7, 2021 at 5:27 am

    #3917664

    Thank you @thierry.vandurme, we have modified as "Enterprise" in our portal.

  • October 28, 2021 at 7:33 pm

    #3945686

    This is a cool tool - thanks - duly bookmarked as no doubt will come in handy to have the info nicely laid out!

    https://sqlrider.net - My technical blog

Viewing 11 posts - 1 through 10 (of 10 total)

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