Honestly, you explained well, i got to learn a lot from this video even though i had to create my database on AWS exact opposite way but your explanation of each step was really helpful.
Nice video, Question, when you stop the instance. Does the SQL data get deleted as well? If I were to restart the instances, would my data still be present in there or not? Thanks
Hello there, god bless your efforts. I have a simple enquiry as a newbie sql learner. I have installed sql management studio on my own pc, but i am still afraid to connect to the sql instance of a server machine. Is there any possible connection issues that i may face while connecting to the instance? What are the security measures that should be held and how to ensure that the server database would not be accidentally damaged when connecting to the server?
Simply connecting Management Studio to a database will not cause any harm. SELECT statements will not cause any harm. However, DELETE & UPDATE can! I would also ensure that security is enabled when connecting to a remote DB so that the traffic is encrypted. Do do this, go into the "Connection Properties" and check off "Encrypt connection"
Honestly, you explained well, i got to learn a lot from this video even though i had to create my database on AWS exact opposite way but your explanation of each step was really helpful.
Thank you Max🤩
Nice video, Question, when you stop the instance. Does the SQL data get deleted as well? If I were to restart the instances, would my data still be present in there or not? Thanks
Hello there, god bless your efforts.
I have a simple enquiry as a newbie sql learner.
I have installed sql management studio on my own pc, but i am still afraid to connect to the sql instance of a server machine.
Is there any possible connection issues that i may face while connecting to the instance? What are the security measures that should be held
and how to ensure that the server database would not be accidentally damaged when connecting to the server?
Simply connecting Management Studio to a database will not cause any harm. SELECT statements will not cause any harm. However, DELETE & UPDATE can! I would also ensure that security is enabled when connecting to a remote DB so that the traffic is encrypted. Do do this, go into the "Connection Properties" and check off "Encrypt connection"
doesn't rds cost alot in the longer run?