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
Design of Computer ProgramsStanford University via Udacity Programming Languages
University of Virginia via Udacity Data Structures and Performance
University of California, San Diego via Coursera Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera Applied Text Mining in Python
University of Michigan via Coursera