Visual Studio Code SQL Server Development Basics

[@michaelallen5766]

Unlike Microsoft's documentation, this worked for me. God Bless you

[@mahejabeenhossain9727]

Grateful for this! Was just not able to see my created database until I saw this.

[@AmitKumar-fi5yt]

Thanks it saved me from downloading extra software

[@adhominem_]

As an implementer and DBA I would say that this is useless compared to SSMS, since I need a lot of functionality SSMS provides out of the box, but for a "consumer" (Developer, third party Vendor etc) who just needs to see a structure and run some simple queries) this must be an awesome clean tool + VSC has other feature for this kind of audience. Thanks!

[@DeveloperSoapbox]

I definitely agree that functionality here is way too light for a DBA. But indeed super useful for data analysts and developers looking for a lightweight alternative.

[@romhayhamama3316]

6:54 dont mark me if im wrong but try to use ctrl+shift+r

[@ElamparithiK]

Thank you, this is what I needed!

[@randolphraymondcarmona4317]

This is perfect for Linux users

[@amitrout2293]

I am getting this error - 1. mssql: Error: Unable to connect using the connection information provided. Retry profile creation? 2. mssql: Error 2: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) I followed all the steps. Can u help me!

[@franciscotamayaoiii4596]

same error im getting. would like to use VS code to practice SQL

[@ercntreras]

I can not add a connection. I tried with localhost but did not work.

[@lilmila4533]

Hi, with the vs code extension, I can connect to a created database server from different laptops right?

[@nourahalanquary3670]

Thank you for this video.. I just want to ask you if I need to install Microsoft server, before downlowding the extention? or is it enough to downlad it only through VS code?

[@sammithdgowda5319]

unable to create profile getting Error :Unable to connect using the connection information provided. Retry profile creation? help me out....!!!

[@marshalljackson1385]

Useful feature to connect to a database using VS Code. Thanks for the video.

[@jayant6172]

hey , i don't have any db on my system actually i am a beginner to sql and sql workbench isn't installing on my system so i am going with vs code extension for practice. But i am using localhost in server name but i don' t have any db to use . What should i do???

[@DeveloperSoapbox]

Hi Jayant. What issue are you having installing on your system? If you are using Mac OSX or Linux, my suggestion would be using the docker sql server image. Without docker, I believe you can still install on ubuntu linux and other popular distributions.

[@jayant6172]

@@DeveloperSoapbox problem solved buddy I don't know how but now I have installed workbench on my windows. Thanks for replying and for the advice I will surely check some other distributions.

[@onenabeable]

Thanks... clear explanation

[@yazeedarifin6708]

incredible.. thx for your help

[@sujithkumar3388]

what shd I type in hostname if I am using xamp server (SQL server port is 3306)

[@sujithkumar3388]

i download sql also what shd i use server name

[@shanumalik94]

How to add tables in database from excel/csv files through this?

[@animatingwithu6556]

Hey I'm trying to make a login to my website so i want to connect it with a data base. Please some help

[@sauravkumar9454]

Thanks a lot for this.

[@monicam9802]

Extension:Python is installing while sql is installed what am i suppose to do please let me know

[@adjeiemmanuel8398]

so we have to install sql server on the machine before you can connect to it

[@nhathoang3260]

can you guide crud by dotnet or web ?

[@hugobritotech]

it's possible to do same with sybase sql anywhere?

[@hugobritotech]

anywhere 16

[@yingyang1370]

Hi, used 'localhost', username as 'root', correct password, but why still fail to connect the sql server? mac os was used.

[@DeveloperSoapbox]

Hi Ying Yang. Do you have a sql server database server installed on you local computer? You do need a sql server installation before using this plugin. Im not sure if you can install directly on mac os, but you may be able to using Docker.

[@yingyang1370]

@@DeveloperSoapbox Thanks for your replying. I did install the SQL Server-mysql. Just cannot connect with mssql extension. The connection can be made by a server management using the same information(server name, username.... )

[@angelaqian9025]

@@yingyang1370 hi I am also using MacOS and followed this tutorial to set up the server with Docker: dev.to/ijason/ms-sql-server-on-macos-with-docker-and-vs-code-2fpe. Just remember that the SQL password has a minimum complexity requirement: github.com/Microsoft/mssql-docker

[@kowsalyaraja9677]

Thank you so much for this video sir !! may i please know how to connect this with my c#code

[@DeveloperSoapbox]

Hi Kowsalya. If you are looking to use Visual Studio code for C#, it is actually quite easy. Simply go to the extensions search in vscode and search for c#. Select the c# extension from Microsoft and you should be all set.

[@Erik_Nivala]

@@DeveloperSoapbox He wants to know how he can connect to the SQL server using c#. Like creating a SqlConnection etc in Visual studio.

[@neonemesis8055]

@@Erik_Nivala I was here for the same question. It's been a few minutes and I can't seem to find any help too.

[@matheusglauber4261]

Very helpful, thx

[@muskansah4487]

Although I am following the exact steps, my VS code shows me connection error, how do I fix this?

[@fishermanarturo8896]

did you figure out how to fix the errors. I am also getting connection errors

[@AhMed-yx8dn]

How can i get a sql login

[@redword4330]

how to sign up to sql server?

[@mohammadrizkypratama3677]

how to know ip address or hostname of sql server?

[@lokeshreddy94]

could you tell me, how do i get ip address or hostname of sql server because already i have oracle 12c edition

[@DeveloperSoapbox]

Hi Lokesh. Is the sql server instance installed on your local machine / PC? If so, you should be able to use “localhost”, or the IP of “127.0.0.1”, instead of the IP address in the configuration. The default port for sql server is 1433. If its not on your local machine and you have access to the machine its running on, you can get it by opening a command line terminal and using “ipconfig”, for Windows, or “ifconfig” in Linux. If you dont have access to the server, the the server’s administrators should be able to provide it.

[@lokeshreddy94]

@@DeveloperSoapbox i mean that localhost is mandatory to connect mysql in visual studio code? am i said correct

[@DeveloperSoapbox]

Its not mandatory that it be localhost. If its on a different server, you may simply use that server’s IP address.

[@dannyphang9476]

@@DeveloperSoapbox i oso tried this way but it doesn't work

[@gabrieltijon4765]

i am Brazil, i like you

[@tamir812]

what is the username and password if it is just on my pc ?

[@nehoraygalanti285]

tamtam

[@pashtanasayed3974]

Thanks a lot!!!

[@kc_musiq6796]

The IP address is the one with ipv4 address in my pc?

[@DeveloperSoapbox]

Yes sir, usually its the ipv4 address.

[@kc_musiq6796]

@@DeveloperSoapbox I tried that... I dunno why it's not working.

[@kc_musiq6796]

@@DeveloperSoapbox I will say what's my scenario. I am having the sql server and workbench in the same laptop as that of Microsoft vs code. And I did whatever you said...but it's saying cannot establish a connection.

[@DeveloperSoapbox]

Ok, that makes things a bit easier. In that case, simply use “localhost” instead of your ip. Or you can also try 127.0.0.1 if that does not work.

[@kc_musiq6796]

@@DeveloperSoapbox I will try and let you know ASAP. Thanks

[@SanjeevKumar-nc4rx]

Bro what should I give the server name

[@DeveloperSoapbox]

Hi Sanjeev. It depends. But if the database is installed on your own computer, you can try using “localhost” for the server name.

[@superdahoho]

be nice if you show how to create a server. I just want to practice calling commands and stuff. I don't really need a real server

[@AhmedSamy-mw7wq]

thanks , i don't need to download sql server right !

[@DeveloperSoapbox]

Hi Ahmed. You dont need to download sql server database for the extension specifically, but you will need a database to exist to connect to once you have the extension installed. So if you already have a db server available to connect to, or have sql server installed locally then you should be good to go.

[@AhmedSamy-mw7wq]

Developer Soapbox ok , thanks

[@andrewnunnes]

Developer Soapbox I cant use sqlite3?

[@Itay12353]

thanks dude

[@DeveloperSoapbox]

Im glad you enjoyed

[@prajwalmondhe9683]

nice

[@superfreiheit1]

To small cant see

[@ezioauditore1491]

not visible at all why u didnt use zoom

[@DeveloperSoapbox]

This was one of my first videos, so there were a few things I could have done better. If you are watching from your phone then it will indeed be pretty small. But from a PC it should be legible if you adjust the screen size.

[@ezioauditore1491]

@@DeveloperSoapbox i m using pc btw.but still no visibility

[@DeveloperSoapbox]

Hi Ezlo. The last suggestion I can think of is changing the the video “quality” to 1080p. Because of the increased demand for KZbin during the covid crisis, KZbin now defaults the quality to 480p, which can indeed be pretty hard to read. You can change the quality by hovering on the video and you should see a gear icon on the bottom right. Then click that -> quality -> 1080p, and maximize the video screen as much as possible. I hope this helps.

[@ezioauditore1491]

@@DeveloperSoapbox 1080p is ok but it should be visible in default mode.u r forcing user to view in full screen mode which is not good at all...

[@DeveloperSoapbox]

Thanks for the feedback Ezlo. The change in default quality due to the extra KZbin demand is not something I planned for, but hopefully this wont be an issue in the future once they switch the default back. Ill try to also increase the font in future videos though.

[@priyanshrajmahendra8262]

mssql: the platform is not supported

[@ezioauditore1491]

not useful at all

[@DeveloperSoapbox]

What would you recommend to make it better?

[@tangsan9313]

I don't have ip address to create work for sql, plz help. Is there Any open source for doing project using theirs, to do my sql project ib my vs code

[@DeveloperSoapbox]

Hello. If you dont have access to a server, one option is to simply install sql server on your local computer. You can then use “localhost” as your ip. Sql Server Express is a free version that should work just like the full version.

[@tangsan9313]

@@DeveloperSoapbox thanks , i installed the community version of sql and now good to go

[@alineoliveira2554]

Thank You :)