Tips and Tricks for Using SQL Server Management Studio Effectively

11
27



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.

Greg Low is a long-term Data Platform MVP and member of the Microsoft Regional Director program. He regularly speaks at conferences and tier-1 eventsworld-wide, and is a consultant for some of the world’s more complex SQL Server environments. Greg is the author of a free SQL Server toolset called SDU Tools ( and of a number of books and whitepapers. You can find more info on Greg here:

Links to PASS and our Site:

PASS: Pass.org

DBAFundamentals:

Why to Go:

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

Registration can be completed here:

Nguồn: https://chaoticpharmacology.com/

Xem thêm bài viết khác: https://chaoticpharmacology.com/cong-nghe/

11 COMMENTS

  1. Thanks for video. I've worked almost 9 years with Oracle databases and since two month I joined to new company where MS SQL Server is being used and it was really frustrating for me at the first glance. this video is going to help me getting easier familiar with IDE of MS SQL.

  2. 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.

  3. How to add a server name at first. It's showing no server found while I am giving my system name And IP Address as well

  4. 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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here