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

[@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]

👍👍👍

[@CarlosSantil]

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

[@jiejenn]

Glad it was helpful!

[@RaviShankar-jm1qw]

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

[@amolpandit7865]

Was it the authentication method? It’s crazy, it worked for me in one region but fails in another

[@LordOfLiches]

Thank you for this video! I am working on building a SQL portfolio so wanted to create some databases of my own that I can query and was constantly running into errors on the deployment step. Your walkthrough helped me get everything set up exactly as I needed. :)

[@jiejenn]

Glad to hear!

[@LM_Dodge]

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

[@jiejenn]

👍👍👍

[@jancameron1175]

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

[@shashankiyengar8227]

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

[@KrustyWalker]

Excellent demo and very clear explanations

[@natnaeltsigab1275]

Simpler than I thought. I appriciate your it!

[@chromechrome4993]

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

[@mr_ironsight]

You're a lifesaver fam, great video

[@jiejenn]

Glad the video helped!

[@poeticcodingchannel]

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

[@adnangharbi8982]

You are the best, you really solved my problem thank you very much

[@jiejenn]

👍

[@shravanisharma9762]

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

[@himsaramunasinghe7422]

Thank you for the knowledge you shared

[@resaehsani4774]

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

[@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 )

[@ecuador3044]

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

[@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

[@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.

[@stevenlomon]

Thank you for this! :))

[@Alex-SotoR]

really helpful bro keep it up

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'"

[@王者三代]

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

[@kavyasriavula2393]

I’m not able to connect using ssms

[@EraLily]

great refresher thank u

[@jiejenn]

👍

[@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

[@hemantagrawal1122]

Can't we have a private token based connection string so that it is not visible to other users when i push the code on git ​@@0xredpill

[@fazalumer8431]

Thank you so much for this videos...

[@just_a_dev_023]

Thank you very much🙇🏻

[@MichaelWaki-k3s]

thanks so much for this video!

[@kamdemliberte9100]

This video was helpfull .love it

[@robbobpirate3678]

thanks man helped alot

[@chillbalu6519]

Thanks, you, Great video!!!

[@jiejenn]

👍

[@sarthakkumarpadhy4293]

in network connectivity, connectivity method is not showing

[@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. :(

[@VoodooD0g]

bro, use dark mode?

[@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 ?

[@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.

[@parthivchokshi9261]

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

[@jiejenn]

I don't see why not.

[@Gericchi-Ten]

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

[@Gericchi-Ten]

Thank you very much. Clear! @@jiejenn

[@usoppgostoso]

Ty! The interface is slightly different now, though.

[@jiejenn]

Thanks for letting me know.

[@RahulP572]

Thanks Mate

[@legooos]

Thank you!

[@jiejenn]

Thank you for watching!

[@nadeeradulan9231]

Thanks!

[@amerikanoyuncusu6579]

when is sample db fileed with data

[@benny99999997]

I was asking myself the same thing

[@ศิวศิษย์แสงนิกุล]

Thank!!! man

[@khwajanamatullahseddiqy6999]

It was good.

[@jiejenn]

👍

[@emirkaancati5218]

Thanks

[@Amlan-n1n]

Help

[@eng-alialghabban5985]

is it free

[@jiejenn]

Only if you don't exceed the free usage.

[@tellisrosanne3838]

thank you very helpful.

[@jiejenn]

Glad you found the video useful.