YoVDO

Manage SQL Server Farm via SSMS - Cross-Platform SQL Server Management

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses SSMS (SQL Server Management Studio) Courses Data Collection Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn how to efficiently manage and monitor multiple SQL Server instances from a single workstation in this conference talk. Explore challenges, features, and solutions for SQL Server farm management using SSMS. Discover techniques for creating SQL Server policies, deploying agent jobs, and configuring data collection. Gain insights into activity monitoring, CPU time analysis, and sample data handling. Master the art of cross-platform SQL Server management with minimal administration effort.

Syllabus

Introduction
Challenges
Features
Register Servers
Create SQL Server Policy
Agent Job Deployment
MDW
Questions Answers
One Question
Limit Users
Other Solutions
Configure Data Collection
Snapshot Report
Cache vs Non Cache
Log File
Activity Monitor
CPU Time
Sample Data
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