PowerShell Scripting and Automation for SQL Server DBA

Focused View

Rajesh Kumar Jaiswal

35:47:58

115 View

1. Module 1

1. Introduction to Powershell.mp4

06:01

2. History and Version of PowerShell.mp4

09:42

3.1 backup.zip

3.2 backup.zip

3. PowerShell Vs CMD.mp4

30:21

4.1 Basic PowerShell Commands.txt

4. Basic PowerShell Commands.mp4

53:04

5.1 document1.txt

5.2 document2.txt

5. cmdlet Vs Function.mp4

18:31

6. PowerShell ISE.mp4

23:31

7.1 Powershell Programing-1.txt

7. PowerShell Programing-1.mp4

21:16

8.1 Powershell Programing-2.txt

8. PowerShell Programing-2.mp4

37:13

9.1 Making Automatic Mode and Start the service.txt

9.2 START SQL SERVER ALL SERVICES.txt

9.3 STOP SQL SERVER ALL SERVICES.txt

9. Stop and Start All SQL Services.mp4

11:30

10.1 7zip installation.zip

10. Installation 7ZIP software using PowerShell.mp4

28:30

11.1 For-each Loop example.txt

11.2 Server Name.txt

11. For-each loop example.mp4

09:07

12.1 res.txt

12.2 Run sql script for one server.txt

12.3 servername.txt

12. How to connect with SQL Server Using PowerShell And Run the single script.mp4

13:56

13.1 1234.txt

13.2 Allservers.txt

13.3 error details.txt

13.4 get-contet.zip

13.5 replace.txt

13.6 servers.txt

13.7 servers1.txt

13. Get-Content and Set-content.mp4

24:16

2. Module 2

1.1 check service.zip

1. ExecutionPolicy.mp4

17:17

2.1 email for office.txt

2.2 How to Send email from Powershell.txt

2.3 jobfail.html

2.4 jobfail.txt

2.5 log.txt

2.6 New Microsoft Office Word Document.docx

2.7 Secure String.txt

2.8 uid.txt

2. How to Send email from PowerShell.mp4

36:22

3.1 Format Table and Pipe.txt

3.2 Select Result.txt

3. How to use Pipe and format the result in PowerShell.mp4

21:01

3. Module 3

1.1 Operator Example.txt

1.2 process result.txt

1. Operator in PowerShell.mp4

50:15

2.1 if else lop.zip

2.2 if.zip

2.3 ifelseif.zip

2. PowerShell Loop - if , if else, ifelseif.mp4

05:08

3.1 loop.txt

3.2 Students Name.txt

3. For-each and For-Eachobject.mp4

20:57

4.1 For, Do While , Do Untill Loop.txt

4. For, Do While , Do Until Loop.mp4

15:18

5.1 switch.txt

5. Switch Loop.mp4

04:18

6.1 Templete of Ps1 file.txt

6. Template of Ps1 (PowerShell Script).mp4

19:38

4. Module 4

1.1 START OF PROGRAM - Start All sql server services.txt

1. START OF PROGRAM - Start All sql server services.mp4

26:04

2.1 V1.Start the SQL Service for Named and Default Instance.txt

2. V1.Start the SQL Service for Named and Default Instance.mp4

08:08

3.1 clusterserver.txt

3.2 Server not connected.txt

3.3 status log.txt

3. V2 Adding Log file in Programing.mp4

20:26

4.1 V3 Programing for Stoping services and Adding Log file.txt

4. V3 Programing for Stopping services and Adding Log file.mp4

13:48

5.1 V4 Programing for Starting services and Adding Log file.txt

5. V4 Programing for Starting services and Adding Log file.mp4

07:04

6.1 V5 Programing - Function creation for log file.txt

6.2 V6 Programing - Function creation for log file in code.txt

6. V5 and V6 Programing - Function creation for log file.mp4

15:34

7.1 V7. If log file is not avilable it will not give any error.txt

7. V7. If log file is not available it will not give any error.mp4

09:49

8.1 V8 Programing - Adding wrong server its througing error.txt

8. V8 Programing - Adding wrong server its throwing error.mp4

15:12

9.1 V9 Adding wrong host in and error got fixed.txt

9. V9 Adding wrong host in and error got fixed.mp4

25:08

10.1 V10 Fixed the Named Instance issue.txt

10. V10 Fixed the Named Instance issue.mp4

25:40

11.1 If Server is cluster - Script will not perform any activities.txt

11. V11 If Server is cluster - Script will not perform any activities.mp4

13:42

12.1 Server Name.txt

12.2 v12display the result in colour for starting or filed.zip

12. V12 Display the result in color for starting or filed.mp4

13:32

13.1 Server Name.txt

13.2 v13 how to make path as constant.zip

13. V13 How to make path as constant.mp4

35:49

14.1 Server Name.txt

14.2 Server not connected 20230513220926.txt

14.3 status log 20230513220926.txt

14.4 v14 programing - constant path creating log folder.zip

14. V14 Programing - Constant Path Creating Log Folder.mp4

17:23

15.1 Server Name.txt

15.2 Server not connected 20230513221032.txt

15.3 status log 20230513221032.txt

15.4 v15 programing - adding filestamp in logfile.zip

15. V15 Programing - Adding File stamp in logfile.mp4

14:48

16.1 Server Name.txt

16.2 Server not connected 20230513223409.txt

16.3 status log 20230513223409.txt

16.4 v16 adding timestamp inside the log file.zip

16. V16 Adding Timestamp inside the log file.mp4

13:24

17.1 error log stop services20230513235053.txt

17.2 Server Name.txt

17.3 Server not connected 20230513235053.txt

17.4 status log 20230513235053.txt

17.5 v17 adding transcript error.zip

17. v17 Adding Transcript Error.mp4

23:53

5. Module 5

1.1 get location new.zip

1. How to get Current Path.mp4

35:59

6. Module 6

1.1 DESKTOP-51BRP3Q.csv

1.2 DESKTOP-51BRP3Q.html

1.3 DESKTOP-51BRP3Q.txt

1.4 html servicepack list1.zip

1.5 serverlist.txt

1.6 servicepack list.zip

1. How to get all service pack Details using PowerShell.mp4

09:18

7. Module 7

1.1 multiple server and multiple result file.txt

1.2 Passs the parameter in horizontal formet.txt

1.3 Passs the parameter in Vertical formet.txt

1.4 Run sql script for one server.txt

1. Connect SQL server using PowerShell and Pass the Parameter using config file.mp4

22:34

8. Module 8

1. PowerShell with SQL Server.mp4

41:58

2.1 123.txt

2.2 how to import module and automate using powershell.zip

2. How to Import Module.mp4

40:42

3.1 Database Property for Single Server.txt

3.2 Database Property multiple server -With HTML file.txt

3.3 Database Property multiple server.txt

3.4 JOb Details.html

3. How to develop programing using SMO.mp4

36:52

4.1 serverlist.txt

4.2 SQLScript res.txt

4.3 sqlscript.zip

4. Connect SQL server using Cmdlt and run a SQL script.mp4

15:46

5.1 How to run multiple of script in single server.txt

5.2 sqlscript1.zip

5.3 sqlscript2.zip

5.4 sqlscript3.zip

5.5 sqlscript4.zip

5. How to run multiple of script in single server.mp4

16:21

6.1 ZIP and UnZip.docx

6. How to Zip and Unzip using PowerShell.mp4

09:09

9. Module 9

1.1 outresult.txt

1.2 ServerList.txt

1.3 SMO Object Model - With Example.txt

1. SMO Object Model - With Example.mp4

25:24

2.1 CIS Microsoft SQL Server 2016 Benchmark v1.0.0.pdf

2.2 configurations.zip

2. How change Server or Database configuration using SMO.mp4

17:12

3.1 configuration - Max server Memory and MDOP.txt

3.2 serviceaccount.zip

3. Fixed the WMI error in PowerShell.mp4

03:02

4.1 errorlog.txt

4.2 readerrorlog.zip

4.3 serviceaccount.zip

4. Read SQL server errorlog and Service Account using SMO.mp4

15:28

10. Module 10

1.1 How to change service account and password using SMO.txt

1. How to change service account and password using SMO.mp4

11:16

11. Module 11

1.1 Day-6.pptx

1. Array in PowerShell.mp4

10:59

2.1 Array Hands-On.txt

2. Array Hands-On.mp4

42:21

3.1 How to find all obeject in sql server.txt

3.2 mydb1 tables export.txt

3.3 Script out Database Objects.txt

3. How to Script out any SQL Object using PowerShell.mp4

23:02

4.1 mydb1 tables export.txt

4.2 Script Out the database objects using out-file.txt

4.3 SQL Operation using SMO.txt

4. How to Perform SQL Operation using SMO in Powershell.mp4

25:31

5.1 Database Property using SMO.txt

5. Database Property using SMO.mp4

05:59

6.1 How to connect SQL Server using SQL Authentation using Powershell SMO and cmdlts.txt

6. Connect SQL Server with SQL Authentication using PowerShell SMO and cmdlet.mp4

07:52

7.1 createtable.zip

7.2 How to run SQL Script for Multiple of servers for each database.txt

7.3 serverlist.txt.txt

7. How to run SQL Script for Multiple of servers for each database.mp4

08:13

8.1 1.How to found SQL Jobs Failed Jobs using Powershell.txt

8. How to found SQL Jobs Failed Jobs using PowerShell.mp4

06:55

9.1 Send All failed job report in email using HTML.txt

9. Send All failed job report in email using HTML format.mp4

07:34

10.1 1.Create failed job report in HTML or Notpade.txt

10.2 2.1.Create failed job report in Notpade.txt

10.3 jobfail.html

10.4 jobfail.txt

10. Create failed job report in HTML or Notpad.mp4

03:59

11.1 how to write sql script in powershell.zip

11. How to write SQL Script in PowerShell.mp4

02:47

12.1 How to send failed job HTML Report at attachement.txt

12.2 JOb Details.html

12.3 outresult.txt

12.4 serverpro multi.zip

12. How to send failed job HTML Report at attachment.mp4

06:38

12. Module 12

1.1 1. SQL Server Backup using SMO.txt

1.2 2.How to take all database Backup.txt

1.3 3.Full Backup for all Database using Try and Catch.txt

1.4 4.Log Backup for all Database using Try and Catch -3.txt

1.5 5.Backup using CMDLETS.txt

1. SQL Server Database Backup.mp4

39:39

2.1 Database list.txt

2.2 full backup.zip

2. How to Pass multiple of parameter using single file.mp4

16:37

3.1 Database list.txt

3.2 testps.zip

3. How to work on Backup Path which is hardcoded.mp4

15:02

4.1 restore.zip

4. Database Restore Using PowerShell.mp4

05:11

5.1 jobdetails HTML.txt

5.2 jobdetails.zip

5. SQL Server Failed Job report.mp4

14:31

6.1 bcpout.zip

6. How to Insert SQL data using BCP (in and BCP out).mp4

10:34

13. Module 13

1.1 Exception Handeling with Try and Catch.docx

1.2 Exception Handeling with Try and Catch.pdf

1. Exception Handling with Try and Catch.mp4

32:12

2.1 cpu avg loadpercentage.zip

2.2 netwk.zip

2.3 serverdet.zip

2. WMIObject With Example.mp4

17:26

3.1 cpu avg.zip

3.2 cpu avg.zip

3. How to Create PowerShell Module.mp4

09:36

4.1 disk space simple.txt

4.2 Disk Space Details.html

4.3 Disk Space HTML.txt

4.4 Switch.txt

4. How to generate Disk Space HTML Report using PowerShell.mp4

41:38

5.1 cpu.zip

5.2 Disk Space Details.html

5.3 Measure-Object.txt

5. Measure-Object Example with PowerShell.mp4

06:42

14. Module 14

1.1 dbatool.txt

1.2 dbatools.docx

1.3 Function.txt

1.4 Get-DbaDiskSpace.txt

1.5 Get-DbaProcess.txt

1.6 Get-DbaTcpPort.txt

1.7 Module.txt

1.8 ServerDetailsMultipleServers.txt

1.9 Set-SqlMaxMemory.txt

1.10 test-dbapowerplan.txt

1.11 Test-SqlNetworkLatency.txt

1.12 Test-SqlTempDbConfiguration.txt

1. DBAtools.mp4

57:37

15. Module 15

1.1 all userdb dump.zip

1.2 check service.zip

1.3 disk html.zip

1.4 SQL Job Details.txt

1.5 sql job status as html body.zip

1.6 test path.zip

1. How to Run or Schedule PowerShell Script using SQL Agent.mp4

33:23

2.1 disk space report.html

2.2 disk state.zip

2.3 schtsk.txt

2.4 ser exec.txt

2. How to run PowerShell using Task Scheduler.mp4

08:51

3.1 dbatools.txt

3. SQL Server Migration with DBA Tools.mp4

25:55

4.1 all userdb dump.zip

4.2 Database list.txt

4.3 path.zip

4.4 path1.zip

4.5 test path.zip

4.6 testps.zip

4. SQL Backup Using SQL Agent JOB.mp4

38:12

16. Module 16 - HTML

1.1 Day1.txt

1.2 HTML Tut.docx

1.3 HTML BASIC DAY1.html

1.4 Today Class.txt

1. HTML Basic 1.mp4

01:08:33

2.1 basic1.txt

2.2 basic2.txt

2.3 basic3-colour controle by ID.txt

2.4 basic4-colour controle by ID.txt

2.5 basic5-colour controle by Class.txt

2.6 Colour in HTML.html

2.7 HTML Tut (1).docx

2.8 HTML BASIC DAy2 1.html

2.9 HTML BAsic Day2 2.html

2.10 HTML Basic Day2.html

2. HTML Basic 2.mp4

35:34

3.1 How to control HTML Styles using idClassAttribute.txt

3. HTML Basic 3.mp4

11:03

4.1 And add more styles.txt

4.2 both in one.txt

4.3 rowspam.txt

4.4 table with colspan example2.txt

4.5 table with colspan.txt

4.6 Table Example1.html

4.7 Table Example1.html

4.8 Table example2.html

4.9 table example3.html

4.10 table row.html

4.11 TABLE.HTML

4.12 Tableadd.html

4. HTML Table.mp4

40:20

5.1 Example1.txt

5.2 Example2.txt

5.3 html out.html

5.4 Service status in html column.txt

5.5 Service status in html row.txt

5.6 status.html

5. How to Create HTML Report using Powershell5.mp4

39:26

6.1 Disk Space report As HTML Body.txt

6.2 disk space report.html

6.3 html out.html

6.4 Send System Imformation as HTML Body.txt

6.5 Server Status report.html

6.6 service status as HTML Body.txt

6.7 SQL Job Status as HTML Body.txt

6. How to send email as HTML Body.mp4

19:49

7.1 disk space report.html

7.2 disk state (1).txt

7. Disk Status HTML Report5.mp4

41:47

17. Module 17

1.1 capture.zip

1.2 get-allocationunitcheck.zip

1.3 get-backups.zip

1.4 get-maxdop.zip

1.5 get-maxservermemory.zip

1.6 get-powerplan.zip

1.7 get-tempdbfiles.zip

1.8 github.com.txt

1.9 HOw to Defining Parameter.docx

1.10 Read and Include in next class.txt

1.11 Run Get-PowerPlan For Multiple computer.txt

1.12 Servername.txt

1.13 switch.zip

1. Script for DBA Tools with Parameter.mp4

16:41

2.1 definingparaneter1.zip

2.2 example definingparaneter1.zip

2.3 example definingparaneter2.zip

2.4 function definingparaneter1.zip

2.5 get-diskinfo.zip

2.6 mandatoryparameter.zip

2.7 New Text Document.txt

2.8 para datatype.zip

2.9 position.zip

2. Understanding PowerShell function parameter.mp4

36:37

18. Module 18

1.1 Blocking working.txt

1.2 blocking.zip

1. How to monitor Blocking using Eventvwr.mp4

10:33

2.1 clear evelog6.zip

2.2 errorlog eventvwr copy.txt

2.3 even back3.zip

2.4 event.txt

2.5 get 5 log.txt

2.6 get-even-8.zip

2.7 limit-eventlog4.zip

2.8 new-eventlog5.zip

2.9 remove-eventlog7.zip

2.10 show-event1.zip

2.11 write-eventlog2.zip

2. Working with Eventvwr using PowerShell.mp4

36:23

19. Module 19

1.1 Advanced Function and Verbous.txt

1.2 Common Parameters.txt

1.3 Day-13.pptx

1.4 Exception Handeling with Try and Catch.docx

1. Advance Function and Common Parameters.mp4

01:18:24

2.1 Authentacation Mode for Single server.txt

2.2 Finding Authentacation Mode for Multiple of server.txt

2. Script to finding SQL Authentication Mode for Multiple of server.mp4

07:20

3.1 Failed login information for current Date.txt

3.2 finding Login failed using powershell.txt

3. Report for Failed Login using PowerShell.mp4

07:40

4.1 Kill the session if any blocking hapend - automate using powershell.txt

4. Kill the session if any blocking happened - automate using PowerShell.mp4

06:27

5.1 Login Information.txt

5. Login Information.mp4

03:10

6.1 Writing Blocking Information to eventvwr for multiple of server with Try and Catch.txt

6. Writing Blocking Information to eventvwr for multiple of server with Try $ Catch.mp4

07:41

20. Module 20

1.1 Fragment details for all index for Database.txt

1.2 fragment for particular schema and table.zip

1. Check fragment of Index using PowerShell script.mp4

08:52

2.1 job.zip

2.2 jobscp.zip

2. How to create SQL Job using PowerShell Script.mp4

14:18

3.1 capture.zip

3.2 rebuilt or reorg of index using powershell script.zip

3. How to do Rebuilt or Reorg of Index using PowerShell Script.mp4

07:36

4.1 exe job.zip

4. How to Execute SQL Job using PowerShell.mp4

04:16

5.1 sched job.zip

5. How to schedule a Job Using PowerShell.mp4

08:28

6.1 Backup Report.html

6.2 backup.zip

6.3 HTML Backup report for those database backup not happend from past 12 hr.txt

6. HTML Backup report for those database backup not happened from past 12 hrs..mp4

19:29

7. HTML Backup report for those database backup not happened from past 12 hrs. - P2.mp4

02:21

8.1 DBOwner Details.html

8.2 Selete DB property in html.txt

8.3 serverlist.txt

8. HTML Report for DB Owner - Multiple Servers.mp4

05:29

9.1 Disk Space Details.html

9.2 owner.zip

9. HTML Report for DB Owner - Single Server.mp4

07:08

Description

Automation, Automation using PowerShell, PowerShell Scripting for SQL Server Database Administrator, PowerShell for SQL

What You'll Learn?

Learn PowerShell Scripting for SQL Server Database Administrator from scratch and fulfill their own dream for automation
Learn about Automation Using PowerShell for SQL server DBA daily task.
In this course you will get in depth knowledge of PowerShell after that you will be able to develop the script using PowerShell easily.
You will get total 100+ scripts, you can download and start doing the practice after each session.
Frequently uploading the video. For doubt clarification I will provide my email so that you can send me mail for any doubt.
Learn about PowerShell, Automation, scripting, Creating HTML Reporting with Color format!...
Acclerate about your career to becomes the future-ready Automation Engineer for SQL Server database administrator
Create HTML Report for SQL DBA Task and sent in email
HTML Reporting Using PowerShell
Automation Using Powershell Script for AZURE/Cloud SQL Server DBA
This course has designed in such a way that anyone having the basic knowledge of DBA, they can easily learn and develop PowerShell script at the end of course.

Who is this for?

SQL database administrator

SQL DBA

All the SQL database administrator who wants to learn the Automation using PowerShell

All the SQL database administrator who wants to automate the daily DBA Tasks

Automation for Azure Cloud for SQL DBA

HTML Report using Powershell for SQL Server

Health Check Report for SQL server

Doing multiple work for multiple of Server

PowerShell Scripting

Anybody who is interested in Automating tasks for SQL DBA can checkout this video. You can play around using the commands and scripts to create your own Application.

Become competent by learning PowerShell automation and stand different in the CROWD

What You Need to Know?

No Prior PowerShell Knowledge is required. You will learn everything you need to know.

Need Knowledge on SQL server DBA concepts

No Prior HTML Knowledge is required. You will learn everything you need to know.

No Prior SQL Programming Knowledge is required. You will learn everything you need to know.

Eagerness to learn PowerShell Scripting

More details

Description
In this course you will get in depth knowledge of PowerShell after that you will be able to develop the script using PowerShell easily.
Basically, this course has been divided in to 20 sessions/Module which include the HTML Session, Evendu you will find the others additional session in this course, which will be the subcategory of the main course. For Sub-category you have to go through each Module.
I am going to provide and discussed total 100+ script, you can download and start doing the practice after each session.
I will be frequently uploading the video. For doubt clarification I will provide my email so that you can send me mail for any doubt.
This course has designed in such a way that anyone having the basic knowledge of DBA, they can easily learn and develop the script using PowerShell for SQL DBA at the end of this course.

In this session will cover that how to start writing the PowerShell script from basic to advance level. It will be going to include Daily DBA Task like - Backup, Restore, how to script the Database objects, creating and scheduling SQL Job in Single or Multiple servers. Running the script in multiple servers, BCP IN and BCP out, how to schedule the script using task scheduler or SQLÂ Agent and many more things. How to pass the parameter using config file, creating own module ETC.
Standard way of writing the script.
1. Generating log file for any script.
2. Ping the server.
3. Passing multiple parameters using single configuration file.
4. Creating function in script
5. Displaying the result in color
6. Adding the time stamp in log file.
7. Setting the variable
8. Registry level of information

Monitoring / Generating Report
In this session we are going to work on SQL Server Monitoring Part and Generating and sending the alert/Notification using email in HTML body or as attachments. As per below screen shot
This report has been generated for Database file usage as HTML body.
We are going to learn that how to generate the Health check report and monitoring the many things.
a. Monitoring like Database data files and log file space.
b. Disk space monitoring for single of multiple of servers.
c. CPU or Ram usage monitoring.
d. Long running job, Blocking, Deadlock etc
e. Creating report for Backup status.
f. Job Failed status report.
g. Sending the alert/Notification if any services will be down.

Â· HTML

a. Basic of HTML
b. Static and Dynamic HTML Report
c. How customize the HTML report and adding some comment.
d. Sending email in the format of HTML body using PowerShell.
Â· Cloud (Going to be Uploaded very Soon)
a. Basic of Azure Cloud
b. How to develop the PowerShell scripts for AZURE cloud.

Who this course is for:
SQL database administrator
SQL DBA
All the SQL database administrator who wants to learn the Automation using PowerShell
All the SQL database administrator who wants to automate the daily DBA Tasks
Automation for Azure Cloud for SQL DBA
HTML Report using Powershell for SQL Server
Health Check Report for SQL server
Doing multiple work for multiple of Server
PowerShell Scripting
Anybody who is interested in Automating tasks for SQL DBA can checkout this video. You can play around using the commands and scripts to create your own Application.
Become competent by learning PowerShell automation and stand different in the CROWD

User Reviews

Rating

average 0

Total votes0

Focused display

Trainer ProfileRajesh Kumar Jaiswal SQL Server DBA, PowerShell Script Writer, Performance Tuning for SQL Server , AWS and SQL DBA for AZURE, Doing Automation for SQL DBA Task. Summary:More than 14+ year of experience in SQL server SQL Server DBA, PowerShell Script Writer, Performance Tuning for SQL Server, AWS and SQL DBA for AZURE training.Worked on numerous projects related to deployment and maintains of SQL server 7.0/2000/2005/2008/2008 R2/2012 on Windows 2000/2003/2008/2008 R2/2012/2014/2016 platform.Worked on numerous projects related to deployment and maintains for PowerShell Script.Conducted numerous trainings on SQL Server 2000/2005/2008/2008 R2/2012/2016 for Performance tuning with the help of PowerShell Script, Third PartyConducted numerous trainings for Cloud Technology like – HP Cloud, AWS and Azure.

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.