21 ms·
SQL Operations Studio
- GFischer 9y agoWould 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).
- ah- 9y agoI think there's a VS Code plugin for CosmosDB.
- spthorn60 9y agoIt seems like that's the direction they're taking. But there is a lot of SSMS functionality I can't do without (replication, sql agent, RedGate SQL Prompt!, etc). This is a good start, but still a ways from a solid DBA tool. Pretty dashboard, so maybe I can keep it on a 3rd monitor but do all the heavy lifting in SSMS.
- wluu 9y agoI think so. It’s based on a fork of Visual Studio Code.
- yarovoy 9y agoThey added some preview support for CosmosDB recently to Azure Storage Explorer. https://azure.microsoft.com/en-us/features/storage-explorer/ https://azure.microsoft.com/en-us/features/storage-explorer/ But I haven't used it with CosmosDB yet.
- jacquesc 9y agoNo Postgres support yet. Looks like a great app though. https://github.com/Microsoft/sqlopsstudio/issues/56 https://github.com/Microsoft/sqlopsstudio/issues/56
- WesleyLivesay 9y agoI hope this grows like VS Code has since it was launched. Will hopefully add support for a lot of different DBs.
- userbinator 9y agoYou're kidding, right? This is a Microsoft product. Microsoft have their own database. What value is it to them to help people continue using competitor's products? Besides, it's not like Postgres doesn't have plenty of GUI tools already: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...
- hobs 9y agoI was actually in the room listening as the question came up to the team that makes this tool, its not off the table at all. The value to them is Azure, which hosts open source databases, why not give your customers the decent tooling at the same time? You'll even find things in the tool that reference non-Microsoft language, eg the button generally labeled "Estimated Execution Plan" in SQL Server Management Studio is labeled "Explain". The methodology behind the plugin absolutely allows abstracting out the MSSQL specific components, its just an open source fork of VS Code.
- karma_fountain 9y agoI implore you to do this. Every time pgadmin dies, I also die a little inside.
- pkaye 9y agoWell Microsoft does offer PostgreSQL on Azure from what I can tell... https://azure.microsoft.com/en-us/services/postgresql/ https://azure.microsoft.com/en-us/services/postgresql/
- reificator 9y agoNot kidding. If my database is Postgres, I develop for it in Visual Studio Code and deploy it to Azure, why shouldn't I be able to explore it with another Microsoft product. I grew up with the Microsoft you describe, but they've been gone for several years now. Not to say they can do no wrong, or that we shouldn't be wary, but to think it ridiculous that they could support multiple databases is not compatible with their actions lately.
- johnnyb9 9y agoWith minimal effort this may prove better than SSMS.
- jflowers45 9y agoI 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.
- neves 9y agoI also would like to know. I use Management studio at work. It would be great to find a good multiplataform that I can use everywhere.
- FuriouslyAdrift 9y agoI use DBeaver for cross platform support of SQL Servr at work. Obvious missing things like Query Plan support and all the newer goodies. For basic query design and ad hoc work it's great.
- kthejoker2 9y agoSsms has menus and GUIs and such for all the non database SQL Server items like SSIS, SSAS (full cube browser), SQL agent, CLR, plus creating more advanced objects like Credentials and application roles and scenarios like suggesting indexes and performing DB maintenance. This is purely a database development tool, at least in its current form.
- rajadigopula 9y agoSCM?! If it can, then I am sold.
- ElatedOwl 9y agoOn 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.
- timlin 9y agoWhat do you mean "inline text search for sproc"? I use a combination of SQL Hunting Dog http://sql-hunting-dog.com/ 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.
- sixdimensional 9y agoI 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, and simple import/export to common file formats as well. A simple "SQL notebook" that was cross platform, if you will, but worked more like a traditional query tool. And not embedded in MS Excel, like PowerQuery or PowerPivot (although it's powerful!). Something lighter weight than BI tools such as Power BI, Tableau, Qlik, etc., definitely lighter weight than tools such as SSMS, DBeaver, SQuirrel, etc. - not for administrative use. I've seen a few applications that are coming close listed on HN lately, but would be nice to have something as pretty as this and which is open source. Perhaps a fork with the admin features stripped out, some additional plumbing added, and read-only connections, I'm not sure. Will have to think about it. Main use case is data scientists / data analysts / SQL power users.
- cbcoutinho 9y agoI'm also looking for a tool like this. I think plot.ly's new Falcon tool comes close to barebones sql + plotting. [0] I love reading blog posts on small projects hooking up sql and simple data analysis - check out this small Flask/sql/d3 app I found earlier [1]. I'm not sure how closer a stripped down product can come to something like this. I guess you could wrap everything into an electron app, but maybe I think it would then be overkill for what I've been looking for. [0]: https://plot.ly/free-sql-client-download/ https://plot.ly/free-sql-client-download/ [1]: http://www.datasciencebytes.com/bytes/2015/03/07/a-d3js-plot-powered-by-a-sql-database/ http://www.datasciencebytes.com/bytes/2015/03/07/a-d3js-plot...
- rahilsondhi 9y agoExcuse me for my second plug this week, but we've built almost exactly what you're describing over at PopSQL (https://popsql.io https://popsql.io).
- sixdimensional 9y ago
- chungy 9y agoUnfortunate license, you can't redistribute it, verbatim or otherwise.
- giancarlostoro 9y agoHopefully that changes, it would become a really great cross platform SQL toolset, especially if and when they add in support for other SQL databases. Might be focused for Azure / MSSQL like Azure Storage Explorer is for Azure Blob Storage only (not sure what else it would support really).
- will_hughes 9y agoI just logged an issue suggesting a change of license: https://github.com/Microsoft/sqlopsstudio/issues/102 https://github.com/Microsoft/sqlopsstudio/issues/102
- BrentOzar 9y agoI 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.
- will_hughes 9y agoThanks for the update.
- jensvdh 9y agoNo Support for SQLite?
- WesleyLivesay 9y agoWith this being Public Preview 1 I hope they add more DB type support over the coming months.
- eat_veggies 9y agohow does this compare with datagrip? https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/
- giancarlostoro 9y agoThis one's directed at Microsoft SQL offerings, including the ones in the Azure cloud. Whereas DataGrip is for most SQL databases. Also this one's free, and DataGrip isn't (almost a shame but it's worth it's salt). DataGrip definitely is more featureful since it's been around a bit longer. Funnily enough the one Microsoft made looks like it derives from Visual Studio Code, much like MSSQL Management Studio derives from regular Visual Studio, and I think that'll mean Microsoft might embed some features from this into Visual Studio Code, but that's me just speculating, and it could take a while before they do.
- megaman22 9y agoIt'd be nice if SQL Management Studio and Visual Studio from the same generations were based upon the same platform, although I can understand why that's difficult and why SQLMS lags behind. I did get a little sick of having VS 2010 components kicking around for years after I'd moved on.
- sjellis 9y agoI am wondering if the long-term solution is going to be that SQL Management Studio goes away, in favor of SQL Operations Studio and possibly some other graphical tools for more specialized things like data warehousing etc. The more good next-generation cross-platform tooling that MS roll out, the more it sort of grates to have to flip back into a Windows system for that one specific thing.
- flukus 9y agoFinally, DBA's can experience the "wonders" of electron too. When you accidentally select * and get 100,000 items back how does the non-native table view hold up?
- SigmundA 9y agoHopefully they use a virtualized grid, which there are more than one js ones to choose from that have no problem with 100,000 rows.
- dfox 9y agoI don't think that virtualized grid is an good idea for something that is primarily meant as GUI for SQL database that implicitly exposes the SQL to user.
- recursive 9y agoYou might have a good reason for thinking that, but I can't tell from this comment.
- dfox 9y ago1) efficient implementation of data source for virtualized on top of relational (or otherwise not directly addressable) grid involves having some knowledge of how the data looks in order to be able to get only the relevant part of data by using indices ant not by geting rows 1000-1100 by selecting first 1100 and then throwing first 1000 out (which is how LIMIT 100 OFFSET 1000 is implemented by essentially all SQL databases) 2) when presenting results of user supplied SQL in this way you have to rewrite it somehow, which means that database ends up running different query than what the user entered, which is counterintuitive behavior and there certainly are cases where it is not desirable at all.
- SigmundA 9y agoA virtualized grid does not mean the data request is virtualized all the way to the sql server. The main issue with displaying 100,000 rows in the browser is DOM overhead. A virtualized grid like Slickgrid which they are using, reuses dom elements as you scroll and in its simplest form is just backed by an in-memory JS object. Once you start exceeding what works well in memory you can move to a local temp file system, which it sounds like what they are doing. None of this has anything to do with the SQL server itself, it simply sends the entire result set to the client which deals with buffering and virtualizing it to the UI in whatever way necessary. This is how native SQL UI's tend to work, I have never seen one rewrite SQL to try and virtualize all the way to the DB. Obviously unless you do use the DB there will be limits, but 100,000 rows fits entirely in memory without issue: checkout this sample: http://mleibman.github.io/SlickGrid/examples/example-optimizing-dataview.html http://mleibman.github.io/SlickGrid/examples/example-optimiz...
- johnhenry 9y agoAn overview would be awesome: https://docs.microsoft.com/en-us/sql/sql-operations-studio/what-is https://docs.microsoft.com/en-us/sql/sql-operations-studio/w...
- genieyclo 9y agoThis is a good time to ask: is there any good SQL IDE for Oracle better than SQL Developer?
- jpitz 9y agoToad used to be a great choice. I would look there.
- caltelt 9y agoI'd be interested in something better as well. I was testing SQuirrel SQL the other day (have used it before for MSSQL), but the Oracle plugins for it seem to have succumb to bitrot over the past couple of years. UI can hang for minutes on new connections, CTE's aren't recognized as valid syntax, searching Objects is slow and cumbersome. I know a few people who just use Intellij for it.
- emmelaich 9y agoProbably not better but have you tried Tora (https://github.com/tora-tool/tora/wiki https://github.com/tora-tool/tora/wiki) or Dbeaver (Eclipse based) or Henplus (universal db shell)?
- bitmapbrother 9y agoJetBrains DataGrip is pretty good. It's not free, though. https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/
- thorin 9y agoPL/SQL Developer is excellent but you do have to pay for it. It's not expensive though, much cheaper than TOAD!
- technofire 9y agoYes, it's called SQL*Plus. Take the time to learn it!
- darklajid 9y agoCurrently extracting the 16819 files in the archive.. ;-) That said, the screenshots look decent and I've been looking for an alternative to the SQL Server Management Studio a couple times already. So I already applaud the effort.
- partycoder 9y agoDataGrip from Jetbrains is good for SQL stuff.
- halfnibble 9y agoWhere was this last month when I was at a Microsoft Hackathon with my Macbook Pro trying to browser MS SQL hosted on Azure?
- arj 9y agoThis is actually quite decent for a first version. I can see that it has git integrated. What workflows do people use to combine git and sql?
- anon335dtzbvc 9y agoBe aware of the non free license
- scrollaway 9y agoOh please please please postgres support! The only free+open source option for Linux is Sqlectron (https://github.com/sqlectron/sqlectron-gui https://github.com/sqlectron/sqlectron-gui) which has massive performance issues. I badly want an alternative to DataGrip. It's great, but it's not free and its open source license criteria are frankly ridiculous [https://www.jetbrains.com/buy/opensource/?product=datagrip https://www.jetbrains.com/buy/opensource/?product=datagrip]: >> Your OS project may not offer paid sponsorship; receive funding from commercial companies or organizations (NGO, education, research, or governmental). You do not provide any paid support, consulting or training services for your OS project, and you do not distribute paid versions of your OS software. Contributors who are paid to work on the project are not eligible.
- mnx 9y agoWell, basically they only want to give it away for free, if you actually cannot pay for it. That seems reasonable. But I agree, an OS alternative would be great, and this seems like it could be it.
- scrollaway 9y agoYeah, I understand the logic behind the licensing. However, under the guise of promoting open source, what this actually does is it promotes giving your work away for free and discourages making money with open source products. As a huge proponent of open source myself, I have no problem with projects that are open source and make money; anything that isn't "hobbyist level" should be able to make money, and if you want to make money your mindset shouldn't fall back on going closed source. Huge shout out to Sentry in that matter: They are open source, and if you're open source they service you for free. https://sentry.io/for/open-source/ https://sentry.io/for/open-source/ -- Comparatively, DataGrip is closed source, and they only give you a free license if you can't make money. Very different mindset...
- mnx 9y agoI get your point, but also... You are complaining that they are not willing to give their work away, unless you are willing to give your work away.
- userbinator 9y agoIn 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/platform/telemetry 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"...
- icc97 9y agoLooks like it's opt-in [0] [0]: https://github.com/Microsoft/sqlopsstudio/blob/6e05dd7fa13d2e5b7260314609e69093cc2142f2/src/vs/platform/telemetry/common/telemetryService.ts#L146 https://github.com/Microsoft/sqlopsstudio/blob/6e05dd7fa13d2...
- ConfucianNardin 9y agoThat looks like opt-out (it's named "telemetry.enableTelemetry" and has "'default': true").
- mulltiq 9y agoIt's same as VSCode, I believe. So yes, you need to go to settings and set "telemetry.enableTelemetry" and "telemetry.enableCrashReporter" into false to opt-out.
- mirimir 9y agoMicrosoft spying is such a trope. So why do they just keep piling it deeper? Do they think that their users are stupid?
- rexpan 9y agoSet "telemetry.enableTelemetry": false In Preference > Settings
- nbevans 9y agoThis 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.
- timlin 9y agoIf that's true, it'll be years before 1.0. There are many admin screens that this new tool will have to replicate.