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