Dbachecks Powershell T-Sql-Tuesday

T-SQL Tuesday #130 – Automate Your Stress Away

Scheduling dbachecks with task scheduler to help automate away the stress

Dbachecks Powershell

dbachecks meets ImportExcel

Getting dbachecks results into Excel thanks to the excellent ImportExcel PowerShell module

Dbatools Powershell

Get a list of databases from named SQL Instances

Quick script to help you find databases on named SQL Instances.

Powershell

Using Get-WinEvent to look into the past

Troubleshooting incidents - use PowerShell and Get-WinEvent to help collect windows event logs.

Dbatools Powershell

Truncate all the Tables in a Database with PowerShell

Some scripts to help us truncate all the tables in a database