Hello and OMG thank you. I can't believe someone is putting this much effort into high quality educational content and is so under-rated. I will absolutely smash through your channel, sir. HAve a great day and keep up the good work!
I am a MCT certified trainer and trained around the globe for Microsoft technology and honestly I took screenshots from your videos to discuss topics in my session as some time MS Official PPTs are not enough to teach students. Thanks Brother Adam..... as a Trainer I give my Salute to you for amazing explanation and most valuable is your slow pitch otherwise I seen most of people speak too fast... good luck for future
Thanks Arun. Please note that my materials are free and they should not be used for commercial paid training without attribution and copyright notice including branding logo. Thanks for stopping by!
Thank you Adam! I am an experience DBA with Oracle and other products but not setting with Azure. I know that you've saved me hours of frustration with your very clear walkthrough of the steps and considerations required. Thank you again! I am now subscribed.
This is the best channel if anyone needs to learn azure. Feels so lucky that I came to know about this channel. Thank you so much Adam and lots of love from India 😊 Your videos are very informative and helpful, easy to understand, helped a lot.
I am so impressed with Mr. Marczak's educational videos. His approach to training is so easy to comprehend, and so well-prepared to meet the needs of professionals from all walks of life.
Hey Adam, I am new to the page man. I'm so glad I found your page your explanation of SQL databases & server integration is top notch. I am new to gaining this knowledge as I've just recently gained my Azure fund/& admin certs just from a bunch of studying. However, actually working with the Azure software in real time is super valuable for my career growth. I will be subscribing asap! Thanks for what you do here it's great info!
Straight up great video! Thanks Adam!!. Would've loved to see elastic pools in action too, raises a lot of questions such as how and to what extent I can manage access across the databases in my elastic pool, how can I automate creation of databases in elastic pool etc.
Thanks, Adam for the really good videos about Azure! It helped me at the beginning of the path of learning Azure. As a result, I had passed an exam AZ-900.
@@AdamMarczakYT Hey Adam.Thanks for the simple to understand videos.It compels me to watch your videos in my free time rather than spending time on docial media😀.Do you have any videos for DP 200?
Thanks for the tutorials , Wonderful presentation.If possible can you show how to create users and setting permissions for different groups like on premises
Thanks Adam. Very useful & clear explanation & good hands-on examples. Like your style!! BTW, you can register servers in SQL Server Management Studio (SSMS) which will save server connection & login details.
Yea, I forgot to mention that. But I think they still prompt you to log in when you close SSMS when using Azure AD integrated with MFA option. But I love that It also nicely integrates with data studio recently :) Thank you :)
Good video with great content Adam! I was having some doubt reg when to use single/managed instance,elastic pools, server-less, dtu/vcore based etc before., by seeing this video, i can understand those now theoretically. Can you show 1 real scenario practically by creating databases under each of those options to differentiate between scenarios when to use which option. Viewers Request!
It actually depends on the security requirements. Some will have to be set up but a lot including encryption and firewall are set by default. Read more here: docs.microsoft.com/en-us/azure/sql-database/sql-database-security-overview
To simplify, if this is your personal account from live.com, outlook.com etc. then most likely it's guest account. You can check it by going to Azure Active Directory > Users > find your user > and if the source column (value) is other than 'Azure Active Directory' is other than Azure Active Directory then you are either guest or external user. Both of which can't be set as admin in Azure SQL. Note that you still can do it from within Azure SQL, just log in using admin username/password and grant external user db_owner role.
It's always a great pleasure to connect new technologies for see them run together. Good luck on your project, it sounds interesting! Thanks for watching!
Thank you! I learned a lot from this video! I wish I had watched this before my technical interview. Maybe I could have given a better answer to the questions thrown at me
How to manage if I want to have more people access to the database? Do I have to add them as an admin as well? Plus I do not know their ips as they are also changing. Thanks. Great video
You can easily grant regular user access to database via CREATE USER command. Check this out azure.microsoft.com/en-us/blog/adding-users-to-your-sql-azure-database/?WT.mc_id=AZ-MVP-5003556 when it comes to IPs you are out of luck. You would need to open firewall which is not recommended. So the best way is to grant users a role (or a custom role) to allow them to change firewall to grant themselves access. Or do a small automation. Thanks for tuning in.
Do you have any videos on configuring private links? For business databases in our company we don't want them to have public IP addresses, but rather only access them from within our business LAN. So, that would mean that for each connection made from within our LAN we would not have to grant access.
Hi Adam, thank you for the video. I was being able to follow thru. Here is my only constructive advice: when you picked the Active directory user, I was kind of lost since I didn't create one. At the point, if you point out to follow your AD video, that would be easier for get that setup. Your videos would help me to speed up my Azure learning again thank you Kenji
Hi Adam, I recently started following you and already love the way you explain things, clearly displays that you have deep knowledge ! I was wondering if you have made a detailed video on Azure Data Studio for if you have could you please provide the link here please, thanks :)
Awesome, thank you! Data Studio is surely interesting topic so I might cover that in future. It's still pretty new tool so there isn't that much to make a full tutorial on it. :)
Hi, long shot but would it possible for you to send your slides via Powerpoint or another application? These are great powerpoint slides and I'd love to be able to take notes on them while I watch your video.
For those Azure peeps preparing for AZ-303, here are some Tips 1. Finish the Microsoft Learn AZ-303 2. For Supplementary, Subscribe and Watch Adam Marczak Video Tutorial, he explained it very well 3. do the practice Test
Hi Adam, Thank you for the videonit is very nice!! I have a question for you how can I do an upsert using pyspark from databricks to a sql azure table ? Thank you Val !!!
I wish I had some link to good tutorial on this but I don't. But I think you could use delta lake features of databricks to do upsert and then simply replace entire table in the database with it. It's a good topic for future videos. I will add it to the list. docs.databricks.com/delta/delta-update.html#upsert-into-a-table-using-merge
Yea. You can use Azure SQL for MySQL, this demo was standard Azure SQL which is based on SQL Server. Check this out docs.microsoft.com/en-us/azure/mysql/?WT.mc_id=AZ-MVP-5003556
Thanks for the video. I am confused though about the user account switches. So in Azure Data Studio I should never use the login I made when setting up the server? Why? I also can't figure out how to add another account as an active directory admin, and I am confused as to why I have to do that. It seems to function fine when I use the initial login info. Any info would be greatly appreciated.
Hello and OMG thank you. I can't believe someone is putting this much effort into high quality educational content and is so under-rated. I will absolutely smash through your channel, sir.
HAve a great day and keep up the good work!
That is the 'comment of the week'. Thank you so much, you are too kind. :)
Thank you so much. Really very helpful, the first one video on this topic I saw seems the best. Thanks again.
Using this to study for an azure SQL position I'm interviewing for shortly.
Excellent video, thank you!
I am a MCT certified trainer and trained around the globe for Microsoft technology and honestly I took screenshots from your videos to discuss topics in my session as some time MS Official PPTs are not enough to teach students. Thanks Brother Adam..... as a Trainer I give my Salute to you for amazing explanation and most valuable is your slow pitch otherwise I seen most of people speak too fast... good luck for future
Thanks Arun. Please note that my materials are free and they should not be used for commercial paid training without attribution and copyright notice including branding logo. Thanks for stopping by!
Thank you Adam! I am an experience DBA with Oracle and other products but not setting with Azure. I know that you've saved me hours of frustration with your very clear walkthrough of the steps and considerations required. Thank you again! I am now subscribed.
Glad to help Jim! I also had my first commercial project in Oracle so I know where you are coming from :)
In the next 2 years this channel will reach 10 million subscribers. Good stuff man!
Hah! I wish :) But thanks for watching and letting me know you enjoyed it, things like this make it all worth it. See you around John.
I've actually spent weeks trying to find a good video to help me understand. Thank you so much for your videos!
Great to hear! 😀
This is the best channel if anyone needs to learn azure. Feels so lucky that I came to know about this channel.
Thank you so much Adam and lots of love from India 😊
Your videos are very informative and helpful, easy to understand, helped a lot.
Happy to help! Thank you for the kind words!
I am so impressed with Mr. Marczak's educational videos. His approach to training is so easy to comprehend, and so well-prepared to meet the needs of professionals from all walks of life.
The quality you put in and the way you explain are awesome.
I appreciate that!
Im new to Azure and I subscribed right away to your channel because your explainations are so clear and straight to the point, thank you Adam!!
Fantastic, thanks Steve :)
Amazing video for starter who learn Azure SQL. You have explained it very clearly.
Thank you Adam!
You consistently have the best data tutorials out there. Very professional, succinct, and clear. Nice work.
Thank you Dave! :)
Great material! You are very straight to the point and does not go to dead ends! Please keep teaching!
Hey Adam, I am new to the page man. I'm so glad I found your page your explanation of SQL databases & server integration is top notch. I am new to gaining this knowledge as I've just recently gained my Azure fund/& admin certs just from a bunch of studying. However, actually working with the Azure software in real time is super valuable for my career growth. I will be subscribing asap! Thanks for what you do here it's great info!
Clear and simple introduction to SQL in Azure. Thanks for your effort producing such high quality content.
My pleasure! 😁
Thanks in a million Adam. Great content second to none. "Great teachers are to find."
Such a well made video, been scratching my head over evrything when started learning Azure, your way of presentation makes it easier to learn things.
Straight up great video! Thanks Adam!!. Would've loved to see elastic pools in action too, raises a lot of questions such as how and to what extent I can manage access across the databases in my elastic pool, how can I automate creation of databases in elastic pool etc.
Very deep illustration of concept.
Thank you
Glad you liked it!
Everything works as I expected!. Thank you for your teaching
Thank you Adam. you have posted such a quality tutorial.
Glad it was helpful!
Really great video! Outstanding quality educational content! Congrats to Adam.
Much appreciated!
Very Simple and Clear Tutorial for Azure SQL Database. really appreciated
Glad it was helpful! :)
Wow.. very simplistic, yet very informative! Thanks for creating n sharing this 👏🏼
My pleasure 😊
Fantastic video. Never stop creating content. You're doing god's work
Thanks Chris for the kind words! Appreciated!
Brilliantly compiled content, easy to follow and understand. Thank you so much for sharing this knowledge Adam.
My pleasure! Thanks for stopping by :)
Very good Adam, nice explanation!
Thanks! 😃
Thank you so much for such a wonderful video. I have watched many videos but after watching yours, I realized that just wasted times watching those.
Thanks! This is so nice to hear :)
Really effective! Thanks for sharing the knowledge. 'big fan of your channel.
Much appreciated!
Hey Adam, great videos, one of the best channels, excellent production and content
love from India
Awesome, thank you!
Excelent video.
Thanks for helped me to make my first SQL in Azure
Great to hear!
Very deep knowledge, thank you, Adam
marvelous job done by you with incredible talent..i learnt alot with this 28mins video....always rocks
Amazing content Adam. "Home" to Azure learning.😉
Keep going
Thanks! 😃
Amazing content, very easy to understand, great instructor
Much appreciated!
Wonderful explanation!! Please share more related advanced exam preparation q/a videos. Thanks.
as simple and neat as it could be. Good intro to Azure SQL.
Great job...!! Excellent explanation.
Glad it was helpful!
As always, great video!
Thanks again!
Brilliant, the content is so very useful, keep it up.
Thanks, will do!
Thanks, Adam for the really good videos about Azure!
It helped me at the beginning of the path of learning Azure. As a result, I had passed an exam AZ-900.
Fantastic! Great job my friend 🙂 👊 what next goal do you have on your Azure journey?
@@AdamMarczakYT I want to pass exam DP-200.
Is it a harder exam then AZ-900?
Well definitely DP-200 because is specialized. AZ-900 is just introductionary.
@@AdamMarczakYT Hey Adam.Thanks for the simple to understand videos.It compels me to watch your videos in my free time rather than spending time on docial media😀.Do you have any videos for DP 200?
Extremely helpful - thank you as always Adam!
excellent demo ...covered all basic thing beautifully....thanks and keep posting
Thank you, I will :)
Bro your tutorial is super cool i swear
Thank you Adam. It is a wonderful video
Glad you liked it!
Hey Adam, great videos, one of the best channels, excellent production and content.
Wow, thanks! :) again!
Thanks for the tutorials , Wonderful presentation.If possible can you show how to create users and setting permissions for different groups like on premises
You should check this. It explains the process pretty nicely docs.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage
Best video till now
Great Video Adam !!!
Thanks Adam. Very useful & clear explanation & good hands-on examples. Like your style!!
BTW, you can register servers in SQL Server Management Studio (SSMS) which will save server connection & login details.
Yea, I forgot to mention that. But I think they still prompt you to log in when you close SSMS when using Azure AD integrated with MFA option. But I love that It also nicely integrates with data studio recently :) Thank you :)
@@AdamMarczakYT Your video was very helpful in my study for DP-900 Azure Data Fundamentals study. Just passed exam today. Thanks again 👍
Clear and concise, thank you Adam.
Glad you think so!
Amazing video bro, I come from AWS and I'm starting loving Azure.
Thanks and welcome aboard!
Thanks for the video! 18:24 Why should you never use SQL Server Authentication?
Appreciate your efforts,look forward to make use of it.Thank you.
more than excellent this actually helped me
Glad to hear that :)
Keep up the good content! Subscribed.
Thanks for the excellent overview bro!
Thanks for sharing, really helped a lot and wishing you all the best ~~~
Thank you! You too!
Good video with great content Adam! I was having some doubt reg when to use single/managed instance,elastic pools, server-less, dtu/vcore based etc before., by seeing this video, i can understand those now theoretically. Can you show 1 real scenario practically by creating databases under each of those options to differentiate between scenarios when to use which option. Viewers Request!
Glad it was helpful! Added your idea to the list of potential topics. Thanks!
Great video! Thanks for creating this guide!
Are these database considered secure from the outset- without having to do anything else to ensure the data is safe?
Thank you Karl :)
It actually depends on the security requirements. Some will have to be set up but a lot including encryption and firewall are set by default.
Read more here: docs.microsoft.com/en-us/azure/sql-database/sql-database-security-overview
Very Informative for beginners
Glad you think so!
it is really good and please add failover scenario as well
Good idea, I'll might do a video on that in the future ;)
Would you like to share some more detailed video of how azure sql db works, need, benefits over oracle postgres?
Precisely explained 👌
19:00 I am not understanding the part where you add an admin. Yes, my name is not highlighted to add, but how do I get another email to select?
I created user by going to Azure Active Directory > Users > Create. Guests users can't be admins.
@@AdamMarczakYT how do I know if I am a guest account?
To simplify, if this is your personal account from live.com, outlook.com etc. then most likely it's guest account. You can check it by going to Azure Active Directory > Users > find your user > and if the source column (value) is other than 'Azure Active Directory' is other than Azure Active Directory then you are either guest or external user. Both of which can't be set as admin in Azure SQL. Note that you still can do it from within Azure SQL, just log in using admin username/password and grant external user db_owner role.
Nice video well explained, I have a question, can I make a backup of an Elastic pool database from Azure data studio?
Thank you so much adam....you are amazing.....been trying to connect with my django app......finally its done....
It's always a great pleasure to connect new technologies for see them run together. Good luck on your project, it sounds interesting! Thanks for watching!
Thanks so much for making this video
No problem 😊
Adam just rekindle my hope
Thank you! I learned a lot from this video! I wish I had watched this before my technical interview. Maybe I could have given a better answer to the questions thrown at me
How to manage if I want to have more people access to the database? Do I have to add them as an admin as well? Plus I do not know their ips as they are also changing. Thanks. Great video
You can easily grant regular user access to database via CREATE USER command. Check this out azure.microsoft.com/en-us/blog/adding-users-to-your-sql-azure-database/?WT.mc_id=AZ-MVP-5003556 when it comes to IPs you are out of luck. You would need to open firewall which is not recommended. So the best way is to grant users a role (or a custom role) to allow them to change firewall to grant themselves access. Or do a small automation. Thanks for tuning in.
@@AdamMarczakYT Thanks Adam
Great explaination, thanks a lot🙏
Great video. Really clear. Thank you very much
Thanks for the awesome content. Could you please make a video on Dedicated SQL pools/SQL DW for workload management?
Great suggestion! I'll think about it, thanks for watching :)
Do you have any videos on configuring private links? For business databases in our company we don't want them to have public IP addresses, but rather only access them from within our business LAN. So, that would mean that for each connection made from within our LAN we would not have to grant access.
Unfortunately no video for private links yet :(
Hi Adam,
thank you for the video. I was being able to follow thru.
Here is my only constructive advice:
when you picked the Active directory user, I was kind of lost since I didn't create one.
At the point, if you point out to follow your AD video, that would be easier for get that setup.
Your videos would help me to speed up my Azure learning
again thank you
Kenji
21:50 My table is created but doesn't show in the UI. Also the insert command after gives permission denied. Pls help
Hi Adam, I recently started following you and already love the way you explain things, clearly displays that you have deep knowledge ! I was wondering if you have made a detailed video on Azure Data Studio for if you have could you please provide the link here please, thanks :)
Awesome, thank you! Data Studio is surely interesting topic so I might cover that in future. It's still pretty new tool so there isn't that much to make a full tutorial on it. :)
22:20 Is there a way for me to save this code if I decide to use it later?
CTRL+S :)
@@AdamMarczakYT I have saved it locally but I would like to upload it on the server. How do I do that? Do I need to create a separate folder?
You can create view from a query docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003556
Hi, long shot but would it possible for you to send your slides via Powerpoint or another application? These are great powerpoint slides and I'd love to be able to take notes on them while I watch your video.
Great vedio...! Thank you so much Adam...
Thank you! :)
Thanks alot Adam! That was really helpful.
Glad it was helpful! Thanks :)
Now I know something how to use SQL. Thanks
For those Azure peeps preparing for AZ-303, here are some Tips
1. Finish the Microsoft Learn AZ-303
2. For Supplementary, Subscribe and Watch Adam Marczak Video Tutorial, he explained it very well
3. do the practice Test
Thanks a lot for the recommendation, totally agree with this path :)
How did you set up your email for Active Directory Admin. is there any related videos for that?
It's shown in the video during the demo :)
Great video @adam .. how can i query Azure sql database with from an Azure synapse notebook?
I appreciate your work. Can you please show how to connect that database via code like Python and store data in the database?
Awesome video, I really liked it alot
Hi Adam,
Thank you for the videonit is very nice!!
I have a question for you how can I do an upsert using pyspark from databricks to a sql azure table ?
Thank you Val !!!
I wish I had some link to good tutorial on this but I don't. But I think you could use delta lake features of databricks to do upsert and then simply replace entire table in the database with it. It's a good topic for future videos. I will add it to the list.
docs.databricks.com/delta/delta-update.html#upsert-into-a-table-using-merge
Thanks sir, you make my study easy.
Many thnks
It's my pleasure
Another great video!
Thanks a bunch! :)
Hello Adam, thanks for this!
The query language seems T-SQL, but I was wondering if we can use postgre or MySQL for writing queries?
Yea. You can use Azure SQL for MySQL, this demo was standard Azure SQL which is based on SQL Server. Check this out docs.microsoft.com/en-us/azure/mysql/?WT.mc_id=AZ-MVP-5003556
@@AdamMarczakYT thanks a lot Adam!
@@AdamMarczakYT I've also sent you an email, please if possible send me a reply
I get a lot of emails, so I reply every couple of days. Please wait patiently. Thanks.
Very informative. My gratitude
Hello Adam,
Thank a lot for the content!
My pleasure!
Hello can you show Transactional replication with single, pooled, and instance databases in Azure SQL Database in the future ?
Interesting topic. Definitely worth considering, I'll add it to the list of potential topics.
@@AdamMarczakYT
Thanks ;)
Simply Awesome . Great and high skill effort. Thanks much
You are most welcome
Very much nicely presented
Thanks for the video. I am confused though about the user account switches. So in Azure Data Studio I should never use the login I made when setting up the server? Why? I also can't figure out how to add another account as an active directory admin, and I am confused as to why I have to do that. It seems to function fine when I use the initial login info. Any info would be greatly appreciated.
Amazing ... Just what I wanted
Can you do a video also for High Availability & Disaster Recover Adam?