Tips and Tricks for Using SQL Server Management Studio Effectively
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
Discover essential tips and tricks for maximizing productivity with SQL Server Management Studio (SSMS) in this informative conference talk from PASS Data Community Summit. Learn about advanced features such as object explorer details, script generation, regular expressions, and query plan analysis. Explore time-saving techniques including quick find, custom themes, multilevel undo, and code snippets. Master efficient connection management, multi-server queries, and user impersonation. Enhance your SSMS skills and streamline your SQL Server development and administration workflows in just 57 minutes.
Syllabus
Introduction
Introduction to Greg
Introduction to Management Studio
Management Studio Versions
Object Explorer
Object Explorer Details
Generating Scripts
Regular Expressions
Go
Help
Refresh Local Cache
Map Mode
Query Plans
Quick Find
Tools Options
Dark Themes
Undo
Multilevel Undo
Paste Control V
Snippets
Query Results
Connections
Groups
MultiServer Results
Run as a Different User
Summary
Taught by
PASS Data Community Summit
Related Courses
Economic Issues, Food & YouUniversity of Florida via Coursera Get Organized: How to be a Together Teacher
Relay Graduate School of Education via Coursera Work Smarter, Not Harder: Time Management for Personal & Professional Productivity
University of California, Irvine via Coursera Lean Operations العمليات الرشيقة
Rwaq (رواق) Realidad Macroeconómica Latinoamericana
Inter-American Development Bank via edX