Tech Blog – Scripts

PowerShell
MSSQL Diagnostic
MSSQL Operational
MSSQL ETL
Linux

---

PowerShell

# Count Rows within a .CSV File.
# Check a Port is Open.
# Disk Management.
# Set IP Address.
# Create Windows 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

# Selecting Dates & Times.
# 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.

---

Linux

# General Info.
# Hardware Info.
# Performance Info.
# User & Group Management.
# Directories & File Manipulation.

---