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
Doing More with Less - The Challenges Ahead for Every Data ProfessionalPASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube