Powershell for SQL Server DBA

سرفصل های دوره

Become a smarter DBA with powershell

1. Introduction

1. Introduction

2. Learning resources - Scripts and slides.html

2. Set up a lab for Learning

1. Install VMWare Player in your Workstation

2. Create Virtual Machine VM1 using VMWare Player

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

4. Create VM2 and CENTRAL SERVER

5. Domain and Domain Controller Set Up

6. Joining the Servers to the domain LAB

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

8. Internet connectivity Issues - VMWARE Virtual machines

3. Introducing DBATools Module

1. What is a Module

2. Modules - Demo

3. Introducing Powershell gallery Website

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

5. Install SQLDBATools (For uninstallation of SQL Server)

6. Install PSWindowsUpdate (For Windows Update)

7. Handling Functions in powershell

4. SQL Server Installation using Powershell

1. Quick Overview on Powershell DSC

2. SQL Server Installation Overview using Powershell DSC

3. Scripts detailing - SQL Server Installation

4. DEMO - SQL Server Installation using DSC

5. Uninstall SQL Server using SQLDBATools Module

6. Install SQL Server using dbatools

7. Install SSMS using Powershell

8. Find the Product ID of SSMS - The script

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

10. Applying Service patches in SQL Server using Powershell

5. Windows update using Powershell

1. Should DBA update the WIndows

2. Update Windows Servers through Powershell

3. Verification after Windows update

6. Database Management using dbatools

1. Quick Intro to dbatools website

2. Simple database creation

3. Create new database in multiple servers

4. Create multiple databases in multiple servers

5. Create database with multiple parameters

6. Pull database level information (get-dbadbdatabase)

7. Filtering the Get-dbadatabase output

8. Change database ownership

9. Change Recovery Model and DB Files growth settings

10. How to remove databases

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

7. Backups and Restore using Powershell

1. Backups and Restore using dbatools

2. Advanced Restore databases using dbatools

8. User Roles Management in SQL Server using dbatools

1. Users and Logins - Introduction

2. Login creation using powershell

3. User Creation using powershell

4. Change Login properties using powershell

5. Get Login information using powershell

6. Find Logins inside Active Directory groups

7. Database Roles Management

8. Server Role Management

9. Copy Logins from one server to another

10. Remove Logins easily

9. Database Administration with Powershell

1. Collect Instance level information using powershell

2. SQL Agent Jobs Management using Powershell

3. Linked Servers Management using Powershell

4. SQL Server Error log reading using powershell

5. Fix Orphaned users in a single line

6. Execute SQL queries using Invoke-SQLcmd Command

10. SQL Server Replication Automation

1. SQL Server replication - Scenario

2. Setup a replication from CENTRALSERVER to VM1

3. Challenges with restoring a replicated database

4. Logic to automate Replication

5. Automate replication - See how script works

6. IMPORTANT Know Switch -Wildcard parameter

7. Automation script detailing

11. Dashboard creation of your SQL Server environment

1. Introduction Grafana for SQL Server Monitoring

2. Installing Grafana for SQL Server monitoring

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

4. Set up a sample dashboard using Grafana

5. Collect Database IO Latencey from multiple servers

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

7. Dashboard creation for IO Latency display

8. Filtering IO Latency info based on time range

9. Capture SQL Agent jobs execution monitoring

10. Capture SQL error log data to repository table

11. Database info collection

12. Capture Monitor CPU -Mem of database servers

13. Capture Last backup info details to repository table

14. Capture DBCC info details to repository table

15. Capture database growth info details to repository table

16. Capture Login info to repository table

17. Capture detailed login info to repository table

18. Capture SQL config data to repository table

19. Capture SQL Instance details capture to repository table

20. Display CPU memory in Grafana dashboard

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

22. Display Last backup details to Grafana dashboard

23. Display Error Log info to Grafana dashboard

24. Display current available memory of servers

25. Categorize dashboard with rows

26. Display Login and SQL Instance properties to dashboard

12. Daily DBA Reporting using Powershell

1. Convert to HTML formatting

2. Send mail from gmail using powershell

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

4. Encrypt password while sending emails

5. Create Backup missing Report using Powershell

6. Create Replication Alert report

7. Database status Report

8. DBCC Reports

13. Database Migration using Powershell dbatools

1. How to migrate databases with dbatools

2. Migration - DEMO

14. Conclusion

1. Take away from this course. Summary.

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy