Tech Blog – Scripts

---

PowerShell

Count Rows Within A .CSV File

Check A Port Is Open

Disk Management

Set IP Address

Create Firewall Rule

Map Network Drive

Compress & Password Protect Files

Send An Email

---

SQL Server – Diagnostic

Get Hardware Info

Get Database Level Configs (Recovery, Log & Common Options)

Get Last Backup Times

Get Sizes Of All Databases

Get Table Sizes (Database Scoped)

Get CPU Utilisation By Database

Get I/O Utilisation By Database

Get Top Avg. Elapsed Query Time On Instance

Get Most Frequently Executed Queries On Database

Get SQL Agent & Category Info

Get Database File Path & Growth Info

Get Fragmentation & Forward Record Counts

Get Database Growth Events

Get VLF Counts For All Databases

---

SQL Server – Operational

Heal Logins

Kill SPIDs

Kill All User SPIDs

BCP with XP_CmdShell

Add Primary Key Constraint

Move TempDB Files

Batch Deletions

Shrink DB In Chunks

Create Database

Create Table & Insert Data

---

SQL Server – ETL

Show Only The Domain Of An Email Address

Get Rightmost Word In Column

Get Row Counts By Date

Converting VARCHAR To DATE

Splitting And Grouping By Months

---