YoVDO

Tips and Tricks for Using SQL Server Management Studio Effectively

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Productivity Courses Regular Expressions Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 Professional
PASS 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