At 7:32 there is a typo about partition types. Instead of "two kind od partitions", it should be "two kinds of partitions" :) Thanks Davide T. for letting me know :)
Still mentioning wrong meaning. You wrote "Two king od partitions". I dont think it does a matter because we understand your good explanation. Good work and keep it on!
Thank you, Adam! It's not everyday that I watch a learning video that provides easy to understand language, content, and flow. You obviously know your stuff and, bonus for everyone, you're a natural teacher who's willing to produce and share your knowledge.
Thanks a lot, Adam. Your videos are very helpful and interesting. You summarize how thing work, and then provide great demos. Well balanced and well done.
Very good video! I'm always impressed how how much information you can teach clearly in a 31 minutes video! You know well Azure, and you are a very talented teacher! Go from almost 0 knowledge on Cosmos DB to excited beginner in 31 minutes! ;-)
Thank you @Adam Marczak. It is really nice to see you are progressing with your way of explaining things. Since this video is of last year. I can tell the difference with your latest videos. Really good work! ✌️
I know right! It's been a looong way. Spent hundreds of hours perfecting presentations, agenda, structure and even signed for additional English lessons with British native so I can speak more fluently with better pronunciation :) Moving on all tutorials will only get better. Every few years when there will be major changes to the service I definitely plan to do a refresher video with all the improvements :) Thanks!
Very nicely done. Easy to understand these complex concepts. Just subscribed to this channel. Looking forward for more knowledgeable videos. Thank you!
This was amazing, I got a new job and there they used cosmos db, just wanted to know what it is and how its works, I now have a very clear picture of how they are using the cosmos db, next step is learning azure functions, will go and check if you have any material on that, otherwise some other resource :( , anyways Thank you very much for the clean tutorial.
Hello, I have a query. We need to bring oracle oltp data to cosmos db. What will be the best way as we need the data as soon as available. We wanted to use fivetran but it seems like it has not created connection to cosmos db.
At 16.25 , didn't quite get the explanation of RUs where you say 2 in 2.31 RUs is because it reads 2 records. I added a third record and my RUs is still 2.29 for Select * from c query
Hi, when I try to open my azure cosmos db emulator it shows Unable to add firewall rule settings. Please restart the Azure Cosmos Emulator with/NOFirewall Option. How to solve this issue?
@Adam, I can't install the Microsoft.Azure.Cosmos package, I got the error "There are no versions available for the package 'Microsoft.Azure.Cosmos' can you help me out here ?
@Azure 4 everyone: I have to choose between Cosmos DB sql API and gramelin API ? Do you know when to use which one? Could please provide me any link if u have stating diifrence between gramelin and sql Api
Hey Aniket. Gremlin is for graph databases, so it's not a question of API but question of business problem you are trying to solve. If you need graph database then this is for you. If you want to check what are the challenges that graph database solve check this doc docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#scenarios-that-can-use-gremlin-api
Hello, I want to create NOSQL database, one DB in singapore and one in US. Want to access both database as one without copying over. Just reference with possibility of CRUD operation. Data from singapore database shouldnt be moved out of singapore database. How should i do it ?
I just installed visual studio code. To correct CosmosClient (ctrl + .), drop down is not showing - “using MicrosoftAzure.Cosmos”. May I know which extension I need to install to get this??
I think intellisense for .NET should be out of the box. Just make sure to install the packages using provided command and then run "dotnet restore" to get the packages.
Shoudn't you avoid joins for cross-query over logical partitions? Isn't it a better idea to introduce some extra property in both container-docs and merge the two conatainers in order to query one logical partition? Great tutorials!
Partitioning and query optimization is a big topic. And in general you should avoid cross-partition queries as they consume more RUs but it's hard to design database so sometimes you might still need to do it. There is a lot of factors to consider and too many for a simple comment section to fit in. Thanks for watching :)
You can check a lot of stuff in the activity log in Azure as long as it's a platform change, not sure if deletion of containers is here but possibly. Thanks for watching! :)
Really insightful video! The change feed section caught my eye and I am curious to more about it. My question is: May the change feed facilitate input into source systems, i.e. a online website? Let's say you have a customer that has bought a product and that information is sent to a Cosmos DB that uses SQL API for document storage. Furthermore, that information is sent to a Cosmos DB that uses the Gremlin API to uncover relationships between data, i.e. the customer has bought product A and based on the data we have in Gremlin API DB, the customer might like product B. Then this information is sent back to the website and next time the customer visit the website, the recommendation for product B is there. Wow, this turned out to be quite the message!
Thanks! Change feed is great, also check out samples with event grid and signalr if you want to build real time applications. Remember that cosmos can't use multiple APIs at the same time so you would need two of them. But sounds like an interesting project and good use-case. Good luck.
Hi adam i am not script guy like you its mandatory to know this skill sets for administration perspective or commission is an enough ? looking your feedback
Depends on the role, for admin I would say you would need to learn powershell or azure cli to manage Azure environment. My advise would be powershell. This is covered also as part of Azure Admin certification paths. I also have few videos on those so feel free to check them out.
@Adam Marczak - Azure for Everyone Thank you Adam for your quick update but how to reference the environment parameter here, so that read replication can be done only in Production environment and not in any other environment, basically how to put condition . Please suggest, awaiting for your valuable reply on the same.
Unfortunately I don't provide consultancy for work efforts. This isn't an Azure question either, this is a question on how to code with PowerShell. Feel free to check some online tutorials on the subject.
Hi, I have a situation where one microservice (written in spring boot) needs to connection two different cosmos db (via SQL API). Microservice will only perform read operation collections present in both cosmos DB Is it possible ? Can you please send me some example code. Thanks in advance.
Great tks! .... what if i need to handle two or more containers from c # ?, do i need to create a connection for each container? For now I found information about how register a connection to single container in the Startup.cs Tks again.
@@AdamMarczakYT. I really apreciate it! At firts sight, I think these lines could help in this scenario: Container container = database.GetContainer(containerId); ContainerProperties containerProperties = await container.ReadContainerAsync(); Will test it... thanks!
1. You don't 'have' to. You can if it fits your scenario 2. There isn't powershell SDK for cosmos db right now but there are some examples how to use REST API from powershell (example gallery.technet.microsoft.com/scriptcenter/How-to-query-Azure-Cosmos-0a9aa517?WT.mc_id=AZ-MVP-5003556 ) but in my opinion that might be harder than using .NET :) 3. There is auto-scaling option available docs.microsoft.com/en-us/azure/cosmos-db/provision-throughput-autoscale?WT.mc_id=AZ-MVP-5003556
Can someone tell me if Cosmos DB is PaaS or SaaS? I think it is PaaS but I am confused as I have seen some articles that associate Cosmos DB with SaaS.
i have a usecase like this. My data storage capacity 150 GB. there will be 1 million transactions per day. my application is sitting on different countries. please suggest a option. is cosmos a best fit? or can i use azure sql?
Unfortunately it's not so easy to answer. Both can easily handle this amount of data and transactions, it depends on the use-cases. Cosmos DB might be good options due to multi-master geo distributed DB, but it's not the only option.
Hey Adam, Nice video once again. Thanks for sharing the knowledge do you know some good courses to learn more about Azure? Am specially interested in Data factory and databricks, some recommendation? :)
Hey. Glad to see you are coming back for more :) I personally like Azure Friday videos on official Microsoft Azure channel ua-cam.com/users/windowsazuresearch?query=data+factory
In partitions, you have an error in "There are two king od partitions" and it took me a while to get it. Consider adding a note or a comment in this section of the video.
I think this is still pain. There is also Bulk Delete using Cosmos DB SDK but I never checked what does it do in the backend (if it just deletes in loops/paralell or uses some bulk delete api).
Hi Adam, I have a use case and need your advice on that... So i need a Azure DB for storing some Large size files(ranging 1MB to 4 GB) and some meta data for those file and an API / link using which we can download the files from the DB. There is going to be a lot of reads/writes as well.
You should not store files in the database. You should store them on blob storage and only store paths to file in the database. Your API should generate expiring SAS urls to those files and send them to users for direct download.
Just to make that clear... i have to pay automatically $24 per month, when i use 400 RU? When i reach more than 400 RU, i pay more. I really dont get the payment method... When i have like 20.000 RU per day. Would i pay $1200?
It's 400 RU/s = Request Units per second not per month. That is 1,000,000,000 request units per month. Also 400 RU/s is within free tier. But yes 20000 RU/s would cost you 1200 USD.
@@AdamMarczakYT when i run the code on the example with visual studio it creates demoDB but it does not create "Mycontainername" below it and it doesnt spit out any errors
Weird. Try updating all modules to the latest version. You can also try creating container with the same partition key and name in the portal to see if it works. Maybe something odd is happening.
Great Video:) Thanks for this. and appreciate you could throw some points here. c:\labs\Program.cs(11,30): error CS0246: The type or namespace name 'Task' could not be found (are you missing a using directive or an assembly reference?) c:\labs\Program.cs(11,30): error CS0246: The type or namespace name 'Task' could not be found (are you missing a using directive or an assembly reference?)
At 7:32 there is a typo about partition types. Instead of "two kind od partitions", it should be "two kinds of partitions" :) Thanks Davide T. for letting me know :)
Still mentioning wrong meaning. You wrote "Two king od partitions". I dont think it does a matter because we understand your good explanation. Good work and keep it on!
@@stephenzx6312 during container creation, you can choose "Manual" instead of "Autoscale"
@@RohanHazara c9xcx999xx99c999c9x99c99f999x9cfcx99x9c999xfgxc99x99cg9c909c9c9
Thank you, Adam! It's not everyday that I watch a learning video that provides easy to understand language, content, and flow. You obviously know your stuff and, bonus for everyone, you're a natural teacher who's willing to produce and share your knowledge.
Awesome! Thanks for such nice feedback!
This is really good info!
Thank you Adam!
I was so confused about the terminology of containers and documents, and you made it crystal clear for me in just a slide. Thank you so much, Adam :)
Thanks Adam. Your an Azure Certified Teacher . Its very easy to understand your videos and acquiring deep knowledge. Well done bro!
Wow, thanks!
Adam you made my life so easy, I started watching your videos since last 15 days, I got impressed with the way you teach, please keep continuing.
Thanks a lot, Adam. Your videos are very helpful and interesting. You summarize how thing work, and then provide great demos. Well balanced and well done.
My pleasure!
Very good video! I'm always impressed how how much information you can teach clearly in a 31 minutes video! You know well Azure, and you are a very talented teacher! Go from almost 0 knowledge on Cosmos DB to excited beginner in 31 minutes! ;-)
Very informative and easy to understand. Hope to watch more about the usage with demos.
More are coming but pipeline of videos is long but definitely a hot topic to cover. Added to the list, thanks for the feedback!
You've been my learning source for a while now. Thanks a lot for your videos!!
Your Azure videos are great! Thank you so much!
Glad you think so!
It is always nice liearning azure with you Adam! Thank you so much!
Dzięki Adam for these insights. I totally need this for one of my projects. Great video!
Dziękuje 😁
Superb content...very crisp and to the point...helps a lot while preparing my dp-200 certification👍👍
Thanks a ton :)
Very nice explanation! Learning azure is very easy using your videos and demonstrations! Thanks bro!!
Happy to help!
Thank you @Adam Marczak. It is really nice to see you are progressing with your way of explaining things. Since this video is of last year. I can tell the difference with your latest videos. Really good work! ✌️
I know right! It's been a looong way. Spent hundreds of hours perfecting presentations, agenda, structure and even signed for additional English lessons with British native so I can speak more fluently with better pronunciation :) Moving on all tutorials will only get better. Every few years when there will be major changes to the service I definitely plan to do a refresher video with all the improvements :) Thanks!
Very nicely done. Easy to understand these complex concepts. Just subscribed to this channel. Looking forward for more knowledgeable videos. Thank you!
Awesome, thank you!
Great video. Very crisp and great explanation.
Thank you kindly!
Thank you Adam for sharing these learning videos. You are making azure journey easy for everyone.
My pleasure! Thank you so much :)
Adam you are really amazing ,
keep going thanks !
Great video to pick up Cosmos DB. Thank you Adam!
My pleasure!
Your video's are very helpful to understand content without any confusion. Thank you so much!
Happy to hear that!
Hello Adam - thanks for very nice piece of Azure knowledge !
Great walk through Adam, appreciate the content 👍
Lovely to see this well articulated video. Thanks
Extremely useful and well done material. Congrats Adam!
Very well presented. Thank you for an easy to understand information video. Just what I was looking for.
Glad it was helpful!
Very clear and useful, thank you !
Glad it was helpful!
your vids are the best azure tutorials thanks for your support
Glad you like them!
Clear and objective! Nice video!
Adam, this is was great share. Thanks Man !
Another Good Video. Thank you for sharing the knowledge.
Thanks for watching!
Very nice video for basic understanding 👍
Thanks!
great video with nice descriptions..
Thank you very much!
This was amazing, I got a new job and there they used cosmos db, just wanted to know what it is and how its works, I now have a very clear picture of how they are using the cosmos db, next step is learning azure functions, will go and check if you have any material on that, otherwise some other resource :( , anyways Thank you very much for the clean tutorial.
Perfect Session!!!!
Rock on!
Awesome Video on Cosmos DB !!!. To the point to understand cosmos DB !!!
Thank you :)
Adam, you are awesome man
Thanks so much still relevant in 2020!
Yes! Thanks! :D
Great introduction!!!
Hello, I have a query. We need to bring oracle oltp data to cosmos db. What will be the best way as we need the data as soon as available. We wanted to use fivetran but it seems like it has not created connection to cosmos db.
Great video! Hopefully MS fixes the cost issue with Cosmos, as currently it's a very expensive option.
I hope so too. I like cosmos db but and I use it in my projects but I would use it more if it would cost less.
Yes, it's certainly not cheap is it?
At 16.25 , didn't quite get the explanation of RUs where you say 2 in 2.31 RUs is because it reads 2 records. I added a third record and my RUs is still 2.29 for Select * from c query
Dziękuję bardzo za super filmiki!
Dziękuje za wizytę i komentarz :)
Hi, when I try to open my azure cosmos db emulator it shows Unable to add firewall rule settings. Please restart the Azure Cosmos Emulator with/NOFirewall Option.
How to solve this issue?
can you please explain how we will fetch ru used in a resorces group for a particular database container
@Adam, I can't install the Microsoft.Azure.Cosmos package, I got the error "There are no versions available for the package 'Microsoft.Azure.Cosmos' can you help me out here ?
Thank you, Adam!!! 😀
Great tutorial for overview
Glad it was helpful!
@Azure 4 everyone: I have to choose between Cosmos DB sql API and gramelin API ? Do you know when to use which one? Could please provide me any link if u have stating diifrence between gramelin and sql Api
Hey Aniket. Gremlin is for graph databases, so it's not a question of API but question of business problem you are trying to solve. If you need graph database then this is for you. If you want to check what are the challenges that graph database solve check this doc docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#scenarios-that-can-use-gremlin-api
All videos are excellent @Adam, where can I look for more contents, how to subscribe to your portal.
Hello, I want to create NOSQL database, one DB in singapore and one in US. Want to access both database as one without copying over. Just reference with possibility of CRUD operation. Data from singapore database shouldnt be moved out of singapore database. How should i do it ?
Fantastic Adam!
Many thanks! :)
Thank you, Adam. Very helpful
Glad it was helpful!
I just installed visual studio code. To correct CosmosClient (ctrl + .), drop down is not showing - “using MicrosoftAzure.Cosmos”. May I know which extension I need to install to get this??
I think intellisense for .NET should be out of the box. Just make sure to install the packages using provided command and then run "dotnet restore" to get the packages.
One question. Is it possible to have an azure cosmos db accessible to both a .net api and one that's node.js api?
Hi Arthur, what you ask is two different SDKs, but they use the same API underneath. So the answer is, yes you can use both .NET and nodejs.
Another great video, thanks!
Glad you enjoyed it!
Shoudn't you avoid joins for cross-query over logical partitions? Isn't it a better idea to introduce some extra property in both container-docs and merge the two conatainers in order to query one logical partition?
Great tutorials!
Partitioning and query optimization is a big topic. And in general you should avoid cross-partition queries as they consume more RUs but it's hard to design database so sometimes you might still need to do it. There is a lot of factors to consider and too many for a simple comment section to fit in. Thanks for watching :)
could you tell me how do we change from azure cosmos DB to Postgres sql db
Hi Adam..hope you're doing well. I have question. If someone deleted the data in cosmos db containers . Is it possible to verify how deleted the data.
You can check a lot of stuff in the activity log in Azure as long as it's a platform change, not sure if deletion of containers is here but possibly. Thanks for watching! :)
How to upgrade tls/ssl version in existing azure cosmos db?
Great video, thank you!
My pleasure!
Thank you for the video!
Really insightful video! The change feed section caught my eye and I am curious to more about it. My question is: May the change feed facilitate input into source systems, i.e. a online website?
Let's say you have a customer that has bought a product and that information is sent to a Cosmos DB that uses SQL API for document storage. Furthermore, that information is sent to a Cosmos DB that uses the Gremlin API to uncover relationships between data, i.e. the customer has bought product A and based on the data we have in Gremlin API DB, the customer might like product B. Then this information is sent back to the website and next time the customer visit the website, the recommendation for product B is there.
Wow, this turned out to be quite the message!
Thanks! Change feed is great, also check out samples with event grid and signalr if you want to build real time applications. Remember that cosmos can't use multiple APIs at the same time so you would need two of them. But sounds like an interesting project and good use-case. Good luck.
Amazing Tutorial, thanks
Hi adam i am not script guy like you its mandatory to know this skill sets for administration perspective or commission is an enough ?
looking your feedback
Depends on the role, for admin I would say you would need to learn powershell or azure cli to manage Azure environment. My advise would be powershell. This is covered also as part of Azure Admin certification paths. I also have few videos on those so feel free to check them out.
@@AdamMarczakYT Thank you for valuable reply
@Adam Marczak - Azure for Everyone Thank you Adam for your quick update but how to reference the environment parameter here, so that read replication can be done only in Production environment and not in any other environment, basically how to put condition . Please suggest, awaiting for your valuable reply on the same.
Unfortunately I don't provide consultancy for work efforts. This isn't an Azure question either, this is a question on how to code with PowerShell. Feel free to check some online tutorials on the subject.
Hi Adam, Can you help how to delete the cosmos collection using Azure data factory.
Great overview
Hi,
I have a situation where one microservice (written in spring boot) needs to connection two different cosmos db (via SQL API).
Microservice will only perform read operation collections present in both cosmos DB
Is it possible ?
Can you please send me some example code.
Thanks in advance.
Hey, I'm not a java expert so I can't help you with that. Never used spring boot.
How do we do Order by with Group by in Cosmos DB?
Great tks! .... what if i need to handle two or more containers from c # ?, do i need to create a connection for each container?
For now I found information about how register a connection to single container in the Startup.cs
Tks again.
Yes, correct. You can reuse connection. Check out the samples from MS docs.microsoft.com/bs-latn-ba/azure/cosmos-db/sql-api-dotnet-v3sdk-samples
@@AdamMarczakYT. I really apreciate it!
At firts sight, I think these lines could help in this scenario:
Container container = database.GetContainer(containerId);
ContainerProperties containerProperties = await container.ReadContainerAsync();
Will test it... thanks!
Very easy and good learning place
Hello Adam ,Can the link service can connect an remoted mongoDB,which is not in Azure portal,thx
If you mean from data factory, then yes.
docs.microsoft.com/en-us/azure/data-factory/connector-mongodb?WT.mc_id=AZ-MVP-5003556
can we have a video with Mongo Db APi and show the way of partition.
I might do partitioning video for cosmos db at some point. :)
how to prevent Dev. team to change RU from the code... and it will be only managed by the interface by and sysadmin?
Check this out docs.microsoft.com/en-us/azure/cosmos-db/role-based-access-control?WT.mc_id=AZ-MVP-5003556#prevent-sdk-changes
@@AdamMarczakYT thanks alot !!!
1.Why we need to choose cosmos db instead SQL databases ...
2.If I don't know c# can we use powershrell script
3. Is scaling done automatically
1. You don't 'have' to. You can if it fits your scenario
2. There isn't powershell SDK for cosmos db right now but there are some examples how to use REST API from powershell (example gallery.technet.microsoft.com/scriptcenter/How-to-query-Azure-Cosmos-0a9aa517?WT.mc_id=AZ-MVP-5003556 ) but in my opinion that might be harder than using .NET :)
3. There is auto-scaling option available docs.microsoft.com/en-us/azure/cosmos-db/provision-throughput-autoscale?WT.mc_id=AZ-MVP-5003556
Thank you Adam, Great Job. your videos are nice . DP 200 videos if you could share that would be helpful.
Thanks, Noted!
Can we store same way in Azure Table Storage?
Can someone tell me if Cosmos DB is PaaS or SaaS?
I think it is PaaS but I am confused as I have seen some articles that associate Cosmos DB with SaaS.
It's PaaS.
@@AdamMarczakYT Thank you Adam. I have my Exam on Saturday. Any tips???
great content
Thanks!
thanks for the demo
my pleasure
Can you please provide guidance about how to copy large json files (>16 MB) to cosmos db
Is COSMOS DB the same as COSMOS ?(internal database)
Hi, I'm not what what COSMOS internal database is. Cosmos DB is Azure service which evolved from old name Document DB.
i have a usecase like this. My data storage capacity 150 GB. there will be 1 million transactions per day. my application is sitting on different countries. please suggest a option. is cosmos a best fit? or can i use azure sql?
Unfortunately it's not so easy to answer. Both can easily handle this amount of data and transactions, it depends on the use-cases. Cosmos DB might be good options due to multi-master geo distributed DB, but it's not the only option.
Hey Adam,
Nice video once again. Thanks for sharing the knowledge
do you know some good courses to learn more about Azure? Am specially interested in Data factory and databricks, some recommendation? :)
Hey. Glad to see you are coming back for more :) I personally like Azure Friday videos on official Microsoft Azure channel ua-cam.com/users/windowsazuresearch?query=data+factory
@@AdamMarczakYT thanks, i will check it ;)
Great course, Adam! Do you have any plan to do any Kubernetes course? Thanks.
Very good content!
Thanks!
In partitions, you have an error in "There are two king od partitions" and it took me a while to get it.
Consider adding a note or a comment in this section of the video.
Duh!!! Silly me, never noticed that :) Unfortunately UA-cam doesn't allow any post-upload fixes :( I'll add a sticky comment, thanks! :)
@@AdamMarczakYT Tank you for the very relevant content!
What about deleting 1,000s of documents? is there any support now for that? TTL is not always an option.
I think this is still pain. There is also Bulk Delete using Cosmos DB SDK but I never checked what does it do in the backend (if it just deletes in loops/paralell or uses some bulk delete api).
Hi Adam, I have a use case and need your advice on that...
So i need a Azure DB for storing some Large size files(ranging 1MB to 4 GB) and some meta data for those file and an API / link using which we can download the files from the DB. There is going to be a lot of reads/writes as well.
You should not store files in the database. You should store them on blob storage and only store paths to file in the database. Your API should generate expiring SAS urls to those files and send them to users for direct download.
@@AdamMarczakYT Thanks Adam this is very helpful. :)
Just to make that clear... i have to pay automatically $24 per month, when i use 400 RU?
When i reach more than 400 RU, i pay more.
I really dont get the payment method... When i have like 20.000 RU per day. Would i pay $1200?
It's 400 RU/s = Request Units per second not per month. That is 1,000,000,000 request units per month. Also 400 RU/s is within free tier. But yes 20000 RU/s would cost you 1200 USD.
Great work, thank you very much.
Glad you liked it!
May I know, az 900 exam questions if any session have. It will be helpful if you have
Check my az-900 course website and videos.
Thanks a lot for the video, it helped me a lot
Glad it helped
Great tutorial!
Thank you!
mine creates the database but it won't create the container when I run it
not sure what do you mean :(
@@AdamMarczakYT when i run the code on the example with visual studio it creates demoDB but it does not create "Mycontainername" below it and it doesnt spit out any errors
Weird. Try updating all modules to the latest version. You can also try creating container with the same partition key and name in the portal to see if it works. Maybe something odd is happening.
Great Video:) Thanks for this. and appreciate you could throw some points here.
c:\labs\Program.cs(11,30): error CS0246: The type or namespace name 'Task' could not be found (are you missing a using directive or an assembly reference?)
c:\labs\Program.cs(11,30): error CS0246: The type or namespace name 'Task' could not be found (are you missing a using directive or an assembly reference?)
This has been shown in the video around 18:20 mark.
link for the whole playlist?????
What playlist :)
This was very helpful thanks
Glad you enjoyed it!
Thanks for this insight.
My pleasure!