Writing a Query with Azure Data Studio

[@marshalljackson1385]

Thanks Grant for this video! I like Azure Data Studio more than SSMS because it is a cross-platform data management tool. My Wish List: Add a Query Designer to visually see a coded query.

[@GrantFritchey]

Yeah, I'm getting into it more and more. I'm starting to use it for my PowerShell development too. My wishlist item is fully functional execution plans. The ones in there now are just not good.

[@honeylemontea]

hello there, thank you for your video! great tutorial. I'm on mac os, using mssql 2017 via docker container and Azure data studio pointing to it. how can i make adventure works work in this environment? should the db in docker or on my local machine? help much appreciated. Thanks

[@GrantFritchey]

So it's a Linux container. You just have to create a folder and move the file into it. Here's an example showing how: docs.microsoft.com/en-us/sql/linux/tutorial-restore-backup-in-sql-server-container

[@honeylemontea]

Thank you! I figured it out..

[@GrantFritchey]

Excellent. Good job @@honeylemontea. Let me know if I can help with anything else.

[@jillawar]

Thank you for the video.

[@zeroburn4843]

Hello, thanks for the video. I have a Excel list of 20.000 items and i want to use Azure Data Studio to query a database with a clause clause like : var IN ('my excel items list'). I can't create a table in the database. Is there a way to do that ?

[@GrantFritchey]

I'm sorry, I've never tried querying Excel, so I just do not know.

[@oleksandroksentiuk8280]

Very useful video

[@GrantFritchey]

Thank you!

[@lucatonnyr]

How i can create a database script ir exporta a database in azure data studio?

[@GrantFritchey]

Great question. I've written up a blog post on this topic. It will be available after 10 AM (Eastern) today here: www.scarydba.com/?p=3874

[@nhatacoustic3633]

no have Database Diagram in Azure Data Studio :(

[@Slamo28]

how do you do CTE'S in azure data studio? I keep gettin syntax errors

[@GrantFritchey]

Nothing special. They just work. What errors are you getting?

[@Slamo28]

@@GrantFritchey with cte as( select * from Employee4 ) ERROR Incorrect syntax near ')'. Disclaimer i am on a mac and downloaded azure data studio through some dashboard

[@GrantFritchey]

@@Slamo28 I copied your code. Other than changing the name of table, it worked: with cte as( select * from HumanResources.Employee AS e ) SELECT * FROM cte No errors. Are you sure you're connected to a SQL Server instance?

[@Slamo28]

@@GrantFritchey yes. I am using Azure on a MAC though. downloaded it with the instructions from kzbin.info/www/bejne/nZ3bdmqtaalrrJo this youtube vid. i wonder if that has anything to do with it.

[@GrantFritchey]

@@Slamo28 I don't have a Mac to test it for you, but I know lots of people who use it on their Macs. It should work.

[@ph3ll3r]

It is not as well thought out as SSMS which is a mature product. If you had the Database designer could have solved your navigation issues. Why didn't they consider recreating SSMS cross platform? How you rate Azure Data Studio today with SSMS and Redgate Toolbelt? SSMS lacks cross platform deficiencies could have been rectified. Although Azure Data Studio is in its infancy but it severely lacks the bells and whistles that people been accustomed to using on the Windows platform. Microsoft should have been smarter in their approach prospectively with important features such as Database Diagram, template snippets that are as functional using Control Shift M or like SQL prompt, etc. My Wish List is to bring back the deprecated features: Add Database diagram, Query Designer and Control Shift M for code snippets for a start. Grant, you made a great presentation but you constantly having to sugar coat the inadequacies of the Azure Data Studio product!

[@GrantFritchey]

Thanks for the kind words. I'm actually really happy with this tool. I don't disagree that it needs more to be a complete replacement of SSMS, but that's not what I'm using it for. It's much better than SSMS as a development tool. As for Redgate, watch this space, news to come about ADS soon.

[@ph3ll3r]

It is a niche tool that fills a certain void but opens up a bigger void of important features that were deprecated in SSMS. SSMS was a generalist tool which dealt from the macro perspective with the database diagram editor. You could create subject area perspectives easily and distribute them for the code bangers to use for navigation. They are singularly laser focused with a low level perspective of addressing the singular issue at hand (fire fighter mode). Azure Data Studio today is not intended to deal with the vertical perspective from macro to micro view and back as SSMS has traditionally. It totally lacks the ERD concepts as a functional component (tool) as a faster way to create queries and solutions. Also, taking on the maintenance and development of new databases,the coders would have an easier time to create faster results with the ERD and tools like Redgate toolbelt which are currently windows based! And as Robert Duran said "NoMas'", thanks this indulgence.