Powershell for SQL Server DBA

Focused View

Vishnu Gupthan Nair

9:45:21

107 View

1. Introduction

1. Introduction.mp4

03:51

2. Learning resources - Scripts and slides.html

2. Set up a lab for Learning

1. Install VMWare Player in your Workstation.mp4

04:23

2. Create Virtual Machine VM1 using VMWare Player.mp4

16:00

3. Install VMVare Tools for enhancement of the Virtual Machine features.mp4

03:03

4. Create VM2 and CENTRAL SERVER.mp4

09:59

5. Domain and Domain Controller Set Up.mp4

07:38

6. Joining the Servers to the domain LAB.mp4

11:43

7. (Optional)Set up Virtual Machine (VM1) using VMWare Workstation Pro.mp4

08:19

8. Internet connectivity Issues - VMWARE Virtual machines.mp4

02:34

3. Introducing DBATools Module

1. What is a Module.mp4

03:28

2. Modules - Demo.mp4

12:03

3. Introducing Powershell gallery Website.mp4

02:11

4. Install dbatools Module in Server (Very Very Important).mp4

05:59

5. Install SQLDBATools (For uninstallation of SQL Server).mp4

03:03

6. Install PSWindowsUpdate (For Windows Update).mp4

03:08

7. Handling Functions in powershell.mp4

06:03

4. SQL Server Installation using Powershell

1. Quick Overview on Powershell DSC.mp4

03:29

2. SQL Server Installation Overview using Powershell DSC.mp4

03:35

3. Scripts detailing - SQL Server Installation.mp4

06:56

4. DEMO - SQL Server Installation using DSC.mp4

09:03

5. Uninstall SQL Server using SQLDBATools Module.mp4

06:55

6. Install SQL Server using dbatools.mp4

13:33

7. Install SSMS using Powershell.mp4

05:38

8. Find the Product ID of SSMS - The script.mp4

01:24

9. Install SSIS, SSAS, SSRS along with SQL Server.mp4

18:16

10. Applying Service patches in SQL Server using Powershell.mp4

04:32

5. Windows update using Powershell

1. Should DBA update the WIndows .mp4

01:38

2. Update Windows Servers through Powershell.mp4

13:41

3. Verification after Windows update.mp4

03:31

6. Database Management using dbatools

1. Quick Intro to dbatools website.mp4

01:36

2. Simple database creation.mp4

04:44

3. Create new database in multiple servers.mp4

01:18

4. Create multiple databases in multiple servers.mp4

02:52

5. Create database with multiple parameters.mp4

03:46

6. Pull database level information (get-dbadbdatabase).mp4

04:58

7. Filtering the Get-dbadatabase output.mp4

01:47

8. Change database ownership.mp4

01:56

9. Change Recovery Model and DB Files growth settings.mp4

06:38

10. How to remove databases.mp4

01:05

11. Copy a database from one instance to another instance using dbatools.mp4

02:37

7. Backups and Restore using Powershell

1. Backups and Restore using dbatools.mp4

10:09

2. Advanced Restore databases using dbatools.mp4

08:54

8. User Roles Management in SQL Server using dbatools

1. Users and Logins - Introduction.mp4

00:59

2. Login creation using powershell.mp4

04:13

3. User Creation using powershell.mp4

01:46

4. Change Login properties using powershell.mp4

00:47

5. Get Login information using powershell.mp4

00:56

6. Find Logins inside Active Directory groups.mp4

01:06

7. Database Roles Management.mp4

02:06

8. Server Role Management.mp4

01:32

9. Copy Logins from one server to another.mp4

01:01

10. Remove Logins easily.mp4

02:03

9. Database Administration with Powershell

1. Collect Instance level information using powershell.mp4

07:59

2. SQL Agent Jobs Management using Powershell.mp4

16:23

3. Linked Servers Management using Powershell.mp4

08:36

4. SQL Server Error log reading using powershell.mp4

04:57

5. Fix Orphaned users in a single line.mp4

04:44

6. Execute SQL queries using Invoke-SQLcmd Command.mp4

06:59

10. SQL Server Replication Automation

1. SQL Server replication - Scenario.mp4

03:04

2. Setup a replication from CENTRALSERVER to VM1.mp4

11:20

3. Challenges with restoring a replicated database.mp4

03:03

4. Logic to automate Replication.mp4

13:17

5. Automate replication - See how script works.mp4

15:53

6. IMPORTANT Know Switch -Wildcard parameter.mp4

06:00

7. Automation script detailing.mp4

17:38

11. Dashboard creation of your SQL Server environment

1. Introduction Grafana for SQL Server Monitoring.mp4

02:51

2. Installing Grafana for SQL Server monitoring.mp4

06:06

3. Setup a grafana login in the monitoring SQL Server (centralserver).mp4

03:39

4. Set up a sample dashboard using Grafana.mp4

06:13

5. Collect Database IO Latencey from multiple servers.mp4

05:43

6. Job to schedule the IO Latency capturing on a schedule.mp4

06:28

7. Dashboard creation for IO Latency display.mp4

10:56

8. Filtering IO Latency info based on time range.mp4

07:47

9. Capture SQL Agent jobs execution monitoring.mp4

06:56

10. Capture SQL error log data to repository table.mp4

07:10

11. Database info collection.mp4

03:16

12. Capture Monitor CPU -Mem of database servers.mp4

07:45

13. Capture Last backup info details to repository table.mp4

06:18

14. Capture DBCC info details to repository table.mp4

05:54

15. Capture database growth info details to repository table.mp4

06:21

16. Capture Login info to repository table.mp4

03:07

17. Capture detailed login info to repository table.mp4

04:48

18. Capture SQL config data to repository table.mp4

02:56

19. Capture SQL Instance details capture to repository table.mp4

03:07

20. Display CPU memory in Grafana dashboard.mp4

04:59

21. Display SQL Server agent info and DB details in Grafana dashboard.mp4

03:13

22. Display Last backup details to Grafana dashboard.mp4

05:24

23. Display Error Log info to Grafana dashboard.mp4

03:22

24. Display current available memory of servers.mp4

02:50

25. Categorize dashboard with rows.mp4

03:34

26. Display Login and SQL Instance properties to dashboard.mp4

06:09

12. Daily DBA Reporting using Powershell

1. Convert to HTML formatting.mp4

11:56

2. Send mail from gmail using powershell.mp4

09:01

3. Send mails from gmail using app password (for 2 factor authenticated mail).mp4

05:44

4. Encrypt password while sending emails.mp4

03:39

5. Create Backup missing Report using Powershell.mp4

04:56

6. Create Replication Alert report.mp4

05:53

7. Database status Report.mp4

04:31

8. DBCC Reports.mp4

06:01

13. Database Migration using Powershell dbatools

1. How to migrate databases with dbatools.mp4

04:11

2. Migration - DEMO.mp4

06:58

14. Conclusion

1. Take away from this course. Summary..mp4

01:21

Description

Become a smarter DBA with powershell

What You'll Learn?

Automate SQL Server tasks using Powershell
Automate SQL Server replication, Backups, Restores, security management
Database migration using powershell
Create your own monitoring solution using powershell

Who is this for?

SQL Server DBAs with any level of experience

What You Need to Know?

No false commitments - Be a SQL Server DBA or passionate to learn SQL Server

More details

Description
Are you a SQL Server database administrator looking to enhance your skills and streamline your workflow? Look no further! Our comprehensive course, "Powershell for SQL Server DBA," is designed to empower you with the knowledge and tools necessary to become a proficient SQL Server administrator through the power of Powershell automation.
In this course, you'll embark on a transformative journey, starting with the basics of Powershell and gradually advancing to more complex topics tailored specifically for SQL Server administration. Whether you're a beginner or an experienced DBA, our course is structured to meet your needs and elevate your expertise.
Here's what you can expect to learn:
Lab Setup: Learn to build a robust lab environment using VMware Player Workstation, where you'll create virtual machines, set up servers, and establish domains.
DBATools Mastery: Explore the DBATools module available on Powershell Gallery, and discover how to install essential modules like SQL DBA Tools and PS Windows Update.
Windows Update Automation: Master the automation of Windows Server updates to ensure your systems are always up-to-date and secure.
SQL Server Installation: Dive into Powershell Desired State Configuration (DSC) for seamless SQL Server installation, including live demos on installing and patching SQL Server components.
Database Management: Learn efficient database management techniques using DBATools, including database creation, configuration, backup, restore, and more.
Security Management: Harness Powershell's capabilities to manage SQL Server user roles, permissions, and security settings effectively.
SQL Server Replication Automation: Streamline transactional replication processes using Powershell automation, saving time and effort for critical DBA tasks.
Reporting and Monitoring: Generate daily reports and build monitoring dashboards using Powershell and Grafana, ensuring real-time insights into your SQL Server environment.
Database Migration: Simplify database migration tasks using DBATools, executing migrations effortlessly with single commandlets.
Throughout the course, you'll benefit from hands-on demos, practical exercises, and real-world examples to reinforce your learning. Additionally, live doubt-clearing sessions and ongoing support from our experienced instructors will ensure you have the guidance you need every step of the way.
Join us on this transformative journey and unlock the full potential of Powershell automation in SQL Server administration. Whether you're aiming to enhance your career prospects or streamline your organization's database management processes, this course is your gateway to success.
Enroll now and become a proficient Powershell SQL Server DBA!
Who this course is for:
SQL Server DBAs with any level of experience

User Reviews

Rating

average 0

Total votes0

Focused display

Greetings, everyone! I am Vishnu Gupthan, and I am delighted to be your instructor for the upcoming course on automation using PowerShell.With a rich background in conducting internal hands-on training sessions in PowerShell for various esteemed companies, I bring a wealth of experience to this course. While my primary expertise lies in databases and the cloud, I am excited to delve into the essential components required for IT professionals to step into the world of automation.Throughout this course, we will explore PowerShell and its application in automation, equipping you with the necessary skills and knowledge to excel in this domain. I am confident that these sessions will be immensely valuable, providing you with the confidence to apply automation techniques within your organization.Join me on this fascinating journey through Powershell Courses, and let's unlock the potential of automation together. Here's to a successful and enriching learning experience for all!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.