Great video. Explains the basic concepts well, so you can do your own research to dive into it deeper. For those who think he speaks too fast: Why not use Playback Speed = 0.75? 😉
6 лет назад+12
This stuff deserves a lot of views! Thanks Andrew!
I like this Video, within a short period of time you can learn a lot of things. it is very good for those who know a little bit about SQL. You are doing a great job for a new student in SQL ( DBA ) course.
Hi Andrew, just wanted to say I'm a great fan of your work. I'm educated as a teacher, and you are definitely the most pedagogical instructor on RUclips! Looking forward to the SQL videos!
What a wonderful tutorial! We use SqlServer quite heavily where I recently started working, and I felt completely lost and dependent on the DB Administrator for anything to do with users, roles, logins, schemas,; hell I didn't even understand what a database principal meant! Up until now, because after watching this tutorial, I went back to work and did a thorough investigation in our database server of all the server-level and database-level principals and the permissions granted, and I was ecstatic that I finally understood everything! Thank you so much Andrew!
Very informative and easy to follow. Nice and warm voice and good editing. I hope you will be active because your videos are very good and are helping a lot of people.
I m enjoying your SQL tutorials and like the way you explain, so why should you not teach at the greates school in the world:P:P.You are one of the best on youtube , in my opinion, and looking forward to learn more from the ones I didn't see yet.
Dear Andrew it great tutorial, allow me to thank you for your this great job, but also allow me to say that you have a British accent and speaks a little fast which is hard to understand for not native English speakers, once again thank you and you do wonderful job
Andrew is excellent at explaining things so I know it's my problem but I'm completely bamboozled by this video, and also a little bit scared of locking myself out of the server, I think I can under users and roles but schema has me completely flummoxed.
I have question that i tried to assign login i. e PRC grouo login to database and im trying to check the database.. Its checks for that time and if i re.. Check it.. It will not be checked... Can u explain me please
Funny-this strikes me as being far more complex than other matters that the presenter has treated previously and called "complex", yet he interestingly does NOT call complex here.
Hello Andrew, i followed exactly what you've done to create a new user, However i fail to login with it with the same error as in 19:50 I double checked the server authentication more and it is SQL Server and windows, the database is at the server and i'm trying to login from my computer. When i give it "sysadmin" role it connects successfully, but that also gives the user all permissions no matter what i select as deny afterwards ! can you please help me here ? it's very important
really nice tutorial! :) I'm really new to this and i have a probably stupid question, if I shut down my computer/laptop, will the sql server keep running or is it local and shuts down too?
So if my website is constantly using one of my databases and its shut down its not synchronysing anymore right? Do you know a way to get around this, or is the only option to have your computer running for 24 hours? :(
Great video. Explains the basic concepts well, so you can do your own research to dive into it deeper. For those who think he speaks too fast: Why not use Playback Speed = 0.75? 😉
This stuff deserves a lot of views! Thanks Andrew!
Your knowledge of these subjects astounds me! Thank you for sharing...
Thanks Ben!
I like this Video, within a short period of time you can learn a lot of things. it is very good for those who know a little bit about SQL. You are doing a great job for a new student in SQL ( DBA ) course.
Hi Andrew, just wanted to say I'm a great fan of your work. I'm educated as a teacher, and you are definitely the most pedagogical instructor on RUclips! Looking forward to the SQL videos!
good job
Amazing discussion with necessary details and simple explanation. Thanks Andrew!
You're very welcome, happy to hear that you found it useful and thanks for taking the time to write a comment!
What a wonderful tutorial! We use SqlServer quite heavily where I recently started working, and I felt completely lost and dependent on the DB Administrator for anything to do with users, roles, logins, schemas,; hell I didn't even understand what a database principal meant! Up until now, because after watching this tutorial, I went back to work and did a thorough investigation in our database server of all the server-level and database-level principals and the permissions granted, and I was ecstatic that I finally understood everything! Thank you so much Andrew!
Very informative, I'm learning a great deal thanks. As, a College Graduate I am always willing to learn more.
Great Video! Really helps me to understand how SQL Server works!
Thanks! Happy to hear that it helped and thanks for watching!
Thank you for sharing your knowledge. This is very helpful.
You're very welcome Jesse, thanks for watching!
Awesome! Can't say how thankful I am.
Thanks, very good and concise explanation
Thanks for watching!
Very informative and easy to follow. Nice and warm voice and good editing.
I hope you will be active because your videos are very good and are helping a lot of people.
Amazing stuff! I feel like a SysAdmin already. :) Thank you Andrew
My pleasure, glad you enjoyed it!
Thank you sir for this great video
My pleasure Ali!
When I hear you speak I always think of Harry Potter talking sql knowledge.
I m enjoying your SQL tutorials and like the way you explain, so why should you not teach at the greates school in the world:P:P.You are one of the best on youtube , in my opinion, and looking forward to learn more from the ones I didn't see yet.
Dear Andrew it great tutorial, allow me to thank you for your this great job, but also allow me to say that you have a British accent and speaks a little fast which is hard to understand for not native English speakers, once again thank you and you do wonderful job
Andrew is excellent at explaining things so I know it's my problem but I'm completely bamboozled by this video, and also a little bit scared of locking myself out of the server, I think I can under users and roles but schema has me completely flummoxed.
Great, Like your way of learning
Great video really liked it!! Thank You.
This is a great video, thanks!
I appreciate the content and the work you put in but I wish you'd talk slower. Feels a little rushed.
there's a speed button, slowpoke
You're the best. Thanks a lot man :D
Excellent 👍...... how i can prevent SQL server management studio enter or edit my database?
Great video thank you!
Thanks you so much
You're very welcome, thanks for watching!
Excellent
sir i am getting the error -2037 and connection to ODBC driver failed while using the ms access..Please suggest
THANKS SUPER VIDEO..
I have question that i tried to assign login i. e PRC grouo login to database and im trying to check the database.. Its checks for that time and if i re.. Check it.. It will not be checked... Can u explain me please
Funny-this strikes me as being far more complex than other matters that the presenter has treated previously and called "complex", yet he interestingly does NOT call complex here.
Hello Andrew, i followed exactly what you've done to create a new user, However i fail to login with it with the same error as in 19:50
I double checked the server authentication more and it is SQL Server and windows, the database is at the server and i'm trying to login from my computer.
When i give it "sysadmin" role it connects successfully, but that also gives the user all permissions no matter what i select as deny afterwards ! can you please help me here ? it's very important
Just started this playlist and got at same step, did you get any luck?
really nice tutorial! :)
I'm really new to this and i have a probably stupid question, if I shut down my computer/laptop, will the sql server keep running or is it local and shuts down too?
So if my website is constantly using one of my databases and its shut down its not synchronysing anymore right? Do you know a way to get around this, or is the only option to have your computer running for 24 hours? :(
Thanks, you helped me alot! I subbed to you, keep the videos coming :)
20:00 i checked sql/windows authentification but still cant connect to the new login i created, help pls
Change sql server to sql server authentication
Saved my ass! Thanks :)
Very good video but you speak too fast.
Lol I think he speaks way too slow. I am listening at 2 times speed and still think it's slow
@@greencoder7419 good joke :)
Hi sir, can you tell me sql 2012 server sa default password???
Sorry I don't know!
great video but you speak to fast mr
Why are you talking too fast? To teach something you need to be slow and steady
I think he have British accent
He's not speaking too fast. And he doesn't need you to tell him how to teach- he's quite good at it. Slow down the video, if you feel challenged.
@@plekkchand he surely is. And the next speed I can choose is 0.75, and at that speed Andrew sounds too slow and even annoying :(
You go speak to fast
Hi Alam, if it helps you can reduce the video speed using the controls at the bottom of the video player. Thanks for watching!