SQL Server Management Studio (SSMS) | Full Course

Thank you so much for this content man. I really and truthfully apprciate it.

I have been working with SMSS for almost 20 years, but I didn't know some of these features. This was great! thank you Joey.

Hey this is really useful for me, thanks so much. I’ve been querying within SQL server for a few months, but wanted a bigger picture understanding. Really great info in this video.

Great Course🙂

Thanks a lot sir

Thanks, mate! This is THE MOST detailed and simply explained tutorial! I was angry that I couldn't find anything explanotary enough to understand how SQL works auntil I came across your video! hanks soooooo mcuh! I gotta shre the link with my friend. Cheers!

Thanks for the very clear and Step by step knowledge for beginners. I totally recommend this video.

How can I just run current statement?

Some notes:
1. DW = data warehouse (a different type of database schema (dimensions and fact tables) used for effective reporting and predefined querying
2. When you drag a database object from the Object Explorer to Query Window, it is in brackets [ ]. That's to allow database object names colliding wth SQL keywords such as column name SELECT etc.
3. Refresh Local Cache is useful for scenario when you create or alter a table and SQL Server Management Studio then doesn't recognize these changes in editor, so that makes it recognize them.

Thank you Joey, this course is great. really appreciate your time and dedication !

my professor didn’t even go in depth like this. Than you so much

can I get all those databases ? please share the downloading link

What does tha query : -- Check if the current user has the necessary privileges to restore a backup

-- 1. Check if the user is a member of the 'dbcreator' fixed server role
IF IS_SRVROLEMEMBER('dbcreator', CURRENT_USER) = 1
BEGIN
PRINT 'User has the necessary privileges to restore a backup.'
END
ELSE
BEGIN
-- 2. Check if the user has the 'RESTORE DATABASE' permission
IF HAS_PERMS_BY_NAME(DB_NAME(), 'DATABASE', 'RESTORE DATABASE') = 1
BEGIN
PRINT 'User has the necessary privileges to restore a backup.'
END
ELSE
BEGIN
PRINT 'User does not have the necessary privileges to restore a backup.'
END
END

amazing🤌

Neat!

Great video!
Please also make a video about Azure Data Studio (which I think is the successor to SSMS)

Thank you. I love that tip about dragging a table to column into SQL

Hi Joey, do you know if there is documentation on query statements for SSMS? like some helpsheets

Thanks so much for this, it is exactly what I was looking for. I've learned SQL through datacamp, but it was so difficult finding content to actually explain the UI and what all the buttons and tools are. I feel much more confident now, in only a couple hours of watching this and playing around accordingly.