arrow_back
Introduction
1. Introduction to Powershell for SQL Server DBA
1.1 Quick Intro on Instructor
Course Resources
Learning Resources
Set up a Lab for Learning
2. Install VMWare Player in your Workstation
3. Create Virtual Machine VM1 using VMWare Player
4. Install VMVare Tools for enhancement of the Virtual Machine features
5. Create VM2 and central server
6. Domain and Domain Controller Set Up
7. Joining the Servers to the domain 'LAB'
8. (Optional)Set up Virtual Machine (VM1) using VMWare Workstation Pro
9. VMWARE Internet connectivity Issues
Introducing DBATools Module
10. Modules in Powershell
11. Introducing Powershell gallery Website
12. Install dbatools Module in Server (Very Very Important)
13. Install SQLDBATools (For uninstallation of SQL Server)
14. Install PSWindowsUpdate (For Windows Update)
15. Functions in powershell
SQL Server Installation using Powershell
16. Quick Overview on Powershell DSC
17. SQL Server Installation Overview using Powershell DSC
18. Scripts detailing - SQL Server Installation
19. DEMO - SQL Server Installation using DSC
20. Uninstall SQL Server using SQLDBATools Module
21. Install SQL Server using dbatools
22. Install SSMS using Powershell
23. Find the Product ID of SSMS - The script
24. Install SSIS, SSAS, SSRS along with SQL Server
25. Applying Service patches in SQL Server using Powershell
Windows update using Powershell
26. Should DBA update the WIndows ?
27. Update Windows Servers through Powershell
28. Verification after Windows update
Database management with dbatools
29. Quick Intro to dbatools website
30. Simple Database creation without parameters
31. Create a New database in multiple servers
32. Create Multiple Databases in Multiple Servers
33. Create Databases with parameters
34. Pull database level information (get-dbadbdatabase)
35. Filtering the Get-dbadatabase output
36. Change database ownership
37. Change Recovery Model and DB Files growth settings
38. Remove database
39. Copy database from one instance to another
Backups and Restore using Powershell
40. Backups and Restore using dbatools
41. Advanced Restore databases using dbatools
User Roles Management in SQL Server using dbatools
42. Logins Management using dbatools - Introduction
43. Logins creation using dbatools
44. User Creation using dbatools
45. Change Login properties
46. Collect Login information
47. Logins Management inside AD groups
48. DB Roles Management
49. Server Role Management
50. Copy Logins from one server to another
51. Remove Logins using dbatools
Database Administration with Powershell
52. Instance Management using dbatools
53. SQLServerAgent jobs handling using dbatools
54. LinkedServers Management
55. Errorlog Management
56. Identify and Fixing Orphaned users using powershell
57. Query a database using Invoke-sqlcmd (Optional)
SQL Server Replication Automation
58. SQL Server replication - Scenario for automation
59. Setup a replication from CENTRALSERVER to VM1
60. Challenges with restoring a replicated database
61. Logic to automate replication
62. Automate replication - See how script works
63. IMPORTANT: Know Switch -Wildcard parameter
64. Automation - Replication script detailing
Dashboard creation of your SQL Server environment
65. Introduction: Grafana for SQL Server Monitoring
66. Installing Grafana for SQL Server monitoring
67. Setup a grafana login in the monitoring SQL Server (centralserver)
68. Set up a sample dashboard using Grafana
69. Collect Database IO Latencey from multiple servers
70. IO_Latency_job_creationJob to schedule the IO Latency capturing on a schedule
71. Dashboard creation for IO Latency display
72. Filtering IO Latency info based on time range
73. Capture SQL Agent jobs execution monitoring
74. Capture SQL error log data to repository table
75. Database info collection
76. Capture Monitor CPU -Mem of database servers
77. Capture Last backup info details to repository table
78. Capture DBCC info details to repository table
79. Capture database growth info details to repository table
80. Capture Login info to repository table
81. Capture detailed login info to repository table
82. Capture SQL config data to repository table
83. Capture SQL Instance details capture to repository table
84. Display CPU memory in Grafana dashboard
85. Display SQL Server agent info and DB details in Grafana dashboard
86. Display Last backup details to Grafana dashboard
87. Display Error Log info to Grafana dashboard
88. Display current available memory of servers
89. Categorize dashboard with rows
90. Display Login and SQL Instance properties to dashboard
Daily DBA Reporting using Powershell
91. Convert-ToHTML
92. Sending mail using powershell
93. Sending Mail without encripting password
94. Sending Mail with encripting password
95. Create Backup missing Report using Powershell
96. Create Replication Alert report
97. Database status Report
98. DBCC Reports
Database Migration using Powershell dbatools
99. How to migrate databases and components with dbatools
100. Instance & Database Migration - DEMO
Conclusion
101. Congratulations on course completion
Doubt clarification classes
Doubt clarification (1 hr) session on 'Powershell for SQL Server DBAs' - May 26, 2024