Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

SQL Operations Studio

github.com

Post reply on HN
Print view View original

81–90 of 96 posts

Re: SQL Operations Studio

#81

Post by sixdimensional »

samgaw wrote: post #54
sixdimensional wrote: post #7

I guess it's a good thing I didn't do the project I was thinking about. I observed the fact that SQL Server had no management tool that was cross-platform, and thought perhaps I would build such a thing. Nice work Microsoft! On a side-note, I'd love to see an even more minimalist stripped-down, read-mostly query/tabular result only (with pivot tables) tool, which had some local columnar storage caching/query engine,…

Have you looked at Metabase? http://www.metabase.com

Yes, thoroughly. It's a great project, my only regret is it would be nice to have a purely desktop based front-end utility. Metabase comes close in the fact that you can run one single JAR and be up and running, so it's close for sure. Maybe I am old school, but I think part of my gripe is due to the state of flux of merging traditional desktop UI and web or browser tech. For ordinary desktop users, running a JAR file so they can run a local server app in a browser seems too technical still.

I guess I'm saying, partially it's the packaging for end users who want to run independently like a standalone application which is the issue.

But yes, Metabase is great and the team working on it is doing a great job.

Re: SQL Operations Studio

#82

Post by timlin »

ElatedOwl wrote: post #79
jflowers45 wrote: post #6

I wonder what SSMS can do that this can't? SSMS is not cross platform as far as I know, whereas this is. Would be nice if they elaborated on the differences and pros/cons.

On my first cursory glance: no table designer, no execute stored procedure GUI There's a lot of little things I wish SSMS had/did (like inline text search for sproc/table) and was hoping this would have it. The execution plan screen (explain in this IDE) is a lot cleaner, though.

What do you mean "inline text search for sproc"?

I use a combination of SQL Hunting Dog http://sql-hunting-dog.com/ (quick search all object names) and a SQL script from the (free) SSMSBoost plugin that looks at most object definitions but not table columns unfortunately. I've used Red Gate's SQL Search in the past but it's always been slow and buggy over the VPN.

If you're looking for a better execution plan utility, check out SQL Sentry's Plan Explorer. It's free.

Re: SQL Operations Studio

#83

Post by sixdimensional »

FuriouslyAdrift wrote: post #67
j_s wrote: post #30

Earlier quoted context omitted.

These discussions have some options: Google Data Studio | https://news.ycombinator.com/item?id=15446049 (Oct 2017, 228 comments) PopSQL – Modern, collaborative SQL editor for your team | https://news.ycombinator.com/item?id=15377339 (Oct 2017, 49 comments) Franchise – An Open-Source SQL Notebook | https://news.ycombinator.com/item?id=15303833 (Sep 2017, 63 comments)

DBeaver... https://en.m.wikipedia.org/wiki/DBeaver

DBeaver is my favorite open source database admin tool. But it is a full admin tool with way too much UI, not the query only type use case.

Re: SQL Operations Studio

#84

Post by timlin »

nbevans wrote: post #72

This looks like SQL Server Management Studio will be deprecated once this project reaches a v1.0. About time too - as SSMS barely supports SQL Azure at all; pretty much all the useful GUI screens are not available.

If that's true, it'll be years before 1.0. There are many admin screens that this new tool will have to replicate.

Re: SQL Operations Studio

#85

Post by sixdimensional »

lowkeyokay wrote: post #55
sixdimensional wrote: post #7

I guess it's a good thing I didn't do the project I was thinking about. I observed the fact that SQL Server had no management tool that was cross-platform, and thought perhaps I would build such a thing. Nice work Microsoft! On a side-note, I'd love to see an even more minimalist stripped-down, read-mostly query/tabular result only (with pivot tables) tool, which had some local columnar storage caching/query engine,…

As for cross-platform, VS Code has a plugin for SQL Server. It doesn't provide all the graphical management tools that SSMS does but all the stored procedures are available, naturally. If you're on a Mac, i suggest [1] Hankinsoft's SQL Studio. I've been using it daily for a couple of years. It's very light weight and supports most db's. It has some neat functions too; like marking rows and columns, right click and ge…

QueryStorm looks cool and appears to use SQLite for local joins on the desktop, which gets you pretty far (column store would probably get you further). My only gripe here is being tied to Excel and potentially what looks like limited data source support.

Re: SQL Operations Studio

#86

Post by ConfucianNardin »

icc97 wrote: post #77
userbinator wrote: post #65

In case you're wondering, or just want to confirm the reason for the presence of a "privacy statement" --- yes, it does phone home: https://github.com/Microsoft/sqlopsstudio/tree/master/src/vs... At least the source is available, so it should be relatively easy to remove, but as the saying goes, "look before you leap"...

Looks like it's opt-in [0] [0]: https://github.com/Microsoft/sqlopsstudio/blob/6e05dd7fa13d2...

That looks like opt-out (it's named "telemetry.enableTelemetry" and has "'default': true").

Re: SQL Operations Studio

#87

Post by ElatedOwl »

timlin wrote: post #82
ElatedOwl wrote: post #79

Earlier quoted context omitted.

On my first cursory glance: no table designer, no execute stored procedure GUI There's a lot of little things I wish SSMS had/did (like inline text search for sproc/table) and was hoping this would have it. The execution plan screen (explain in this IDE) is a lot cleaner, though.

What do you mean "inline text search for sproc"? I use a combination of SQL Hunting Dog http://sql-hunting-dog.com/ (quick search all object names) and a SQL script from the (free) SSMSBoost plugin that looks at most object definitions but not table columns unfortunately. I've used Red Gate's SQL Search in the past but it's always been slow and buggy over the VPN. If you're looking for a better execution plan utility…

In the object explorer just some text input that would filter accordingly. Some of our databases have a TON of tables/sprocs and it would be a nice convenience.

SQL Hunting Dog looks exactly like what I've been wanting, thanks for the recommendation!

Re: SQL Operations Studio

#88

Post by wluu »

GFischer wrote: post #2

Would this be the "Visual Studio Code" to the SQL Server Management Studio? No mention of CosmosDB (I want some kind of SSMS equivalent for CosmosDB).

I think so. It’s based on a fork of Visual Studio Code.

Re: SQL Operations Studio

#89

Post by BrentOzar »

will_hughes wrote: post #26
chungy wrote: post #8

Unfortunate license, you can't redistribute it, verbatim or otherwise.

I just logged an issue suggesting a change of license: https://github.com/Microsoft/sqlopsstudio/issues/102

I had a discussion with MS about it, and they're going to update the Github issue soon. Short story is that they're not going to consider changing the license until general availability, but they're gathering feedback in the meantime.

Re: SQL Operations Studio

#90

Post by styfle »

jflowers45 wrote: post #6

I wonder what SSMS can do that this can't? SSMS is not cross platform as far as I know, whereas this is. Would be nice if they elaborated on the differences and pros/cons.

My first thought is any SSMS specific plugins such as RedGate SQL Search and version control.
Post reply on HN