Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

PASS Data Community Summit via YouTube

Overview

Limited-Time Offer: Up to 75% Off Coursera Plus!
7000+ certificate courses from Google, Microsoft, IBM, and many more.
Learn how to manage and monitor multiple SQL Server instances with minimal administration effort using SQL Server Management Studio (SSMS). The course covers topics such as registering servers, creating SQL Server policies, deploying agent jobs, and utilizing Management Data Warehouse (MDW). By the end of the course, you will be equipped with the skills to efficiently manage a SQL Server farm via SSMS. The teaching method includes a one-hour session with a focus on practical demonstrations and interactive Q&A sessions. This course is intended for individuals looking to enhance their SQL Server management skills, particularly those responsible for managing multiple SQL Server instances within an organization.

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

Reviews

Start your review of Manage SQL Server Farm via SSMS - Cross-Platform SQL Server Management

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.