Automate SQL Server Installation, Monitoring, Maintenance & Migration using PowerShell, dbatools, and Grafana
Note: Course Free for limited time and limited users(500 limit) so Enroll ASAP. If not free it means you are late. Scroll Down and click Enroll Now button to get enrolled
Scroll Down and click Enroll Now Button to get enrolled into the Free Course
Apply Coupon Code: DC83824FAAD2A5CA08EA
What you’ll learn
- Build a complete multi-server lab using VMware, Windows Server, and Active Directory.
- Automate SQL Server installation, configuration, patching, and removal using PowerShell, dbatools, and DSC.
- Manage databases, backups, restores, security, logins, roles, and server administration through PowerShell automation.
- Monitor SQL Server performance using Grafana, capturing CPU, memory, IO latency, backups, error logs, and agent jobs.
- Create automated reports, alerts, and perform database migrations using PowerShell and dbatools.
Explore related topics
This course includes:
- 10 hours on-demand video
- 1 downloadable resource
- Access on mobile and TV
- Full lifetime access
- Certificate of completion
Course content
9 sections • 102 lectures • 9h 45m total length
- Introduction
- Install VMWare Player in your Workstation
- Create Virtual Machine VM1 using VMWare Player
- Install VMWare Tools for enhancement
- Create VM2 and CENTRAL SERVER
- Domain and Domain Controller Set Up
- Joining the Servers to the domain ‘LAB’
- Set up Virtual Machine (VM1) using VMWare
- Internet connectivity Issues – VMWare Virtual machine
- What is a Module?
- Modules – Demo
- Introducing Powershell gallery Website
- Install dbatools Module in Server (Important)
- Install SQLDBATools (For uninstallation purpose)
- Install PSWindowsUpdate (For Windows Update)
- Handling Functions in powershell
- Quick Overview on Powershell DSC
- SQL Server Installation Overview using Powershell DSC
- Scripts detailing – SQL Server Installation
- DEMO – SQL Server Installation using DSC
- Uninstall SQL Server using SQLDBATools Module
- Install SQL Server using dbatools
- Install SSMS using Powershell
- Find the Product ID of SSMS – The script
- Install SSIS, SSAS, SSRS along with SQL Server
- Applying Service patches in SQL Server
- Should DBA update the Windows
- Update Windows Servers through Powershell
- Verification after Windows update
- Quick Intro to dbatools website
- Simple database creation
- Create new database in multiple servers
- Create multiple databases in multiple servers
- Create database with multiple parameters
- Pull database level information (get-dbadbdatabase)
- Filtering the Get-dbadatabase output
- Change database ownership
- Change Recovery Model and DB Files growth settings
- How to remove databases
- Copy a database from one instance to another
- Backups and Restore using dbatools
- Advanced Restore databases using dbatools
- Users and Logins – Introduction
- Login creation using powershell
- User Creation using powershell
- Change Login properties using powershell
- Get Login information using powershell
- Find Logins inside Active Directory groups
- Database Roles Management
- Server Role Management
- Copy Logins from one server to another
- Remove Logins easily
- Collect Instance level information using powershell
- SQL Agent Jobs Management using Powershell
- Linked Servers Management using Powershell
- SQL Server Error log reading using powershell
- Fix Orphaned users in a single line
- Execute SQL queries using Invoke-SQLcmd Command
- SQL Server replication – Scenario
- Setup a replication from CENTRALSERVER to VM1
- Challenges with restoring a replicated database
- Logic to automate Replication
- Automate replication – See how script works
- IMPORTANT Know Switch – Wildcard parameter
- Automation script detailing”
- Introduction Grafana for SQL Server Monitoring
- Installing Grafana for SQL Server monitoring
- Setup a grafana login in the monitoring SQL Server (centralserver)
- Set up a sample dashboard using Grafana
- Collect Database IO Latency from multiple servers
- Job to schedule the IO Latency capturing on a schedule
- Dashboard creation for IO Latency display
- Filtering IO Latency info based on time range
- Capture SQL Agent jobs execution monitoring
- Capture SQL error log data to repository table
- Database info collection
- Capture Monitor CPU -Mem of database servers
- Capture Last backup info details to repository table
- Capture DBCC info details to repository table
- Capture database growth info details to repository table
- Capture Login info to repository table
- Capture detailed login info to repository table
- Capture SQL config data to repository table
- Capture SQL Instance details capture to repository table
- Display CPU memory in Grafana dashboard
- Display SQL Server agent info and DB details in Grafana dashboard
- Display Last backup details to Grafana dashboard
- Display Error Log info to Grafana dashboard
- Display current available memory of servers
- Categorize dashboard with rows
- Display Login and SQL Instance properties to dashboard
- Convert to HTML formatting
- Send mail from gmail using powershell
- Send mails from gmail using app password (for 2 factor authenticated mail)
- Encrypt password while sending emails
- Create Backup missing Report using Powershell
- Create Replication Alert report
- Database status Report
- DBCC Reports
- How to migrate databases with dbatools
- Migration – DEMO
- Take away from this course. Summary
- Basic understanding of SQL Server concepts is helpful but not mandatory
- No prior PowerShell automation experience is required
- Willingness to learn SQL Server administration and automation
- A computer or laptop capable of running virtual machines (VMware)
- Basic knowledge of Windows operating systems is recommended
Description
This comprehensive course is designed to help you become a modern SQL Server DBA by mastering PowerShell automation, dbatools, SQL Server installation, maintenance, monitoring, reporting, and migration in real-world environments.
You will start by building a complete virtual lab using VMware, setting up multiple SQL Servers, a central monitoring server, and an Active Directory domain. From there, the course gradually introduces PowerShell fundamentals, modules, and advanced automation techniques used by professional DBAs.
A major focus of this course is SQL Server automation using dbatools and PowerShell DSC. You will learn how to install, configure, patch, uninstall, and manage SQL Server completely through scripts—eliminating repetitive manual work.
The course also covers database maintenance tasks such as database creation, configuration, ownership changes, recovery models, file growth, backups, restores, security management, logins, roles, and server administration across multiple SQL instances.
In advanced sections, you will implement SQL Server monitoring using Grafana, capturing real performance metrics like CPU, memory, IO latency, backups, error logs, SQL Agent jobs, and instance details, all visualized through professional dashboards.
You will also learn automated reporting and alerting using PowerShell, including HTML reports, email notifications, backup missing reports, replication alerts, database health checks, and DBCC reports.
Finally, the course covers database migration using dbatools, helping you move databases safely and efficiently between SQL Server environments.
By the end of this course, you will have the skills to automate SQL Server administration, manage multiple servers confidently, and work like a real-world SQL Server DBA using PowerShell.
Who this course is for:
- SQL Server DBAs who want to automate daily administrative and maintenance tasks
- System and Windows Server administrators managing SQL Server environments
- IT professionals looking to learn PowerShell automation for SQL Server and servers
- Developers or support engineers who work with SQL Server and want better administration skills
- Beginners aiming to become professional SQL Server DBAs or automation engineers
Note: The course is free for a limited time and limited to 500 users. Enroll as soon as possible. If it is no longer free, it means you are late, and it has already exceeded its limits.
🚨How to Enroll into free Udemy courses
👉 https://youtu.be/bN6IfeIW-6E?feature=shared
🎫 After adding the course into Cart at Checkout page, Apply Coupon Code➛. DC83824FAAD2A5CA08EA Note:- After applying coupon, if it says ”This coupon has exceeded its maximum possible redemptions…”, then it means you’re Late, and first 500 coupons already redeemed.
