RETIRED - Replacement in description - Microsoft Azure Master Class Part 10 - Database

[@dikshantmalik544]

I don't actively work on Database but whenever I need to clarify something, I come back to this video as the "Masterclass" and it just gives me clarity on some concepts. Thanks for making this!

[@maneesh3212]

Your knowledge of any topic whether it is N/w, OS, Storage or database, is exceptional, marvelous !. No where you'll find such accurate knowledge. I am DB Admin since last 10+ years. but see daily I deal with but your knowledge here too so much accurate deep ... Thank you always

[@NTFAQGuy]

Glad you found it useful. Remember I’m researching for the video then presenting to just that area. I’m sure you know way more operationally than me :)

[@mohammedmohammedsaeed9547]

I am watching this video as part of my preparations for the Az- 305 exam next month, wish me good luck remembering all these information.

[@NTFAQGuy]

Best of luck!

[@tomaszłyszczyk]

This is not about DB, but I've just passed my AZ-104 and purely wanted to say thank you. Your videos were a great help and I really appreciate the huge amount of work you put into this Azure Masterclass.

[@NTFAQGuy]

Glad to help and congrats!

[@henriquealexandreh]

Super comprehensive guide to understand Azure SQL services. Thanks a million John!

[@MattKoozer]

Best part of my day was the joke at the intro :) ! Thanks John!.

[@NTFAQGuy]

Glad you enjoyed it :-)

[@angelitocruz]

Thanks John! I just finished your two latest DB courses in Pluralsight. Watching this today while working, but will watch again to focus and understand everything.

[@NTFAQGuy]

Fantastic!

[@mathichri3393]

Love the way you explain the whole thing about one subject ! thank you !

[@NTFAQGuy]

Welcome! Glad you like it!

[@erikstimpfle6931]

Amazing classes for all aspiring Azure cloud workers

[@iamdedlok]

Thanks John (again !) for the coverage on the different Database offerings on Azure. I will need to go through this once more to absorb all the different types! Good stuff!

[@NTFAQGuy]

Glad it was helpful!

[@MajerSY]

I was waiting for this one. See you guys in 2 hours.

[@NTFAQGuy]

Hope you enjoy it :)

[@MajerSY]

Thx John for making this video, it was very helpful. I could never infer just from reading documentation which SQL offering should I use, there is SQL Server, Azure Database for MySQL, SQL Managed Instance, SQL Server on Azure VM - a lof of relational database products, lengthy documentations and headache when it comes to choosing right product. After watching this i have much better idea of what is going on with all the sql offerings. Thx!

[@NTFAQGuy]

Awesome, glad it helped!

[@jeremyahagan]

That was massive. Thanks John

[@herman3311]

what a breakdown! I always had trouble seeing the relation of the different products. Thank you John! You are the best!

[@NTFAQGuy]

Happy to help

[@shettydarshan007]

Thank You John. Very useful to study for my Azure Exam.

[@NTFAQGuy]

Awesome!

[@chakraoracledba6710]

You are doing great job, John

[@NTFAQGuy]

Thank you kindly

[@alexgraham3529]

Thanks John - Needed a bit more depth on Databases for the 305 exam, good as always. I think the DP-900 might be worth a look also to get data fundamentals to help with the overall architecture as end of the day, data is king 🙂

[@JanOetting]

I like how you optimize the content for us student! Keep on the great work!

[@NTFAQGuy]

Thanks, will do!

[@EdsonNascimentoEN]

Super class - thanks for the great tutorial John.

[@omkarnadkarni4765]

Thank you so much for the extensive video on azure databases.

[@NTFAQGuy]

Glad it’s helpful

[@3uphoric]

Brilliant information, well imparted. Thank you!

[@srikanthmatsa4724]

One more great session in the Azure Master Class series. Thank you John!

[@NTFAQGuy]

Very welcome.

[@GeminiLearning]

Thanks John for all the good videos

[@NTFAQGuy]

Very welcome.

[@christianibiri]

Absolutely magnificent!!!!

[@williamedmondson3429]

This video got an upvote from me simply because of the excellent opening joke! Tech humor is the best.

[@NTFAQGuy]

Hehe, thanks.

[@AyadMawla01]

Thank you John - very useful!

[@notoriousft]

Thanks for the video. Very helpful.

[@ravibabukanaparthi4004]

Thank you John. It is Insightful and very helpful.

[@NTFAQGuy]

My pleasure.

[@lifechamp007]

Super helpful - Thank you so much John !! #StayBlessednHappy

[@NTFAQGuy]

You too!

[@karamjeetpadam4719]

awesome explanation. The best in youtube on the subject. thanks you for your hard work.

[@NTFAQGuy]

Thank you

[@dmkumar5248]

This guy is a one stop solution for Microsoft Azure. I'm sure Satya Nadella pays him for his services

[@NTFAQGuy]

It's my hobby. I don't get paid or make money from it.

[@dmkumar5248]

@@NTFAQGuy just kidding sir.. your contribution to society in terms of technical upskiling is unmatchable. I have been flowing you since your hyper-v series. Everytime I want to refresh my Azure , I listen to your ad free content.

[@NTFAQGuy]

Glad it helps.

[@patrickboucher892]

merci John. Great to watch, hard to memorize ;-)

[@NTFAQGuy]

lol, just watch it again :D Use up those KZbin 1's and 0's :-D

[@matveyrokita2673]

Came for the jokes, stayed for the DB class :D

[@julie_chen]

Thank you.🙏

[@Swd4]

Thank you for the great content as always! 🙂

[@NTFAQGuy]

My pleasure!

[@bsharma8550]

Hi John, Thank you for such knowledgeable sessions. Kindly keep spreading the love and knowledge. I have a question pertaining to azure sql database on IAAS. Can we place tempdb files on D drive(temporary disk) in IAAS?

[@NTFAQGuy]

Yes

[@ivanbravomunoz1305]

Hi John, great video a always. Regarding the Hyperscale architecture, there is one page server for each compute node or what is the ratio?

[@NTFAQGuy]

No.

[@ivanbravomunoz1305]

@@NTFAQGuy what's the proportion then?

[@NTFAQGuy]

Does not work that way. It’s not a ratio.

[@chengwang5820]

Thanks John, this is really helpful! One question in regards to Cosmos DB partitioning. The number of physical partitions scales out based on the size of the data stored (50GB per physical partition), and the RU is spread evenly. So if the size of the data reduced, for example, 500GB to 200GB, would the number of physical partitions scale in? Asking this question cause AWS DynamoDB won't reduce the number of partitions after it scaled out, wondering if Cosmos DB works the same. Thanks!

[@johnsanjay8949]

Wonderful session again, What exactly GD and BC indicates

[@NTFAQGuy]

General Purpose and Business Critical

[@darrenwest7156]

Hi John. Great vid! With VMs, it’s easy to run isolated test DR exercises. But how do you do this for the PaaS solutions like MI and Azure SQL, and put isolated instances in the same network as the VMs that need to be tested with them? Thanks

[@NTFAQGuy]

I have separate video on vnet integration with paas. Should help. Most paas you can’t force failover, it’s just part of service but follow patterns about listeners, connections etc

[@aryamousavi4850]

That ist great! Thanks!

[@NTFAQGuy]

Thanks! 🤙

[@Joe-tk8cx]

Super awesome

[@NTFAQGuy]

Thanks

[@labib8aug]

Where can I get the cool t shirt John ?

[@NTFAQGuy]

Don’t remember, sorry

[@charank7852]

Thanks for video ..

[@NTFAQGuy]

Very welcome 🤙

[@abcdef4513]

Hi John- Thx for session ,can you plz share image/pdf of all diagrams?

[@NTFAQGuy]

all in the github repo

[@jannutri]

Ahahahah… The beginning’s joke is for very db nerds… 😂