Tips and Tricks for Using SQL Server Management Studio Effectively

Most SQL Server developers and DBAs work with SQL Server Management Studio (SSMS) all the time. But SSMS is a very capable tool and most users only know how to use a fraction of its features. Join Greg to see his favourite tips and tricks for working with SSMS.


Links to PASS and our Site:

Use our discount code VGDISM843 to save $150.00 off the full price of PASS

[giorgoschatzigrigoriou]

Thanks a lot, I was looking for the first tip how to take the columns I see with the mouse hover, but I also learned much more.

[holidasa]

Brilliant! I’ve been working SQL Server since 7.0 and the various interfaces. I’ve been working with SSMS for so long that I thought, ‘eh, pretty certain I know my way around it I’ll check it out.’ I’m open to learning something to make me more efficient.
‘F7’ was quite interesting. Didn’t know that before this. I didn’t know you could drag “Columns” to the editor or hover over * to see the columns in the SELECT list.
The clipboard ring was a new thing for me.
I spend a lot of time tuning queries and in the execution plan. I’ve known about that little + for a while. Good to show others.
Still tripping out over the ‘F7’ details.
I typically write scripts to write scripts for me. Script out the dropping or creation of constraints, or any object, for that matter, generation of c# code for a stored procedure/function. It’s a lot faster to write a T-SQL statement to do the repetitive work for me. I give it an object name and milliseconds later, I can copy and paste.

[johnceena]

I was searching many thing which you have taught here. I didn't find most of the things in the web which I found here. This video is like finding a treasure box out of nowhere.
Than You so much Sir.

[VersinKettorix]

I see a few tricks I know and use, and a few I'm going to make a point of getting into regular use. Thanks for the content.

[benain]

Thank you very much for sharing your knowledge, Sir!! Great exposition!

[rubigupta]

Thank you for sharing your Brilient knowledge with us .

[joachimritschmann]

Impressive!
Thank you, I'll subscribe to SDU immediately.

[sarveshpandey]

You really saved me from lot of worries. Thanks

[ananddeshmukh]

Thanks Sir for making such informative video, You are Very Helpful !

[jenniferhunter]

I'm a new DBA for a tiny cloud database. Extremely helpful!!!

[عليالعمامي-زذ]

Thank you very much, this helped me a lot. 🤩

[DominicFlynn]

Thanks SDU. I learned a couple of useful tips from this though I've been using SSMS for several years. Do you have tips for Data Studio?

[meazrrya]

my problem in sql is when i upload data with decimals, SQL automatically round up/down decimals. And when i divide, it automatically round up. i'm a newbie here.

[cjones]

Great video. Thanks. Even though this is a year old, I have a question. I have a folder on one drive where I wrote code, but I can't find it using explorer. How can I search for code in *.qry files? Thank you!

[mukeshchaudhari]

Thanks alot..This is great video....Thumbnail not justifying greatness of information provided in video

[pl]

Wow, very clear and useful. Thanks!!!

[KS-fzhh]

Well, it would be great to follow the instructions and everything being said there but without an existing/accessible data base the commands will remain theoretical.

[johnnynephrite]

"heeyah"? did I spell that right? what does it mean?