August 6, 2020
  • 7:26 am Cách chèn nhạc vào ảnh và video trên Facebook
  • 6:59 am Tóm Tắt The Walking Dead (Xác Sống) | Season 4
  • 6:15 am [Mất gốc Hóa – số 16] – HƯỚNG DẪN CÁCH GỌI TÊN OXIT AXIT – OXIT BAZƠ NHANH THUỘC
  • 5:49 am Cách cài Win từ ổ cứng: cả Win 7/8/8.1 và Win10 (làm mẫu với Win 10)
  • 5:12 am Thủ thuật excel: Cách khóa dữ liệu không cho chỉnh sửa trong excel



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/

admin

RELATED ARTICLES

11 COMMENTS

  1. Jennifer Hunter Posted on July 10, 2020 at 6:21 am

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

    Reply
  2. Ali Kooti Posted on July 10, 2020 at 6:21 am

    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.

    Reply
  3. Евгений Ежов Posted on July 10, 2020 at 6:21 am

    Great tricks! Thanks a lot!

    Reply
  4. Sarvesh Pandey Posted on July 10, 2020 at 6:21 am

    You really saved me from lot of worries. Thanks

    Reply
  5. Ge Yan Posted on July 10, 2020 at 6:21 am

    Very helpful tricks for someone who are familiar with Oracle and Netezza. Thank you!

    Reply
  6. Syllable Skill Posted on July 10, 2020 at 6:21 am

    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.

    Reply
  7. Anand Deshmukh Posted on July 10, 2020 at 6:21 am

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

    Reply
  8. sAI ___ Posted on July 10, 2020 at 6:21 am

    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

    Reply
  9. PL H Posted on July 10, 2020 at 6:21 am

    Wow, very clear and useful. Thanks!!!

    Reply
  10. Scott Holiday Posted on July 10, 2020 at 6:21 am

    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.

    Reply
LEAVE A COMMENT