Set Up Microsoft Azure SQL Server and SQL Database (Step-By-Step Tutorial)

In this video, I will walk you through the steps how to 1) create a SQL Server instance, 2) create a SQL database in Microsoft Azure, and 3) how to connect to the SQL database in SQL Server Management Studio.
More information on Azure Database vCore tiers: learn.microsof...
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/...
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🛒 By shopping on Amazon → amzn.to/2JkGeMD
👩‍💻 Follow me on Linked: / jiejenn
🌳 Becoming a Patreon supporter: / jiejenn
✉️ Business Inquiring: [e-mail]
#azure #azuredatabase #sqlserver #sqldatabase #azuresql

[@amandabak3566]

Thank you, I couldn't figure it out watching other videos, but yours is just perfect! I spent about and hour and a half trying to find things around

[@jiejenn]

👍👍👍

[@user-hb1yj9nb2i]

Very much simpler than expected. Thank you very much for the explanation. Very useful the end! Thanks!!

[@jiejenn]

Glad it was helpful!

[@mr_ironsight]

You're a lifesaver fam, great video

[@jiejenn]

Glad the video helped!

[@RaviShankar-jm1qw]

Helpful indeed. Your video at 1:46 solved the issue I was struggling with for an hour at least :)

[@LM_Dodge]

Very helpful, I'm in my first year of Uni and we just started this topic

[@jiejenn]

👍👍👍

[@shashankiyengar8227]

Thanks buddy, i was able to finally resolve my issue on which i was stuck for more than 3 days.

[@poeticcodingchannel]

Jie Jenn, this is an insightful video; please do one on connecting with visual studio instead of SQL server manager

[@jancameron1175]

Great video! I was able to see what I was doing incorrectly after watching this. Thank you!

[@dianeavwenaghagha1193]

thanks great video, am new to data engineering currently running a project and having issues connecting my ssms server to data factory after installing self hosted integration run time ,getting an error and someone advised i add azure data factory as a user to my azure sql database, kindly put me through

[@natnaeltsigab1275]

Simpler than I thought. I appriciate your it!

[@chromechrome4993]

Simple and to the point, keep it up @Jie !!

[@shravanisharma9762]

Thank you 🎉 it was simple and very useful love it ❤

[@fearthebite6290]

will i be able to create new databases inside ms sql in windows and will it be created and updated in azure..for example if i create a database named 123 just like you did and if I connect it in Sql management software and use old backups to add data will it be updated in azure (because i am planning to connect this to my c# windows pos application and planning to install sql management studio in all client pc and connect the server )

[@EraLily]

great refresher thank u

[@jiejenn]

👍

[@resaehsani4774]

What is the reason to connect to ssms? Will I still be able to connect to ssms if I choose Microsoft entra-authentication?

[@chillbalu6519]

Thanks, you, Great video!!!

[@jiejenn]

👍

[@user-wj2ry1bn9j]

then where to choose the DTS pricing rather than the vCore pricing ? (is there any way to lower down the pricing a bit ?)

[@ecuador3044]

Thanks...pelease, how I can do to set the versión of SQL Server create? And Is posible change the version in production?

[@user-vi4tn2qw8u]

How this apply for a connecting string in c#

[@0xredpill]

There is a connection string when you navigate to your sql database (overview) 6:12

[@tellisrosanne3838]

thank you very helpful.

[@jiejenn]

Glad you found the video useful.

[@sarthakkumarpadhy4293]

in network connectivity, connectivity method is not showing

[@stevenlomon]

Thank you for this! :))

[@fazalumer8431]

Thank you so much for this videos...

[@Alex-SotoR]

really helpful bro keep it up

[@IamWhoIamStudios]

Hi, I am getting this error message when I press create : Resource 'sqldatabasedemo' was disallowed by policy. (Code: RequestDisallowedByPolicy)

[@jiejenn]

Makes sure your account has sufficient permission to create a database.

[@user-lv2gd5tc1i]

thanks so much for this video!

[@robbobpirate3678]

thanks man helped alot

[@kamdemliberte9100]

This video was helpfull .love it

[@khwajanamatullahseddiqy6999]

It was good.

[@jiejenn]

👍

[@CforChillandCheese]

bro, i need help to connect Azure SQL server from android app. I got this error: Login failed due to client TLS version being less than minimal TLS version allowed by the server. Do you have any idea to solve it? I have been struggling half day for it. :(

[@nadeeradulan9231]

Thanks!

[@RahulP572]

Thanks Mate

[@usoppgostoso]

Ty! The interface is slightly different now, though.

[@jiejenn]

Thanks for letting me know.

[@VoodooD0g]

bro, use dark mode?

I have a datebase configured with Public endpoint and Allow Azure services and resourcers to access this server, but my pipeline keep getting access denied when running from azure devOps agents. Any idea what might be happening?

Great video though

[@jiejenn]

Almost impossible to tell you the root cause without 1) if there is an error message, and 2) looking at your setup. There can be many potential reason like firewall, VPN, endpoint configuration, etc.

[@0xredpill]

same issue with mine, when i depoly my backend it throws " at process.processTicksAndRejections (node:internal/process/task_queues:95:5) { code: 'ELOGIN'"

[@emirkaancati5218]

Thanks

[@legooos]

Thank you!

[@jiejenn]

Thank you for watching!

[@user-sy6bx9lc3l]

Thank!!! man

[@FleedX]

can the developer edition handle a 1mil record query? Why would anyone ever not pick the dev option its astronomically cheaper

[@jiejenn]

You can, but the CPU is at its minimum, so for the real world scenario, the horse power won't be enough.

[@FleedX]

@@jiejenn I think I am going to go with Azure SQL DB Serverless since I just need a data warehouse. Its going to be used in the morning by 5-10 people reading big chunks of data from it across like 4 or 5 tables max. And I will have APIs sending data to those table every morning as well.

[@hanumishra5590]

i am using AZURE free services for learning Do i need to pay for this services ?

[@jiejenn]

Only you exceed the free quota limit.

[@hanumishra5590]

@@jiejenn can you please tell me the limit ?

[@parthivchokshi9261]

Will this work for free trial period or will be charged from starting

[@jiejenn]

I don't see why not.

[@boyitian5577]

Hi Jenn, thank you for your video. Sorry, I am a beginner. There is 1 point I did not understand. I watch through the process of creating a new Azure SQL Database, I understand the creating process. However, I did not understand why there are data inside the SQL Database already. I did not see any importing/uploading of data in your video. How come suddenly you can already query information in a just created SQL Database? Could you kindly check my enquiry please? Thanks so much!

[@jiejenn]

At 02:00, noticing I'm including a sample database provided by Microsoft

[@jiejenn]

Correction: 04:31

[@boyitian5577]

Thank you very much. Clear! @@jiejenn

[@amerikanoyuncusu6579]

when is sample db fileed with data

[@benny99999997]

I was asking myself the same thing

[@Amlan-n1n]

Help

[@eng-alialghabban5985]

is it free

[@jiejenn]

Only if you don't exceed the free usage.

[@just_a_dev_023]

Thank you very much🙇🏻