Let's Build an Azure Website and SQL Database from Scratch!
ฝัง
- เผยแพร่เมื่อ 6 ก.ย. 2024
- Whoa! In this video we cover some serious ground. We're going to build a web form in Visual Studio, provision space in Azure for the web site and a SQL database, build the application back end in SQL Server Management Studio, and then publish it all to Azure and test it out. Best of all, we are going to do the whole thing for FREE!
Does this guy realize how many future websites and ideas he’s made possible because of this video. Thank you so much for showing something that my undergrad took a whole semester to teach
O god this video is one of the best videos I have seen.
Only and the one best video that is working from start to end and is not some 144p quality with bad explaining! Very helpful, thank you very much! I wasn't a believer that this will work but I am shocked and impressed.
Fantastic video. One update - Azure changed the Data Connections button to Configure. This can be confusing for users.
Having trouble locating Web App + SQL? Has it been changed to Web App + Database in the Azure Marketplace?
Awesome! Thanks a lot for showing the overall process! This is extremely useful for me, a beginner, as it let me know-before diving into learning a bunch of theory or fundamentals for languages or services or apps I don’t necessarily need-real-world examples of Azure, SQL, etc., can help me achieve. And guess what? This is exactly the types of things I want to do with websites/apps. So now I’ll go learn Azure, SQL, etc. Thanks a lot!
Thanks a lot... Very informative and worth spending 45 mins for the understanding of Azure SQL DB, web deployment, store procedures and dev of web application... Good job done
Thank you for this video, it saved me a lot of time and was exactly what I wanted for my webproject.
*EDIT* For anyone who wants to return/get output values from their stored parameter, use
SqlCommand *cmdname* = new SqlCommand("*procname*", *connectionname*);
selectdefault.CommandType = System.Data.CommandType.StoredProcedure;
instead of SqlCommand *cmdcname* = new SqlCommand("EXEC *proc* etc...
It'll save you some time.
Good video. Please remember not everyone has large screen to view your environment with such small text. I often use my iPad for training, so it would be great in future video’s if you considered people who work with these devices and enlarge the relevant text. 👍
Amazing job! Best hands-on I've seen recently!
This is the best tutorial I have seen. It helps me so much. Thank you !
Thanks mate, best tutorial ever! this is part of my college final project :)
Thanks for 47 minutes with full valuable content. This what the audience need. Great job.
The best tutorial video I've ever seen! Thank you
your honestly the goat for this video.. I'm forever grateful
thank you, it's very clear. please publish other videos :)
Wow.. what a great video! this video clear everything for me of how that Azure or AWS web VM works! Just love this video! Thanks!
Very Good , this is giving the basic understanding of the full steps of creating a web App. Keep doing !!!
Bro the best explained video for Azure love your work keep going
Thanks, that's really powerful video! There is only one thing when I tryed to repeat your steps, it was different Web.config. So it was not clear where to paste that piese of XML code with "Home.html"
Hi, did you ever figure it out? where did you past it?
same problem
Really Good Video! Appreciate the presentation and I really enjoyed it!...
I cant belive i pulled this off 3 years later
VERY USEFUL VIDEO FOR ME . THANK YOU VERY MUCH. I GIVE U 10 OUT OF 10. U ARE MY SAVIOR FOR MY PROJECT.
The database I created It is not showing in use existing database while I am creating Web APP + MySQL
Love the video, can you reproduce with current interfaces?
First tuturial video with no issue
Great video Sir !!.. really enjoyed and learned.. thank you so much !
Thank you for your help ❤
I dont get web app as an option when opening a new item in Visual studio. No search results found.
Awesome tutorial, thank you for sharing.
Thank you for this valuable tutorial.
This video is incredible. Thank you so much.
Did anyone else not find web.server on their web.config?
I didn't
Same for me
Fantastic video. Clear, easy to follow. Thanks
Fantastic job mate explaining it in great details. Cheers
Excellent Sir🙏
Great video. This is 4 years old. Is this tech still the best choice for small or medium size frontends for SQL. Or should I try to learn some other tech today? I am new in web-dev.
Wow..,just in time..,hahaha,great video..,Thank you..,
May I request you make a Node Express app and deploy it in Azure, because you explain the way I understand..,
Super awesome
This is a great video but it is in desperate need of an update as Azure has changed a lot.
Great spirit indeed-I wish things in real life applications is so. Good job :)
IM using MacOS, I can not use SSMS what should I use?
I am having the same problem. I tried installing docker and then using terminal i tried to pull url bu thte docker version doesn't support
What are all of the extensions that I would need to download on VS code to make this process convenient?
Yes, thx for this very good tutorial. One question though, if I get in to mysql via SSM, there are no problems with the login. But if I take now the connection string from azure sql in my aspx, my user is rejected. But I applyed the firewall settings you mentined in the tutorial. At the moment I'm quit helpless how to connect to azure sql. What have I done wrong? Thx for the answer. Sinserly K.
You are a true legend.
Thanks bro. Very informative and helpful.
Excellent Video, very guided ,Congratulations
Nice video...was interesting if you showed how your leptop can reaches az sqlserver server directly.
Is server published on internet (in this case where you had set up a public IP
)
Did Use a vpn(how was it implemented )
These above are importants in order to show the whole process implementation from scratch
Perfectly explained.
Great Tutorial
pricing tier show an cross mark. what can i do now?
simple and the best that i have seen
Loved the video!
Thank you for this.
hello, my new sql connection command isnt working, can you help please?
thanks a lot Knox, great video !!
This was amazing! Thanks!
Great instruction video! Thank you.
Please bring... Azure Devops CI/CD pipeline with all strategies testing performance and best practices.... It would be great ❤️🙌
Really helpful! thanks :)
Sorry, got lost first few minutes. Azure portal very different. Can this vid be updated?
Literally exactly what I was looking for! Thanks
Good Job!
This is Great !
I am getting this error after uploading django app on azure.
The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.
Can we use Visual Studio instead of using microsoft sql server management studio to manage database ?? As Visual Studio itself provides that feature.
THANKS, A TON!!!!!
You have used Azure App Services right ?
Lot of stuff!!
o.k. guys after several hours of search: it is not that simple like shown in th tutorial. One has to create a user and login via sql and use them for the connstring. Furthermore one has to make a route to the web page. Simple deleting the default page will just provide errors. If all of this is done, than finally the result like shown above is produced. But nothing the less "ITinspired" did a great job with the tutorial:)
man you are awesome thank you
Amazing!
Thanks!
You're the love of my life
Thank you so much for this tutorial.
i published it but it still says, "Your container is up and running.
Time to take the next step and deploy your code."
great video! Thanks a lot :)
This is exactly what I was looking for . Thanx
Amazing !! hope you touch the 1M subscribers mark soon :-)
Is this still doable in November 2021?
very good
You haven't explain why you used MVC form :)
Looking for answers
Dude this video should charge $
Thanks for the tut. What a ripoff - is 1 hour a day for viewing as a client or developer time?
I having problems to login to message i recive is "System.Data.sqlclient.SqlException. Cannot open server"
Can someone help me plz
Hy thanks for the video its really helpful, actually i havd a question can we develop the website after publishing or it is a good practice or not
For dynamic websites you must always make sure server connection is available otherwise site will not function. When you publish you are basically deploying a "hopefully" working version of the site. Think in terms of deploying an app in app store. You can and should make changes as you see fit but you'll have to do another publish.
@@sweetvoodoo3192 thanks 🤘 i got my answer
Awesome
Hi Great video. I followed along up until the submit button set up. that's when I realized my back end code is actually apsx.vb not C#. I've tried adding a cs controller but it seems MVC project just defaults to vb. is there an easy fix?
Hey, thank you for the question. I'm having the same issue. Did you figure find the fix?
"That old three and a half inch floppy"
What a chad
Awesome video. Not very clear so I had to rely mostly on audio. I got stuck on StoreProcedure Execution though ... Too many errors there :(
Everything worked great until I attempted to open the sql connection. Kept getting an error stating that the user failed to login. The connection stream is copied directly from Azure and UN and PW are right. Any Ideas?
I'm having the same problem! did you figure out what was causing the problem? thank you.
Remove the braces from User ID={username};Password={password} , you just need User ID=username;Password=password;
You've set up the firewall rules as explained as well right? I know I set the rules up at work and couldn't connect from home, because only my works IP was whitelisted.
When I try to publish the app I encounter this error:
Web deployment task failed. (Web Deploy experienced a connection problem with the server and had to terminate the connection. Contact your server administrator if the problem persists. Learn more at: go.microsoft.com/fwlink/?LinkId=221672#ERROR_CONNECTION_TERMINATED.)
Do you know why is this happening?
This is great but of course MS completely changed everything so I can't really follow along
Hyper-V
1:39
VM ware
microsoft's gonna cry because you use chrome instead of edge. lol.
because [f you c key] microsoft so expensive, my work place had to replace every system to opensource.
It’s a pity you didn’t think about the size of font in your demo. You focus on an area less that one third of the screen making it impossible to follow on a small laptop or iPad. Think about your audience accessibility when producing video then the quality of your work can be better appreciated 👎
Awesome! Thanks a lot for showing the overall process! This is extremely useful for me, a beginner, as it let me know-before diving into learning a bunch of theory or fundamentals for languages or services or apps I don’t necessarily need-real-world examples of Azure, SQL, etc., can help me achieve. And guess what? This is exactly the types of things I want to do with websites/apps. So now I’ll go learn Azure, SQL, etc. Thanks a lot.