The End of Azure Data Studio

Question

The End of Azure Data Studio

Viewing 9 posts - 16 through 24 (of 24 total)

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

Steve Jones - SSC Editor SSC Guru Points: 742106 More actions · Answer 1

Notebooks are available in VS Code: https://code.visualstudio.com/docs/datascience/jupyter-notebooks

You can also connect to postgresql: https://marketplace.visualstudio.com/items?itemName=ms-ossdata.vscode-postgresql

I don't know how well the experience will be for db dev, but I'll work with the mssql extension and write a bit about it.,

pietlinden SSC Guru Points: 63656 More actions · Answer 2

Is there are good "Welcome to Visual Studio Code, ADT people!" article somewhere?

(So far, I'm not a fan of VSC... who moved my cheese??!)

Doctor Who 2 SSCrazy Eights Points: 8256 More actions · Answer 3

Steve, I didn't know that VS Code can work with Jupyter Notebooks! I've watched the YouTube video you linked to. I confess that when I've used Jupyter Notebooks in ADS I would select SQL instead of Python as the language to write the database scripts. I'm disappointed that SQL isn't a language supported (apparently). I guess I'll get better at writing Python code.

Thank you for sharing that.

Rod

jmetape Right there with Babe Points: 736 More actions · Answer 4

I like Azure Data Studio - a lot. I'm not looking forward to going back to SSMS for data development / exploration. Being able to use a sql client on a mac was / is important to me. I've had limited experience with the mssql extension in VS code, I guess I'll look into it. I don't think SSMS is a "development environment" ... being able to interact with the file system (create files, etc) is awesome. THen there's the multiple cursors and the snippets. Ok, I didn't just like ADS, I love it and it has increased my productivity by 1000%. Oh well.

jmetape Right there with Babe Points: 736 More actions · Answer 5

I like Azure Data Studio - a lot. I'm not looking forward to going back to SSMS for data development / exploration. Being able to use a sql client on a mac was / is important to me. I've had limited experience with the mssql extension in VS code, I guess I'll look into it. I don't think SSMS is a "development environment" ... being able to interact with the file system (create files, etc) is awesome. THen there's the multiple cursors and the snippets. Ok, I didn't just like ADS, I love it and it has increased my productivity by 1000%. Oh well.

Aaron N. Cutshall SSCrazy Eights Points: 9114 More actions · Answer 6

Steve, you mentioned that VS Code supports notebooks, but will it support SQL as well as Python? That was the part about ADS that I so enjoyed.

LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com

pietlinden SSC Guru Points: 63656 More actions · Answer 7

Steve,

Could you set up a project in VS Code and make it work like Azure Data Tools? Oh, and post a link to it here. (maybe post it on GitHub) That would be awesome. =)

Pieter

edmil SSC Veteran Points: 252 More actions · Answer 8

I use JetBrains DataGrip on my Mac

This reply was modified 1 years, 3 months ago by edmil.

ewm2

YSLGuru SSC-Insane Points: 21672 More actions · Answer 9

I see this as a win-win for the SQL dev Community . ADS felt to me more like MS's attempt to gently coerce users off of SSMS and to ADS.

NOTE: I'm posting this so late b/c I did not realize until today thanks to Steve (via his DB Guru blog) that ADS was being phased out. i say good riddens but all of the effort they put into it would have been better used to fix and add to SSMS the long running, tested and battle hardy IDE for T-SQL.

Newer is not always better and yet large software vendors like Microsoft act like as if Newer is better. Not everything needs reinventing every 10 years or so. updating yes but not reinviting unless there's something in the current app that is just so bad its unrealistic to leave it as is.

I know SSRS has built a fan base but its another attempt by Microsoft to, IMHO, re-invent the wheel. I wasn't against MS's trying to come up with a custom reporting tool but just with how they did it. I have been working with Crystal Reports and similar reporting tools for 30 years and MS's attempt to reinvent custom reporting from using the banded layout to a grid/matrix was more about making a custom reporting tool that was more DB friendly then one that was what was best for what customers would need. I've seen some very ice looking SSRS reports but kind of model CR and others used was superior I attribute the change to a matrix/grid method as being like non-DB's efforts t9o re0invent SQL, aka NOSQL DB's, simply because they didn't like having to think in sets and preferred an iterative way to do it instead as that's how their normal coding worked.

The best set of tools is going to consist of many aps that operate/work differently where each is best for what the goal is. For RDBMS it's set based relational thinking. For Custom Reporting is the kind of "banded" layout CR uses is best and I can personal testify that when it comes to a report that uses a pivot tale/chart, CR is FAR superior. We had to do a report in SSRS that had a dynamic # of columns and while the source SQL Query ran within a second or 2 it could take as long as 5 minutes for the report to render in SSRS.

Kindest Regards,

Just say No to Facebook!