Let's Build an Azure Website and SQL Database from Scratch!
Вставка
- Опубліковано 10 вер 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
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.
O god this video is one of the best videos I have seen.
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
Fantastic video. One update - Azure changed the Data Connections button to Configure. This can be confusing for users.
your honestly the goat for this video.. I'm forever grateful
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.
This is the best tutorial I have seen. It helps me so much. Thank you !
The best tutorial video I've ever seen! Thank you
Thanks for 47 minutes with full valuable content. This what the audience need. Great job.
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. 👍
Having trouble locating Web App + SQL? Has it been changed to Web App + Database in the Azure Marketplace?
Thanks mate, best tutorial ever! this is part of my college final project :)
Amazing job! Best hands-on I've seen recently!
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!
Bro the best explained video for Azure love your work keep going
Very Good , this is giving the basic understanding of the full steps of creating a web App. Keep doing !!!
VERY USEFUL VIDEO FOR ME . THANK YOU VERY MUCH. I GIVE U 10 OUT OF 10. U ARE MY SAVIOR FOR MY PROJECT.
Really Good Video! Appreciate the presentation and I really enjoyed it!...
This video is incredible. Thank you so much.
The database I created It is not showing in use existing database while I am creating Web APP + MySQL
Fantastic video. Clear, easy to follow. Thanks
Awesome tutorial, thank you for sharing.
Thank you for this valuable tutorial.
Great video Sir !!.. really enjoyed and learned.. thank you so much !
This is a great video but it is in desperate need of an update as Azure has changed a lot.
Thank you for your help ❤
Fantastic job mate explaining it in great details. Cheers
Great spirit indeed-I wish things in real life applications is so. Good job :)
Thanks bro. Very informative and helpful.
I dont get web app as an option when opening a new item in Visual studio. No search results found.
I cant belive i pulled this off 3 years later
You are a true legend.
First tuturial video with no issue
Excellent Video, very guided ,Congratulations
What are all of the extensions that I would need to download on VS code to make this process convenient?
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
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.
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.
simple and the best that i have seen
Perfectly explained.
Literally exactly what I was looking for! Thanks
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.
Super awesome
pricing tier show an cross mark. what can i do now?
Excellent Sir🙏
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..,
Thank you for this.
Sorry, got lost first few minutes. Azure portal very different. Can this vid be updated?
Can we use Visual Studio instead of using microsoft sql server management studio to manage database ?? As Visual Studio itself provides that feature.
Great instruction video! Thank you.
Did anyone else not find web.server on their web.config?
I didn't
Same for me
hello, my new sql connection command isnt working, can you help please?
thanks a lot Knox, great video !!
i published it but it still says, "Your container is up and running.
Time to take the next step and deploy your code."
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
Great Tutorial
Love the video, can you reproduce with current interfaces?
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:)
This was amazing! Thanks!
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
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
This is Great !
THANKS, A TON!!!!!
Please bring... Azure Devops CI/CD pipeline with all strategies testing performance and best practices.... It would be great ❤️🙌
Thank you so much for this tutorial.
This is exactly what I was looking for . Thanx
Really helpful! thanks :)
Amazing!
man you are awesome thank you
You're the love of my life
You have used Azure App Services right ?
Loved the video!
Thanks!
great video! Thanks a lot :)
Lot of stuff!!
Good Job!
Is this still doable in November 2021?
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?
Amazing !! hope you touch the 1M subscribers mark soon :-)
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?
very good
Awesome
What a chad
Dude this video should charge $
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
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.
You haven't explain why you used MVC form :)
Looking for answers
"That old three and a half inch floppy"
This is great but of course MS completely changed everything so I can't really follow along
Awesome video. Not very clear so I had to rely mostly on audio. I got stuck on StoreProcedure Execution though ... Too many errors there :(
Hyper-V
VM ware
1:39
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.