SQL Features Explorer

Question

Post reply

SQL Features Explorer

Thirunavukkarasu

Old Hand

Points: 334
More actions
August 6, 2021 at 12:00 am

#3915467

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

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

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

ktflash Default port Points: 1400 More actions · Answer 1

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

thierry.vandurme Hall of Fame Points: 3340 More actions · Answer 2

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 🙂

Thomas Franz Hall of Fame Points: 3897 More actions · Answer 3

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 3 years, 4 months ago by Thomas Franz.

God is real, unless declared integer.

nicksamuel SSC Enthusiast Points: 105 More actions · Answer 4

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!

Doctor Who 2 SSCrazy Eights Points: 8196 More actions · Answer 5

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

Thomas Franz Hall of Fame Points: 3897 More actions · Answer 6

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.

Doctor Who 2 SSCrazy Eights Points: 8196 More actions · Answer 7

Doctor Who 2

SSCrazy Eights

Points: 8196

August 7, 2021 at 1:58 am

#3917636

No, I didn't. Thank you!

Rod

Thirunavukkarasu Old Hand Points: 334 More actions · Answer 8

Sure Thomas,

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

Thanks for your feedback.

-Thiru

Thirunavukkarasu Old Hand Points: 334 More actions · Answer 9

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

sqlrider SSC Enthusiast Points: 104 More actions · Answer 10

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